My Oracle Support Banner

R12: AP: Error "0 - This line Cannot be Accounted Until the Accounting Event that it References has been Fully Accounted." (XLA_AP_BFLOW_PE_NOT_FOUND) When Attempting to Create Accounting For Invoices with Prepayment Applied (Doc ID 2867796.1)

Last updated on OCTOBER 04, 2022

Applies to:

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

Symptoms

Unable to account Invoice with prepayment applied.

'PREPAYMENT APPLIED' event has below Accounting error:

"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: 12####53."

The Subledger Accounting Report shows the error

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: 12####53.

And, the Create Accounting FND Debug Log shows the following:

MODULE LOG_LEVEL MESSAGE_TEXT
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
fnd.src.process.fdpwrt.fdpwrt.log_write 3 **Starts**
xla.plsql.xla_accounting_err_pkg.initialize 2 BEGIN of procedure INITIALIZE
xla.plsql.xla_accounting_err_pkg.initialize 2 p_client_id = 
xla.plsql.xla_accounting_err_pkg.initialize 2 p_error_limit = 
xla.plsql.xla_accounting_err_pkg.initialize 2 p_error_source = 
xla.plsql.xla_accounting_err_pkg.initialize 2 p_request_id = 
xla.plsql.xla_accounting_err_pkg.initialize 2 p_application_id = 
xla.plsql.xla_accounting_err_pkg.reset 2 BEGIN of procedure RESET
xla.plsql.xla_accounting_err_pkg.reset 2 END of procedure RESET
xla.plsql.xla_accounting_err_pkg.initialize 2 END of procedure INITIALIZE
xla.plsql.xla_accounting_pkg.unit_processor_batch 2 BEGIN of procedure UNIT_PROCESSOR_BATCH
xla.plsql.xla_accounting_pkg.unit_processor_batch 2 p_application_id = 200
xla.plsql.xla_accounting_pkg.unit_processor_batch 2 p_ledger_id = 324
xla.plsql.xla_accounting_pkg.unit_processor_batch 2 p_end_date = 2022/05/31
xla.plsql.xla_accounting_pkg.unit_processor_batch 2 p_accounting_mode = F
xla.plsql.xla_accounting_pkg.unit_processor_batch 2 p_error_only_flag = N
xla.plsql.xla_accounting_pkg.unit_processor_batch 2 p_accounting_batch_id = 641472
xla.plsql.xla_accounting_pkg.unit_processor_batch 2 p_parent_request_id = 168493668
xla.plsql.xla_accounting_pkg.unit_processor_batch 2 p_report_request_id = 168493668
xla.plsql.xla_accounting_pkg.unit_processor_batch 2 p_queue_name = XLA.XLA_168493668_DOC_Q
xla.plsql.xla_accounting_pkg.unit_processor_batch 2 p_comp_queue_name = XLA.XLA_168493668_COMP_Q
xla.plsql.xla_accounting_pkg.unit_processor_batch 2 p_error_limit = 
...
... 
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 2 BEGIN of procedure LOAD_APPLICATION_LEDGERS
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 2 p_application_id = 200
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 2 p_event_ledger_id = 324
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 2 p_max_event_date = 31-MAY-22
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 Reading application level cache for application 200
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 xla_event_appl_short_name = SQLAP
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 xla_creation_date = 04-MAY-22
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 xla_entry_created_by = 65217
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 application_id = 200
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 valuation_method_flag = N
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 control_account_enabled_flag = Y
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 xla_alc_enabled_flag= Y
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 Reading ledger level cache for ledger 324
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 application_name = Payables
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 user_je_source_name = Payables
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 ledger_name = JOxxxxxxxxxxxxxxxxxxxxxSOB
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 ledger_coa_name = Accounting Flexfield
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 session_coa_name = Accounting Flexfield
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 ledger_slam_name = JEI Standard Accrual
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 session_slam_name = JEI Standard Accrual
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 dynamic_inserts_allowed_flag = Y
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 coa_id = 101
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 slam_type = C
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 xla_currency_code = USD
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 xla_description_language = US
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 xla_nls_desc_language = AMERICAN
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 xla_entered_cur_bal_sus_ccid = 1197286
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 xla_ledger_cur_bal_sus_ccid = 4034323
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 res_encumb_code_combination_id = 
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 ledger_category_code = PRIMARY
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 ledger_currency_precision = 2
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 coa_mapping_id = 
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 coa_mapping_name = 
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 bal_seg_column_name = SEGMENT1
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 mgt_seg_column_name = 
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 xla_ledger_cur_bal_flag = Y
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 xla_acct_reversal_option_code = SIDE
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 sla_ledger_id = 324
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 latest_encumbrance_year = 2013
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 bal_seg_value_option_code = I
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 mgt_seg_value_option_code = A
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 allow_intercompany_post_flag = Y
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 transaction_calendar_id = 
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 enable_average_balance_flag = N
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 effective_date_rule_code = R
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 Number of alc ledgers = 0
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 Caching product definitions for the ledger 324
xla.plsql.xla_cmp_hash_pkg.BuildPackageName 2 BEGIN of BuildPackageName
xla.plsql.xla_cmp_hash_pkg.BuildPackageName 2 p_application_id = 200 - p_product_rule_code = JEI_ACCRUAL - p_product_rule_type_code = C - p_amb_context_code = DEFAULT 
xla.plsql.xla_cmp_hash_pkg.SearchPAD 2 BEGIN of SearchPAD
xla.plsql.xla_cmp_hash_pkg.SearchPAD 2 return value. = TRUE
xla.plsql.xla_cmp_hash_pkg.SearchPAD 2 END of SearchPAD
xla.plsql.xla_cmp_hash_pkg.GetPackageName 2 BEGIN of GetPackageName
xla.plsql.xla_cmp_hash_pkg.GetPackageName 2 p_application_id = 200 - p_product_rule_type_code = C - p_product_rule_hash_id = 17 
xla.plsql.xla_cmp_hash_pkg.GetPackageName 2 return value. package_name = XLA_00200_AAD_C_000017_PKG 
xla.plsql.xla_cmp_hash_pkg.GetPackageName 2 END of GetPackageName
xla.plsql.xla_cmp_hash_pkg.BuildPackageName 2 END of BuildPackageName
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 rule_id = 132
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 amb_context_code = DEFAULT
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 pad_type = C
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 pad_code = JEI_ACCRUAL
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 ledger_pad_name = JEI Accrual Basis
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 session_pad_name = JEI Accrual Basis
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 pad_package_name = XLA_00200_AAD_C_000017_PKG 
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 compile_status = Y
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 start_date = 01-JAN-51
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 end_date = 
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 Number of PADs = 1
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 Reading ledger level cache for ledger 325
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 application_name = Payables
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 user_je_source_name = Payables
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 ledger_name = JOxxxxxxxxxxxxxxxxxxx STAT
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 ledger_coa_name = Accounting Flexfield
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 session_coa_name = Accounting Flexfield
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 ledger_slam_name = JEI Standard Accrual
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 session_slam_name = JEI Standard Accrual
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 dynamic_inserts_allowed_flag = Y
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 coa_id = 101
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 slam_type = C 
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 xla_currency_code = MXN
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 xla_description_language = US
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 xla_nls_desc_language = AMERICAN
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 xla_entered_cur_bal_sus_ccid = 1197286
xla.plsql.xla_accounting_cache_pkg.load_application_ledgers 1 xla_ledger_cur_bal_sus_ccid = 
  ...
  ...
