How to Capture Debug Log for Payables Open Interface Import submitted by Pay on Receipt Auto Invoice ? (Doc ID 1431573.1)

Last updated on MARCH 12, 2012

Applies to:

Oracle Inventory Management - Version: 11.5.10 to 12.2 - Release: 11.5 to 12.2
Oracle Payables - Version: 11.5.10.0 to 12.2   [Release: 11.5 to 12.2]
Information in this document applies to any platform.
EXECUTABLE:POXPOIV - Pay On Receipt AutoInvoice
REPORT:APXIIMPT.RDF - Payables Open Interface Import

Goal

In System Administrator the p_debug switch is set to 'Y' for the Payables Open Interface Import (APXIIMPT).

1. In Purchasing Run the Pay on Receipts Auto Invoice, Payables Import will start/complete.
2. The log file for APXIIMPT shows p_debug_switch='N'

APXIIMPT cannot be debugged after running POXPOIV, the p_debug changes to 'N' because of hard coding of p_debug switch. POXIVCRB.pls is set to only run with the p_debug to 'N'.

x_request_id := fnd_request.submit_request(
'SQLAP',
'APXIIMPT',
NULL,
NULL,
FALSE,
p_source,
p_group_id,
p_batch_name,
null, -- hold name
null, -- hold reason
null, -- gl date
'N', -- purge flag
'N', -- trace switch
'N', -- debug switch
'N', -- summary flag
TO_CHAR(1000), -- commit batch size
TO_CHAR(p_user_id), -- user_id
TO_CHAR(p_login_id), -- login_id
fnd_global.local_chr(0),NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL);

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms