My Oracle Support Banner

R12: AP/XLA: Cash SOB Accounting Failed for Payment XLA_AP_BFLOW_PE_NOT_FOUND_DTL (Doc ID 1962369.1)

Last updated on OCTOBER 13, 2020

Applies to:

Oracle Payables - Version 12.0.6 to 12.2 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

 

Cannot create accounting for payment.
The following scenario occurred before trying to account the payment:
The original invoice was from 11i and voided a payment on this invoice which was successful.
Created a payment on R12,voided this payment which was not successful.


ERROR:

The following error occurs in the XLA_ACCOUNTING_ERROR table:

Line Error Number  Error Message
0  This line cannot be accounted until the accounting event that it references has been fully accounted.
Please ensure the accounting events for the transaction with the following identifiers for the application Payables have been accounted:
invoice_id: xxxxx.

 


Run online create accounting on payment with FND Debug Log activated:

xla.plsql.xla_accounting_err_pkg.stack_error 2 BEGIN of procedure STACK_ERROR
xla.plsql.xla_accounting_err_pkg.stack_error 2 p_appli_s_name = XLA
xla.plsql.xla_accounting_err_pkg.stack_error 2 p_msg_name = XLA_AP_BFLOW_PE_NOT_FOUND_DTL
xla.plsql.xla_accounting_err_pkg.stack_error 2 p_entity_id =
xla.plsql.xla_accounting_err_pkg.stack_error 2 p_event_id = xxxxx
xla.plsql.xla_accounting_err_pkg.stack_error 2 p_ledger_id = xxx
xla.plsql.xla_accounting_err_pkg.stack_error 2 p_ae_header_id =
xla.plsql.xla_accounting_err_pkg.stack_error 2 p_ae_line_num =
xla.plsql.xla_accounting_err_pkg.stack_error 2 p_accounting_batch_id =
xla.plsql.xla_accounting_err_pkg.stack_error 1 l_msg_number = 0
xla.plsql.xla_accounting_err_pkg.stack_error 2 END of procedure STACK_ERROR
xla.plsql.xla_accounting_err_pkg.build_message 2 END of procedure BUILD_MESSAGE
xla.plsql.xla_accounting_errors_pkg.msg_bflow_pe_not_found 2 END of procedure msg_bflow_pe_not_found
xla.plsql.xla_accounting_errors_pkg.common_modify_message 2 END of procedure common_modify_message
xla.plsql.xla_accounting_errors_pkg.modify_message 2 END of procedure modify_message

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!


In this Document
Symptoms
Changes
Cause
Solution
 Standard Patching Process
 Patch Wizard
 Have more questions?
References


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