Issue With SPF_TO_AP after upgrade from 8.9 to 9.2 (Doc ID 2122590.1)

Last updated on JULY 11, 2016

Applies to:

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

Symptoms

The design change in sPro POs (one spro line generating multiple POs) is causing issues with voucher staging. This happens when we try to voucher the POs generated in 8.9. The program tries to look for an extra PO line number where it should really look for a PO distribution line number.
1. SPF_TO_AP.DISTLINE.INSWODS7.SQL -> This updates PO ID to blank. It should check and update it only when there is no PO ID associated.
2. SPF_TO_AP.LOADTMP.UPDPOLN.SQL -> This updates PO line to 2 if it finds an expense sheet tied to the invoice. Since in 8.9 PO's there will not be any 2nd line (unlike 9.2 POs), this will create issues.

Steps to reproduce the issue:
1. Choose any upgraded PO from 8.9 to 9.2
2. Try to voucher that PO
3. The program tries to look for an extra PO line number where it should really look for a PO distribution line number



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