PO_POROLLVW Disqualifying Purchase Orders Incorrectly (Doc ID 2037617.1)

Last updated on FEBRUARY 29, 2016

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to use the PO Rollover workbench, the following error occurs.

ERROR:   The purchase order cannot be selected to roll as it has a Roll Status of DISQUALIFIED.


The issue can be reproduced at will with the following steps:

  1. Create a PO with a line for 10 each
  2. Create two receipts First for 7 each and Second for 2 each - First Receipt (MATCH STATUS = MATCHED)
  3. Create 3 vouchers First for 1 each, Second for 2 each and 1Third for 4 each all matching to the First receipt for 7 (MATCH STATUS = MATCHED)
  4. Roll PO - The PO will not roll as the step is using the PS_POROLL_RECV_SVW view which sums the receipt quantities for all receipts for the PO DISTRIBUTION LINE and compares it to the PS_POROLL_VC_SVW which sums the total of all vouchers for the PO DISTRIBUTION LINE.


The issue has the following business impact:
Due to this issue, users cannot ROLL a PO with multiple Receipts to 1 voucher.

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