iSupplier Application Allows User To Perform Corrections On Work Confirmation Twice. (Doc ID 3066705.1)

Last updated on JANUARY 15, 2025

Applies to:

Symptoms

The application permits the user to create duplicate work confirmation corrections resulting in duplicate records in the rcv_transactions table and an incorrect value in the Current Requested field.

STEPS
-----------------------
1. Log into E-Business Suite.
2. Open Purchasing responsibility, navigate to the Orders page and search for a particular PO.
3. From the Orders page, select the Complex PO and then select View Work Confirmation from the Select Order drop-down field.
4. From the Work Confirmation for Complex Purchase Order: : page, click on a work confirmation link for the PO. Note that the Previous Requested Amount is, for example, 5000; the Current Requested Amount is 5000; and the status is Processed.
5. From the Work Confirmation: page, click on the Correct button to initiate the first correction.
6. From the Correct Work Confirmation page, change the Requested/Delivered value to zero and click the Submit button. A confirmation is displayed in the header stating that the work confirmation correction has been submitted.
7. Return to the Work Confirmation for Complex Purchase Order: : page. The correction is in Processed status and the values mentioned above remain the same.
8. Click on the corrected work confirmation link for the same PO that was previously corrected and repeat the same correction process.
9. Return to the Work Confirmation for Complex Purchase Order: : page. The work confirmation correction is in Corrected status and the Current Requested amount is zero.

Check table records:
1. Open a SQL Developer session and run the following SQL statement:

SELECT *
  FROM rcv_shipment_headers
WHERE shipment_num = &shipment_number:

2. Return to the Work Confirmation for Complex Purchase Order: : page and refresh it. The work confirmation correction is in Corrected status and the Current Requested amount is -5000 indicating two corrections for 5000 for each completed correction.
3. Return to SQL Developer session and run the following SQL statement:

select * from rcv_transactions where shipment_header_id = &shipment_header_id;

- Six records are returned - one RECEIVE, one DELIVER, and four CORRECT for the shipment.

Changes

 None

Cause

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