E-AWE: Not All Criteria Is Migrating When Using - Doc Id 762829.1 As Example For Migrating AWE Data From One Environment To Another.
Last updated on JUNE 08, 2017
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.52 and later
Information in this document applies to any platform.
On : FSCM 9.1, Approval Framework (AWE) Workflow
Migrating Approval script issue - doc Id 762829.1
When migrating approval workflow configuration from one environment to another is does not migrate all of the Criteria information and therefore results error in the target environment.
Preview Approval Worksheet
Pop Up Message;
Criteria check encountered an error. Check input values. (18081,1087)
EOAW_CRITERIA.DEFINITION.CriteriaRec.OnExecute Name evaluateSQL PCPC:14808 Statement:321
Called from EOAW_CRITERIA.DEFINITION.CriteriaRec.OnExecute Name:checkwithbinds Statement:182
Called from EOAW_CRITERIA.DEFINITION.CirteriaEntered.OnExecute Name: CheckwithBinds Statement 64
Called from EOAW_CORE.ENGINE.defPathInst.OnExecute Name:Instantiate Statement 15
Called from:EOAW_CORE.ENGINE.StageInst.OnExecute Name:InstantiatePath
The criteria check failed because a value is missing, so the query wasn't formed properly. Contact your administrator to correct the problem.
The issue can be reproduced at will with the following steps:
1. Developed datamover export script based on KM
E-AWE: How to Migrate Approval Workflow Engine (AWE) Configuration Across Environments? (Doc ID 762829.1)
2. Criteria Export developed as such;
EXPORT PS_EOAWCRTA WHERE EOAWCRTA_ID LIKE 'Path-ARMaintWriteOffRPCARWOFFA2014-03-23_%';
EXPORT PS_EOAWCRTA_LNG WHERE EOAWCRTA_ID LIKE 'Path-ARMaintWriteOffRPCARWOFFA2014-03-23_%';
EXPORT PS_EOAWCRTA_REC WHERE EOAWCRTA_ID LIKE 'Path-ARMaintWriteOffRPCARWOFFA2014-03-23_%';
EXPORT PS_EOAWCRTA_RECLNG WHERE EOAWCRTA_ID LIKE 'Path-ARMaintWriteOffRPCARWOFFA2014-03-23_%';
EXPORT PS_EOAWCRTA_VAL WHERE EOAWCRTA_ID LIKE 'Path-ARMaintWriteOffRPCARWOFFA2014-03-23_%';
3. Used datamover to import data into Target system.
4. Opened the Approval Process ID, and pressed the Preview link and received error above.
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