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

Last updated on APRIL 27, 2017

Applies to:

Oracle Fusion Payables Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

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: 1171_em2bvjf2, 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: 1172_em2bvjf2, Instance: em2bvjf2, Product: EM2BVJF.

 

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

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