EeS: PeopleCode when attempting to Review Invoices

(Doc ID 1669889.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

If user has access to more than 1000 Business Units, when attempting to Review Invoices, an error occurs:

ERROR
Fatal SQL error occurred. (2,125)
EM_INV_LINES_VW.EM_BUSINESS_UNIT.FieldFormula  Name:LineSearchExeStatement
PCPC:32539  Statement:471
Called from:EM_INVOICE_LINES.Activate  Statement:93

A SQL error has occurred, review the SQL to determine the cause of the error.

STEPS
1. Under the Set Up Financials/Supply Chain > Security menu, set up security for Business Unit
2. Give access for more than 1000 Business Units for one User
3. With this User, try to open the page eSettlements > My Invoice Lines - Review Disputes
4. Try to open Invoice > Review Invoice, get a similar error in other PeopleCode (EM_VCHR_INQ_VW.EM_BUSINESS_UNIT.FieldFormula)

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