Online accounting could not be created for this transaction. Please inform your system administrator that the create accounting program has encountered an internal error in AR.

By
Advertisement
Problem
Online accounting could not be created for this transaction. Please inform your system administrator that the create accounting program has encountered an internal error in AR.

Please help me out to resolve this issue.Here is log file

Subledger Accounting: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

XLAACCUP module: Accounting Program
---------------------------------------------------------------------------

Current system time is 15-APR-2012 12:47:31

---------------------------------------------------------------------------

**Starts**15-APR-2012 12:47:31
**Ends**15-APR-2012 12:47:57
Unit Processor completed normally with some events in error
---------------------------------------------------------------------------
Start of log messages from FND_FILE
---------------------------------------------------------------------------
15-APR-2012 13:10:21 - Executing Unit Processor ...
15-APR-2012 13:10:21 - Initializing variables
15-APR-2012 13:10:21 - Security Context Set
15-APR-2012 13:10:21 - Ready to cache the Application and Ledger Level Sources ...
15-APR-2012 13:10:21 - Cached the Application and Ledger Level Sources
15-APR-2012 13:10:21 - Entering the loop to read document units from the queue ...
15-APR-2012 13:10:21 - Checking status of the parent Accounting Program
15-APR-2012 13:10:21 - Dequeuing the unit from the queue
15-APR-2012 13:10:21 - Fetching event information for the documents in the unit
15-APR-2012 13:10:21 - executing extract hook
ARP_XLA_EXTRACT_MAIN_PKG.extract()+
p_application_id :222
p_accounting_mode :F
Calling upgrade_11i_r12_post +
Get 11i application to upgrade
End upgrade_11i_r12_post -
arp_xla_extract_main_pkg.load_header_data_ctlgd ()+
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_ctlgd()-
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()+
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()-
arp_xla_extract_main_pkg.load_line_data_app_from_cm ()+
arp_xla_extract_main_pkg.load_line_data_app_from_cm ()-
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_crh()+
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_crh()-
ARP_XLA_EXTRACT_MAIN_PKG.load_line_date_crh ()+
ARP_XLA_EXTRACT_MAIN_PKG.load_line_date_crh ()-
arp_xla_extract_main_pkg.load_line_data_app_from_cr()+
arp_xla_extract_main_pkg.load_line_data_app_from_cr ()-
arp_xla_extract_main_pkg.load_line_data_app_to_trx ()+
arp_xla_extract_main_pkg.load_line_data_app_to_trx ()-
arp_xla_extract_main_pkg.load_line_data_mcd()+
arp_xla_extract_main_pkg.load_line_data_mcd()-
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_adj()+
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_adj()-
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_adj()+
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_adj()-
ARP_XLA_EXTRACT_MAIN_PKG.Load_header_data_th()+
ARP_XLA_EXTRACT_MAIN_PKG.Load_header_data_th()-
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()+
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()-
ARP_XLA_EXTRACT_MAIN_PKG.extract()-
event key = 227511-9036463-BDB5E9C3783F5721E0440015176F838C
15-APR-2012 13:10:21 - extract hook executed successfully
***************************************************************************************************
The following REVERSAL events could not be processed. The event/process status is U/U:
Note: this warning may be ignored for any events whose ledger is a cash-basis ledger
-------NO SUCH EVENTS-----------
***************************************************************************************************
15-APR-2012 13:10:21 - executing postprocessing hook
ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()+
ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()-
event key = 227511-9036463-BDB5E9C3783F5721E0440015176F838C
15-APR-2012 13:10:21 - postprocessing hook executed successfully
15-APR-2012 13:10:21 - Completing Journal Entries
15-APR-2012 13:10:21 - Checking status of the parent Accounting Program
15-APR-2012 13:10:21 - Dequeuing the unit from the queue
15-APR-2012 13:10:22 - Fetching event information for the documents in the unit
15-APR-2012 13:10:22 - executing extract hook
ARP_XLA_EXTRACT_MAIN_PKG.extract()+
p_application_id :222
p_accounting_mode :F
Calling upgrade_11i_r12_post +
Get 11i application to upgrade
End upgrade_11i_r12_post -
arp_xla_extract_main_pkg.load_header_data_ctlgd ()+
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_ctlgd()-
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()+
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()-
arp_xla_extract_main_pkg.load_line_data_app_from_cm ()+
arp_xla_extract_main_pkg.load_line_data_app_from_cm ()-
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_crh()+
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_crh()-
ARP_XLA_EXTRACT_MAIN_PKG.load_line_date_crh ()+
ARP_XLA_EXTRACT_MAIN_PKG.load_line_date_crh ()-
arp_xla_extract_main_pkg.load_line_data_app_from_cr()+
arp_xla_extract_main_pkg.load_line_data_app_from_cr ()-
arp_xla_extract_main_pkg.load_line_data_app_to_trx ()+
arp_xla_extract_main_pkg.load_line_data_app_to_trx ()-
arp_xla_extract_main_pkg.load_line_data_mcd()+
arp_xla_extract_main_pkg.load_line_data_mcd()-
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_adj()+
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_adj()-
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_adj()+
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_adj()-
ARP_XLA_EXTRACT_MAIN_PKG.Load_header_data_th()+
ARP_XLA_EXTRACT_MAIN_PKG.Load_header_data_th()-
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()+
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()-
ARP_XLA_EXTRACT_MAIN_PKG.mfar_hook ()+
ARP_XLA_EXTRACT_MAIN_PKG.mfar_hook ()-
ARP_XLA_EXTRACT_MAIN_PKG.extract()-
event key = 227511-9036463-BDB5E9C378405721E0440015176F838C
15-APR-2012 13:10:22 - extract hook executed successfully
***************************************************************************************************
The following REVERSAL events could not be processed. The event/process status is U/U:
Note: this warning may be ignored for any events whose ledger is a cash-basis ledger
Event 84001003 of ledger 2021
***************************************************************************************************
15-APR-2012 13:10:22 - executing postprocessing hook
ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()+
ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()-
event key = 227511-9036463-BDB5E9C378405721E0440015176F838C
15-APR-2012 13:10:22 - postprocessing hook executed successfully
15-APR-2012 13:10:22 - Completing Journal Entries
15-APR-2012 13:10:22 - Checking status of the parent Accounting Program
15-APR-2012 13:10:22 - Dequeuing the unit from the queue
15-APR-2012 13:10:23 - Fetching event information for the documents in the unit
15-APR-2012 13:10:23 - executing extract hook
ARP_XLA_EXTRACT_MAIN_PKG.extract()+
p_application_id :222
p_accounting_mode :F
Calling upgrade_11i_r12_post +
Get 11i application to upgrade
End upgrade_11i_r12_post -
arp_xla_extract_main_pkg.load_header_data_ctlgd ()+
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_ctlgd()-
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()+
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()-
arp_xla_extract_main_pkg.load_line_data_app_from_cm ()+
arp_xla_extract_main_pkg.load_line_data_app_from_cm ()-
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_crh()+
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_crh()-
ARP_XLA_EXTRACT_MAIN_PKG.load_line_date_crh ()+
ARP_XLA_EXTRACT_MAIN_PKG.load_line_date_crh ()-
arp_xla_extract_main_pkg.load_line_data_app_from_cr()+
arp_xla_extract_main_pkg.load_line_data_app_from_cr ()-
arp_xla_extract_main_pkg.load_line_data_app_to_trx ()+
arp_xla_extract_main_pkg.load_line_data_app_to_trx ()-
arp_xla_extract_main_pkg.load_line_data_mcd()+
arp_xla_extract_main_pkg.load_line_data_mcd()-
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_adj()+
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_adj()-
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_adj()+
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_adj()-
ARP_XLA_EXTRACT_MAIN_PKG.Load_header_data_th()+
ARP_XLA_EXTRACT_MAIN_PKG.Load_header_data_th()-
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()+
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()-
ARP_XLA_EXTRACT_MAIN_PKG.mfar_hook ()+
ARP_XLA_EXTRACT_MAIN_PKG.mfar_hook ()-
ARP_XLA_EXTRACT_MAIN_PKG.extract()-
event key = 227511-9036463-BDB5E9C378415721E0440015176F838C
15-APR-2012 13:10:23 - extract hook executed successfully
***************************************************************************************************
The following REVERSAL events could not be processed. The event/process status is U/U:
Note: this warning may be ignored for any events whose ledger is a cash-basis ledger
-------NO SUCH EVENTS-----------
***************************************************************************************************
15-APR-2012 13:10:24 - executing postprocessing hook
ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()+
ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()-
event key = 227511-9036463-BDB5E9C378415721E0440015176F838C
15-APR-2012 13:10:24 - postprocessing hook executed successfully
15-APR-2012 13:10:24 - Completing Journal Entries
15-APR-2012 13:10:25 - Checking status of the parent Accounting Program
15-APR-2012 13:10:25 - Dequeuing the unit from the queue
15-APR-2012 13:10:25 - Submitting the transfer to GL
GL Inerface tablename = XLA_GLT_1278635
GL Inerface tablename = XLA_GLT_1278635
tablename = XLA_GLT_1278635
15-APR-2012 13:10:26- Submitting the Journal Import
15-APR-2012 13:10:46- Journal Import completed
15-APR-2012 13:10:46 - End of the transfer to GL
15-APR-2012 13:10:46 - Unit Processor completed successfully ...
---------------------------------------------------------------------------
End of log messages from FND_FILE
---------------------------------------------------------------------------