xla.plsql.xla_accounting_cache_pkg.GetCurrencyMau 2 BEGIN of procedure GetCurrencyMau
xla.plsql.xla_accounting_cache_pkg.GetCurrencyMau 2 END of procedure GetCurrencyMau:.01
xla.plsql.XLA_AE_LINES_PKG.BusinessFlowPriorEntries 3 # bflow error lines = 2
xla.plsql.XLA_AE_LINES_PKG.BusinessFlowPriorEntries 3 l_array_event_id(i):1447589167
xla.plsql.XLA_AE_LINES_PKG.BusinessFlowPriorEntries 3 l_array_pe_entity_id(i):1386037395
xla.plsql.xla_accounting_errors_pkg.modify_message 2 BEGIN of procedure modify_message
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_application_id = 200
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_appli_s_name = XLA
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_msg_name = XLA_AP_BFLOW_PE_NOT_FOUND 
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_token_1 = APPLICATION_NAME
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_value_1 = Payables
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_token_2 = APPLIED_TO_ENTITY_ID
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_value_2 = 1386037395
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_token_3 = APPLIED_TO_ENTITY_CODE
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_value_3 = AP_INVOICES
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_token_4 = APPLICATION_ID
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_value_4 = 200
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_token_5 = 
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_value_5 = 
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_token_6 = 
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_value_6 = 
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_entity_id = 
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_event_id = 1447589167
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_ledger_id = 324
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_ae_header_id = 
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_ae_line_num = 
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_accounting_batch_id = 
xla.plsql.xla_accounting_errors_pkg.common_modify_message 2 BEGIN of procedure common_modify_message
xla.plsql.xla_accounting_errors_pkg.msg_bflow_pe_not_found 2 BEGIN of procedure msg_bflow_pe_not_found
xla.plsql.xla_datafixes_pub.get_transaction_details 2 BEGIN of procedure get_transaction_details
xla.plsql.xla_datafixes_pub.get_transaction_details 2 p_application_id:200
xla.plsql.xla_datafixes_pub.get_transaction_details 2 p_entity_id:1386037395
xla.plsql.xla_datafixes_pub.get_transaction_details 2 "l_transaction_entity_sql  :SELECT 'invoice_id: ' ||ENT.SOURCE_ID_INT_1 TRX_COL_1,NULL TRX_COL_2,NULL TRX_COL_3,NULL TRX_COL_4
                  FROM xla_transaction_entities ent
                  WHERE ent.application_id = :1
                  AND  ent.entity_id       = :2 "
