R12: Create Accounting Error: An internal error has occurred in the program xla_ap_acct_hooks_pkg.main (Doc ID 1550231.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

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

Symptoms

Create accounting failed with error displayed in accounting program log file :


An internal error occurred. Please inform your system administrator or support representative that:

An internal error has occurred in the program xla_ap_acct_hooks_pkg.main. Technical problem : Error encountered in product API for postpro
An internal error occurred. Please inform your system administrator or support representative that:

An internal error has occurred in the program xla_ap_acct_hooks_pkg.main. Technical problem : Error encountered in product API for postpro

 

Fnd  Log file show:


Technical problem : Error encountered in product API for postprocessing
SQLERRM occurred in Maintain_DBI_Summary
AP_SLA_PROCESSING_PKG.POSTPROCESSING_PROC with parameters (Table_Name =
AP_INVOICE_DISTRIBUTIONS, Operation = U, Key_Value1 = ) while performing the
following operation: looping through elements
clean up and set back posted flag value to N

APP-SQLAP-10000: SQLERRM occurred in Maintain_DBI_Summary
AP_SLA_PROCESSING_PKG.POSTPROCESSING_PROC with parameters (Table_Name =
AP_INVOICE_DISTRIBUTIONS, Operation = U, Key_Value1 = ) while performing the
following operation: looping through elements

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