EEX 9.2: Error Message When Clicking View Accounting Button At Expense Report Fluid Approvals Page If Project Costing Module Is Not Installed

(Doc ID 2410391.1)

Last updated on JUNE 12, 2018

Applies to:

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

Symptoms

ISSUE:

At the Fluid Approvals level, Users are unable to review the Accounting Details of the Expense Lines from submitted Expense Reports. Upon clicking on the 'View Accounting' button, the system throws an Error Message.

This seems to take place when the Project Costing module is not selected at the Installed Products set up page.

REPLICATION STEPS:

     1.- Ensure that at the Installed Products set up page, the following modules are not selected:
          - Project Costing
          - Program Management
          - Grants
          - Maintenance Management
          - Proposal Management
     2.- Log into the FSCM Online Application as an Expenses User
     3.- Create a new Expense Report transaction, and submit it for approvals
     4.- Log into the FSCM Online Application as an Approver user
     5.- Go to the Fluid Homepage, and open the Fluid Approvals tile
     6.- Select the submitted Expense Report
     7.- Click on the Expense Line
     8.- Click on the View Accounting button
     9.- The system throws an Error Message

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps Word Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

ERROR MESSAGE:

     " ErrorReturn-> 154 - Hide: Record 'EX_SHEET_LINE' not found in scroll level 0. (2,154)
       FUNCLIB_EX.SHEET_STATUS.FieldFormula Name:HideEXProj PCPC:43879 Statement:647
       Called from:EX_SHEET_DIST.SHEET_ID.RowInit Statement:147
       The specified record was not found in the indicated scroll level. This may occur with various PeopleCode built-in functions that specify a "scroll context" via a series of records.
       Review the PeopleCode that is generating the message and the page definition and correct as appropriate.

       Error in PeopleCode ScrollSelect processing. EX_SHT_FAPDIST_FL.GBL.PreBuild PCPC: 2347 Statement: 23
       A SQL error occurred during the processing of the PeopleCode ScrollSelect (or ScrollSelectNew, RowScrollSelect, RowScrollSelectNew) built-in function.
       This error may have been described by a preceding message.
       Examine the error messages and the PeopleCode program containing the ScrollSelect call to determine the cause of the error.

       Data Integrity Error.
       The data structure from the page does not match the data structure in the database. This can be caused by a change in the record definition while you were viewing the page. This is a non-recoverable error and the current transaction will be aborted. "

ACTUAL RESULTS:

Submitted Expense Reports cannot be reviewed, and approved for payment, hence delaying the reimbursement on pending expenses.

EXPECTED BEHAVIOR:

The Approver User should be able to review the ChartField Accounting Details of the Expense Report Line selected, with no Error Message being triggered, when performing approvals via Fluid User Interface.

 

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