---------------------------------------------------------------------------
Executing request completion options...

Finished executing request completion options.

---------------------------------------------------------------------------
Concurrent request completed
Current system time is 15-APR-2012 12:47:57

---------------------------------------------------------------------------



Cause



Receipt Reverse Api was allowing receipts to be reversed with a Reversal Date prior to the maximum application date / maximum GL date.

Due to unpublished Bug 8668394 REW: RCA:ACTUAL_DATE_CLOSED IN INCORECT ON RECEIPT

Bug readme indicates unpublished bug 8668394 is fixed in 12.1.2 ; however, review of files indicates it is not fixed in 12.1.2 (patch 8402900).



Solution:


1. Bug Summary

  1. Description
    Receipts were allowed to be reversed before the maximum application date, thus causing reconciliation issue.
  2. Workaround
    None
  3. Resolution
    Receipts cannot be reversed with the date less than the maximum application date.

2. Fixed File(s)

R12.AR.A:
patch/115/sql/ARXPREVB.pls 120.44.12000000.24
patch/115/sql/ARXPRELB.pls 120.73.12000000.29
resource/ARXRWRCT.pld 120.150.12000000.96
patch/115/import/US/ar12amg.ldt 120.63.12000000.44

R12.AR.B:
patch/115/sql/ARXPREVB.pls 120.46.12010000.11
patch/115/sql/ARXPRELB.pls 120.78.12010000.12
resource/ARXRWRCT.pld 120.170.12010000.71
patch/115/import/US/ar12amg.ldt 120.64.12010000.33

3. Recommended Patch(es)

R12.AR.A and R12.AR.B: Patch 8668394

4. Solution Steps

  1. Ensure that you have taken a backup of your system before applying the recommended patch.
  2. Apply the patch in a test environment. 
  3. Confirm the file versions listed above.
    You can use the commands like the following:
    strings -a $AR_TOP/filename |grep '$Header' 
  4. Retest the issue. 
  5. Migrate the solution as appropriate to other environments.
  6. If the patch for your release is unavailable for download or needs a password, or if you experience any issues applying this patch, please contact the E-Business Patching Community for assistance.

5. Datafix

To fix currently corrupted receipts, please create a service request with Oracle support for assistance.