EAP: AP_MATCH Fails With Unique Constraint Issue At AP_MATCH.NoRecpt.Step03

(Doc ID 2384551.1)

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.

Symptoms

 

ISSUE:
 
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.

 

STEPS:
 
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.

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