EAP: AP_MATCH Fails With Unique Constraint Issue At AP_MATCH.NoRecpt.Step03
Last updated on APRIL 10, 2018
Applies to:PeopleSoft Enterprise FIN Payables - Version 9.1 and later
Information in this document applies to any platform.
AP_MATCH process fails at step AP_MATCH.NoRecpt.Step03 with an Unique Constraint Error. This happens when receipts are actively being entered when AP_MATCH process is running in the background.
1) Create 2 POs.
2) Partially receive one of the PO
3) Completely Invoice both the POs
4) Run the AP_MATCH process. While the process is running, between the step AP_MATCH.NoRecpt.Step02 and AP_MATCH.NoRecpt.Step03 create receipts for the above POs. In PROD, once a week, users create receipts will this process is running and if a receipt is created between both 2 steps, the process fails. IN DEMO and non-PROD instance, we put in a PeopleCode sleep command to replicate the issue. (in the attached AET file, the step AP_MATCH.NoRecpt.Step06 is the sleep command)
5) Process goes to 'No Success' with the unique constraint error.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms