FND load for particular DFF Context

FNDLOAD apps/ebsd_apps_2012 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XXGF_INV_STD_ORG_FABS_DFF_ATTR7.ldt DESC_FLEX APPLICATION_SHORT_NAME=FND DESCRIPTIVE_FLEXFIELD_NAME="FND_COMMON_LOOKUPS" DEFAULT_CONTEXT_FIELD_NAME="XXGF_INV_STD_ORG_FABS" DESCRIPTIVE_FLEX_CONTEXT_CODE="XXGF_INV_STD_ORG_FABS" END_USER_COLUMN_NAME="Consolidated AFB" APPLICATION_COLUMN_NAME="ATTRIBUTE7"

Xml Bursting - Email

This summary is not available. Please click here to view the post.

XML Bursting - Printer

<?xml version="1.0" encoding="UTF-8"?>
-<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi"> <xapi:globalData location="stream"/> -<xapi:request select="/MSIONT_PACKING_LIST/"> -<xapi:delivery> 
<!--Printer Delivery Method-->
 <xapi:print copies="1" printer="ipp://localhost:631/printers/${CF_PRINTER_NAME}" id="Printer"/> </xapi:delivery> -<xapi:document delivery="Printer" output-type="pdf"> <xapi:template location="xdo://ONT.ONT_PACKING_LIST.en.US//?getSource=true" locale="" type="rtf"/> </xapi:document> </xapi:request> </xapi:requestset>

How to find the File Version

SELECT fi.file_id, filename, version
FROM apps.ad_files fi, apps.ad_file_versions ve
WHERE filename LIKE 'ozfvarib.pls' AND ve.file_id = fi.file_id AND version =
(SELECT MAX (version) FROM apps.ad_file_versions ven WHERE ven.file_id =  
fi.file_id);  

Long Running Statements

rem LONGOPS.SQL
rem Long Running Statements
rem Helmut Pfau, Oracle Deutschland GmbH
set linesize 120
col opname format a20
col target format a15
col units format a10
col time_remaining format 99990 heading Remaining[s]
col bps format 9990.99 heading [Units/s]
col fertig format 90.99 heading "complete[%]"
select sid,
       opname,
       target,
       sofar,
       totalwork,
       units,
       (totalwork-sofar)/time_remaining bps,
       time_remaining,
       sofar/totalwork*100 fertig
from   v$session_longops
where  time_remaining > 0
/ 

Clear Apache Cache from Application

Clear Apache Cache from Application without bouncing listener.

While going through one of the HRMS blogs i stumbled on a very interesting article on how to clear the Apache cache without bouncing the listener. Here are the steps:

1. Navigate to "Functional Administrator" responsibility.
2. Once logged in click on the "Core Services" tab.
3. Click on "Caching Framework" link in the blue menu bar.
4. Click on "Global Configuration" link in the left vertical menu.
5. In the "Cache Policy" region click on the "Clear All Cache" button.
6. Click the "Yes" button to confirm the action.
7. Click the "Apply" button to apply the changes.

The above steps will clear the apache cache without the need of bouncing by the DBA's

REVERSING a Receipt

DECLARE
   l_return_status     VARCHAR2 (1);
   l_msg_count         NUMBER;
   l_msg_data          VARCHAR2 (240);
   l_count             NUMBER;
   l_cash_receipt_id   NUMBER;
   l_msg_data_out      VARCHAR2 (240);
   l_mesg              VARCHAR2 (240);
   p_count             NUMBER;
BEGIN
   arp_standard.enable_debug;
   arp_standard.enable_file_debug ('/usr/tmp', 'Api_Create.log');
   ar_receipt_api_pub.REVERSE (p_api_version                 => 1.0,
                               p_init_msg_list               => fnd_api.g_true,
                               p_commit                      => fnd_api.g_true,
                               p_validation_level            => fnd_api.g_valid_level_full,
                               x_return_status               => l_return_status,
                               x_msg_count                   => l_msg_count,
                               x_msg_data                    => l_msg_data,
                               p_receipt_number              => '&receipt_number',
                               p_reversal_category_name      => 'Reverse Payment',             --values can be modified.
                               p_reversal_reason_name        => 'Nsf'                         -- values can be modified.
                              );
   DBMS_OUTPUT.put_line (   'Message count '
                         || l_msg_count);
   DBMS_OUTPUT.put_line (   'Status '
                         || l_return_status);

   IF l_msg_count = 1
   THEN
      DBMS_OUTPUT.put_line (   'l_msg_data A '
                            || RTRIM (LTRIM (l_msg_data))
                            || '****');
   ELSIF l_msg_count > 1
   THEN
      LOOP
         p_count :=   p_count
                    + 1;
         l_msg_data := fnd_msg_pub.get (fnd_msg_pub.g_next, fnd_api.g_false);

         IF l_msg_data IS NULL
         THEN
            EXIT;
         END IF;

         DBMS_OUTPUT.put_line (   'Message'
                               || p_count
                               || ' ---'
                               || l_msg_data);
      END LOOP;
   END IF;

   arp_standard.disable_debug;
END;