Order Import request did not return with error when even the order is not imported

Explanation:-

Oracle Order Management - Version: 11.5 to 12.1.3 - Release: 11.5 to 12.1

Order import program will not error out if validation for some attributes fail.

In case of failure, child concurrent program 'Order Import Child Req1 (Order Import)' will not get spawn. Secondly, the log file will tell the total number of orders processed

This is the expected behavior.

Order Import corrections form will show records in red color under the following scenarios :

Case 1.

If the validation for any of the header attribute fails, it doesn't matter whether the validation of lines under it passes/fails. In this case the header record will be set as error_flag='Y' and shown in red where as the lines will NOT be in red color (even though a line contains invalid attributes)

Case 2.

If the header validation passes and any of the line validation fails, then both the header record and the line will be marked as erred and shown in red color.

For example :

If there is an invalid price list at line level, there will be many error occurred at header level. So as per Case1, it will not show the line record in red color. If there are no errors at header level and if there occurs at error at line level then only the line will be shown in red color.

If the order has more than one line and you want to find which line has failed in validation, first you have to ensure that all the validation for the header record is successful. After the header validation is successful and if there is any validation failure for a line, then that particular line will be shown in red color (the header record will also be in red).

'Function not available to this responsibility. Change responsibilities or contact your System Administrator' when go to see 'View Accounting' for PO Receipt through view receiving transaction summary window

Solution:-

1.Go to System Administrator Responsibility
2.Click Application/Menu
3.Query the menu = INV_NAVIGATE
4.Write down the submenu name = INV_TRANSACTIONS 
5.Click Application/Menu
6.Query the menu = INV_TRANSACTIONS
7.Write down the submenu name = INV_RECEIVING 
8.Click Application/Menu
9.query out Menu = INV_RECEIVING
10. Add a new entry:
     Prompt = Accounting
    Submenu = Accounting:
    Function = Blank
    Description = Blank

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.