EEX 9.2: Field Is Required PS_EOAW_PATH.EOAWSTAGE_NBR (124,64) Error For ERApproval If 'Include Requester' Flag Is Unselected (Doc ID 1678732.1)

Last updated on MARCH 16, 2016

Applies to:

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

Symptoms

ISSUE:

In PeopleSoft Enterprise FSCM 9.2 Application Release, when a User enables the 'Include Requester' flag for the Process ID ERApproval, and saves the changes, the system creates a new extra row for the affected Approval Process within Record PS_EOAW_PATH. However, within that new row, the below listed Fields are left as blank:

       - EOAWSKIP_PRIOR
       - EOAWAUTH_SW
       - EOAWFIRST_STEP_SW
       - EOAWREQUIREFIRST
       - EOAWSKIP_UNAUTHED
       - EOAWNOTIFY_ADMIN

Therefore, when the User later on decides to un-select the 'Include Requester' flag, and save again the changes, the system throws an Error Message stating that a Field is required, preventing the proper save of any performed modifications.

REPLICATION STEPS:

  - Log into the FSCM 9.2 Online Application as User ID VP1
  - Navigate to: Enterprise Components > Approvals > Approvals > Approval Process Setup
  - Open the existing Process ID ERApproval under Definition ID SHARE
  - Click on the 'Clone Approval Process' link
  - Keep the Set ID SHARE, and set an Effective Date of January 1st 2000
  - Click on OK, and save the changes
  - In a Query Analyzer Tool, run the following SQL Statement in a DEMO environment:
       SELECT * FROM PS_EOAW_PATH WHERE EOAWDEFN_ID = 'SHARE' AND EOAWPRCS_ID = 'ERApproval' AND EFFDT = '01-JAN-2000'
  - Confirm that the query has returned 6 delievred rows
  - Set the Process Status into 'Active', select the 'Include Requester' flag, and save the changes
  - In a Query Analyzer Tool, run again the following SQL Statement in a DEMO environment:
       SELECT * FROM PS_EOAW_PATH WHERE EOAWDEFN_ID = 'SHARE' AND EOAWPRCS_ID = 'ERApproval' AND EFFDT = '01-JAN-2000'
  - Confirm that there is now an additional 7th row to include the Requester, but with the below Fields in blank:
       - EOAWSKIP_PRIOR
       - EOAWAUTH_SW
       - EOAWFIRST_STEP_SW
       - EOAWREQUIREFIRST
       - EOAWSKIP_UNAUTHED
       - EOAWNOTIFY_ADMIN
  - Unselect the 'Include Requester' flag, and save again the changes
  - 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:

  " Field is Required:  EOAW_PATH - EOAWSTAGE_NBR (124,64) "

BUSINESS IMPACT:

No further changes performed into the ERApproval Process Definition can be changed, leaving useless the new Approval Process ID created, as it cannot be used as it is.

EXPECTED BEHAVIOR:

The system should properly remove the Include Requester Path additional row in Record PS_EOAW_PATH if the 'Include Requester' flag is not selected at the Process Definition of ERApproval.
 

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