Issue With SPF_TO_AP after upgrade from 8.9 to 9.2
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.
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
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