My Oracle Support Banner

Suppliers Receiving A Fatal PeopleCode SQL Error When Trying To Approve SPro Invoices (Doc ID 2419522.1)

Last updated on OCTOBER 02, 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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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