xla.plsql.xla_accounting_err_pkg.build_message 2 BEGIN of procedure BUILD_MESSAGE
xla.plsql.xla_accounting_err_pkg.build_message 2 p_appli_s_name = XLA
xla.plsql.xla_accounting_err_pkg.build_message 2 p_msg_name = XLA_AP_BFLOW_PE_NOT_FOUND_DTL 
xla.plsql.xla_accounting_err_pkg.build_message 2 p_token_1 = APPLICATION_NAME
xla.plsql.xla_accounting_err_pkg.build_message 2 p_value_1 = Payables
xla.plsql.xla_accounting_err_pkg.build_message 2 p_token_2 = TRX_DATA
xla.plsql.xla_accounting_err_pkg.build_message 2 p_value_2 = invoice_id: 12951953
xla.plsql.xla_accounting_err_pkg.build_message 2 p_entity_id = 
xla.plsql.xla_accounting_err_pkg.build_message 2 p_event_id = 1447589167
xla.plsql.xla_accounting_err_pkg.build_message 2 p_ledger_id = 324
xla.plsql.xla_accounting_err_pkg.build_message 2 p_ae_header_id = 
xla.plsql.xla_accounting_err_pkg.build_message 2 p_ae_line_num = 
xla.plsql.xla_accounting_err_pkg.build_message 2 p_accounting_batch_id = 
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 = 1447589167
xla.plsql.xla_accounting_err_pkg.stack_error 2 p_ledger_id = 324
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
xla.plsql.XLA_AE_LINES_PKG.BusinessFlowPriorEntries 3 l_array_event_id(i):1447589167
xla.plsql.XLA_AE_LINES_PKG.BusinessFlowPriorEntries 3 l_array_pe_entity_id(i):1386037395
xla.plsql.xla_accounting_errors_pkg.modify_message 2 BEGIN of procedure modify_message
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_application_id = 200
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_appli_s_name = XLA
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_msg_name = XLA_AP_BFLOW_PE_NOT_FOUND 
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_token_1 = APPLICATION_NAME
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_value_1 = Payables
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_token_2 = APPLIED_TO_ENTITY_ID
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_value_2 = 1386037395
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_token_3 = APPLIED_TO_ENTITY_CODE
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_value_3 = AP_INVOICES
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_token_4 = APPLICATION_ID
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_value_4 = 200
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_token_5 = 
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_value_5 = 
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_token_6 = 
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_value_6 = 
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_entity_id = 
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_event_id = 1447589167
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_ledger_id = 325
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_ae_header_id = 
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_ae_line_num = 
xla.plsql.xla_accounting_errors_pkg.modify_message 2 p_accounting_batch_id = 
...
...

 

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
References


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