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"
Oracle - eBIZ
It is an effort to make my blog a Knowledge repository and Solution Center which provides unique technical and functional solutions for EBS professionals.
ORACLE
Wednesday, May 21, 2014
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>
-<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);
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.
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;
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;
Subscribe to:
Posts (Atom)