Tuesday, 3 November 2015

Accrual Reconciliation Report is disabled in upgraded version R12

Our Application is an upgraded version and it is upgraded from 11i to R12.2.4. Accrual Reconciliation Report is disabled.

I enabled it and tried to run from Purchasing Application. Its parameter gave following error:-

1. APP-FND-01564: ORACLE error 942 in FDFGDF 

Cause: FDFGDF failed due to ORA-00942: table or view does not exist. 
On clicking on OK, system showed following error:-

APP-FND-00730: This flexfield has an invalid value set 

Solution:-

Please run AP and PO Accrual Reconciliation Report as this is the newly introduced report for accrual reconciliation in R12 instead of Accrual Reconciliation Report in previous releases. 


Please note that you will need to run Accrual reconciliation load run program first to populate accruals tables where AP and PO Accrual Reconciliation Report reads from . Please Note that the Load Program is the counterpart of the Rebuild manager in Release11i. The Load Program populates CST_AP_PO_RECONCILIATION and CST_RECONCILIATION_SUMMARY with net po_distribution amounts. When the accrual load run program is run for the first time, it will not consider the start date given by the User. It will instead build the data in cst_ap_po_reconciliation, cst_reconciliation_summary, cst_misc_reconciliation tables using the first transaction date available in XLA that has been transferred to GL. It will however build the data to the End Date provided by the User.
 

No comments:

Post a Comment