When Using the Open Item Contract Adjustment in Addition to a Line Adjustment, POCALC process Is Failing With a Unique Constraint Error. Process Abended at Step PO_CMPRICE.PR3000.LDCNBADJ (SQL) – RC=805 (Doc ID 3037181.1)

Last updated on JULY 26, 2024

Applies to:

Symptoms

When Using the Open Item Contract Adjustment in Addition to a Line Adjustment, the POCALC process is abending with a unique constraint error.

The issue can be reproduced at will with the following steps:
1. Navigate to Procurement Contracts. (Procurement Contracts-->Add/Update Contracts)
2. Search for an existing PO Contract.
3. Select the contract.
4. Change the status to Open, select the Allow Open Item Reference flag then click on Add Open Item Price Adjustments link.
5. Calculation Method: Increment Adjustment, Method: General Adjustment, Restrictions: Ignore Other Adjustments, Adjustment Detail: Percent Percentage 5.
6. Click OK.
7. Click on the Price Adjustment Template link.
8. Calculation Method: Increment Adjustment, Method: General Adjustment, Restrictions: Ignore Other Adjustments, Adjustment Detail: Percent Percentage 10.
9. Click OK.
10. Line 1 click on Price Adjustment icon.
11. Calculation Method: Increment Adjustment, Method: General Adjustment, Adjustment Detail: Percent Percentage 10.
12. Click OK.
13. Change the Status of the contract to Approved and click Save.
14. Navigate to Add/Update Requisition. (Purchasing-->Requisitions-->Add/Update Requisitions)
15. Click Add to add a new requisition.
16. Line 1 added our item from our contract. Line 2 added a description item.
17. Click on the Contract tab. Note that our contract defaulted on both lines.
18. Click on the Contract Search icon for Line 1.
19. Click on Search. Note that it defaulted the contract.
20. Click on the Price Adjustment link. It displays the Adjustment from our contract.
21. Click Return then Click OK.
22. Click on Contract Search for Line 2 then click Search.
23. Price adjustment displays from our contract.
24. Save the requisition.
25. Navigate to AUTOSOURCE. (Purchasing-->Purchase Orders-->Stage/Source Requests-->PO AutoSource)
26. Click Add to add a new run control.
27. Enter BU/Requisition.
28. Click Run.
29. Process abends.


 

Cause

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