Suppliers Receiving A Fatal PeopleCode SQL Error When Trying To Approve SPro Invoices

(Doc ID 2419522.1)

Last updated on JULY 05, 2018

Applies to:

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

Symptoms

When suppliers trying to approve the service invoice, they are getting error message below when selecting the invoice line and choose any option from the "Invoice Line Status" drop down list

ERROR:
SQL error FUNCLIB_SPF_INVOICE_FLG.FieldFormula
Called from SPA_SUP_INV_APR_LN.Activate Statement 60

The issue can be reproduced at will with the following steps:
1. Create a new sPro invoice against any progress log or timesheet.
2. Submit it for approval.
3. Supplier will try to approve the invoice.
4. Supplier will select the invoice line and choose any option from the "Invoice Line Status" drop down list and press on search
5. Getting error message :
SQL error FUNCLIB_SPF_INVOICE_FLG.FieldFormula
Called from SPA_SUP_INV_APR_LN.Activate Statement 60



Changes

 

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