EeS: PeopleCode when attempting to Review Invoices
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.
If user has access to more than 1000 Business Units, when attempting to Review Invoices, an error occurs:
Fatal SQL error occurred. (2,125)
Called from:EM_INVOICE_LINES.Activate Statement:93
A SQL error has occurred, review the SQL to determine the cause of the error.
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)
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