Several Issues with the 'Reconcile Accrued Liability' Process (CM_APRECN) and Error "ORA-0001: unique constraint (PS_CM_APRECN_TBL) violated at Step CM_APRECN.UPDATE.Step01" (Doc ID 1358158.1)

Last updated on AUGUST 04, 2016

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9 to 9.1 [Release 9]
PeopleSoft Enterprise SCM Manufacturing - Version 9 to 9.1 [Release 9]
PeopleSoft Enterprise SCM Cost Management - Version 8.4 SP2 and later
Information in this document applies to any platform.
This Knowledge Document applies to Cost Management releases 9.0 and 9.1.

***Checked for relevance on 24-Oct-2012***

Symptoms

*** Issue # 1:

When running the 'Reconcile Accrued Liability' process (CM_APRECN) (navigation: Cost Accounting, Inventory and Mfg Accounting, Analyze Inventory Accounting, Reconcile Accrued Liability) using the same Run Control ID and Request ID as a previous run but performed by a different User ID, the following error is issued:

ORA-0001: unique constraint (PS_CM_APRECN_TBL) violated at Step CM_APRECN.UPDATE.Step01



*** Issue # 1b:

In the INITIAL Section, data from the PS_CM_APRECN_TBL, PS_CM_APRECN_TBL2, and PS_CM_APRECN_HDR tables is deleted based on the Operator ID, Request ID, and Run Control ID. This means that if the 'CM_APRECM' process is run by User X and the process is not able to reconcile a Receipt, this Receipt will be inserted into the PS_CM_APRECN_HDR and will be available for inquiry which is as expected. However,
if a User Y is running the 'CM_APRECM' process again, the data of the first run in the above 3 tables is NOT deleted as the User ID is different (this is at the origin of the issue # 1).

Supposing that the second run of the 'CM_APRECM' process by User Y is able to reconcile the Receipt, the Receipt will still show up in the Search page of the 'CM/AP Reconciliation Summary' component but no data will be displayed when clicking on it.

The data in the PS_CM_APRECN_TBL, PS_CM_APRECN_TBL2, and PS_CM_APRECN_HDR tables should NOT be deleted based on the Operator ID.



*** Issue # 2:

The CM_APRECN process is not able to reconcile a Voucher line with the 3 Receipts that have been linked to it (using the 'Associate Receivers' option after copying the Voucher line from a Purchase Order line) while:

* the total amount for the 3 Receipts is the same as the Voucher amount,
* the 3 Putaway Accounting Lines and the Voucher Accounting Lines have been posted to GL,
* the ChartField values for the Putaway Accounting Lines and the Voucher Accounting Lines are exactly the same.



*** Issue # 3:

At the Application Engine Step CM_APRECM.GETDATA.Step04, the PS_CM_APRECN_TAO.BUSINESS_UNIT_RECV field is linked to the PS_VCHR_RECV_MTCH.BUSINESS_UNIT field. This is incorrect as the Voucher Business Unit is not necessary the same as the Receipt Business Unit. PS_CM_APRECN_TAO.BUSINESS_UNIT_RECV should be linked to PS_VCHR_RECV_MTCH.BUSINESS_UNIT_RECV.



*** Issue # 4:

The 'Search' page of the 'CM/AP Reconciliation Summary' component does not work properly. Results are returned only if:

* all 4 search fields are blank
* the Request ID field only is filled with a valid value

Also, if results are returned but you still fill the 4 search fields (in order to display the data of a specific Receipt which is not the first one of the search results) and click on 'Search', the data displayed in the 'CM/AP Reconciliation Summary' page is from the first row of the search results and not the data of the Receipt you selected.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms