Create Accounting Process Ran And Resulted In Error Invoices Stuck at Selected for Accounting (Doc ID 2221226.1)

Last updated on DECEMBER 02, 2022

Applies to:

Symptoms

On : 11.1.11.1.0 version, Manage Accounts Payable Balances-Close Payables Period

Create Accounting Process ran and resulted in error.



ERROR
-----------------------
An internal error occurred.
 Cause: An internal error has occurred in the program xla_ap_acct_hooks_pkg.main, Technical problem : Error encountered in product API for extract
Application error ORA-01403: no data found occurred while performing operation {DEBUG_INFO} with parameters {PARAMETERS} in package ap_sla_processing_pkgSKIP_LOCKED_EVENTS<-AP_SLA_PROCESSING_PKG.EXTRACT.
An application error has occurred. Your help desk can use the following information to obtain a more detailed description of this incident: Incident ID: 1170_ABC2, Instance: em2bvjf2, Product: EM2BVJF..
 Action: Inform your system administrator or support representative.
An application error has occurred. Your help desk can use the following information to obtain a more detailed description of this incident: Incident ID: 1171_ABC2, Instance: ABC2, Product: ABC2.

Some invoices may become stuck at Selected for Accounting = posted_flag on ap_invoice_distributions_all = 'S'





STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run the Create Accounting Process

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot perform accounting.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.