My Oracle Support Banner

Payables Open Interface Import Request Failed (Doc ID 2406883.1)

Last updated on JUNE 03, 2018

Applies to:

Oracle Payables - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

 "Payables Open Interface Import"  Request failed with the following error:

Request_id xxxxxx
(Import_invoice 0.1) Calling Caching Function for Org Id/Name 
Cache_Org_Id_Name <- Import_invoices<- Before Report Trigger 
Caching Org_id , Name from MO: Security Profile 
Caching Org_id  from Financials Systems 
(Import_Invoices 0.2)  Calling Caching Function for Currency 
Cache_Fnd_Currency <- Import_invoices<- Before Report Trigger 
Caching Currency from Fnd Currency 
(Import_Invoices 0.3) Calling Caching Function for Payment Method 
Cache_Payment_Method <- Import_invoices<- Before Report Trigger 
Caching Payment Method from IBY 
(Import_Invoices 0.4) Calling Caching Function for Payment Group 
Cache_Pay_group <- Import_invoices<- Before Report Trigger 
Caching Pay Group from PO Lookup Codes 
(Import_Invoices 0.5) Caching Structure Id 
(Import_invoice 1) Check control table for the import batch 
(Import_invoice 2) Print Source 
p_sourceBPM INVOICE 
(Import Invoice 3) Delete Rejections from previous failed imports 
(Check_lines 3a) Select all the Rejected Invoices 
(Check_lines 3b) Delete invoices from ap_interface_rejections 
(Check_lines 3c) Update requestid on the Selected Invoices 
(Import Invoice 4) Update the org_id 
(Import_Invoices 4a) Updating Interface WHERE org_id is null but operating unit  
is not null 
(Import_Invoices 4b) Getting Deafult Operating Unit Information 
(Import Invoices 5) Get The Total Number of Invoices In Interface 
(Import_Invoices 5a) Total Invoices l_stmt:SELECT count(*) FROM ap_invoices_inte 
rface   WHERE source = 'BPM INVOICE'  AND ((status is NULL) or (status = 'REJECT 
ED'))  AND group_id =  'xxxxx'  AND NVL(invoice_type_lookup_code, 'S 
TANDARD') <> 'PAYMENT REQUEST'  AND ( (org_id IS NULL) OR (org_id IS NOT NULL AN 
D org_id  = 81) )  AND nvl(workflow_flag,'D') = 'D'  
(Import_Invoices 4c) Total Invoices: l_total_count:1 
(Import_Invoices 4d) l_continue_flag:Y 
(Import_invoice 5.5)  Unwinding Caching Org Id/Name 
Index Value: 81, MOAC Cached Org_Id: 81, MOAC Cached Operating Unit: SXF_OU_101_ xx
Index Value: 81, FSP Cached Org_Id: 81 
ORA-06508: PL/SQL: PL/SQL: Could Not Find Program Unit

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.