E-AWE: Not All Criteria Is Migrating When Using - Doc Id 762829.1 As Example For Migrating AWE Data From One Environment To Another. (Doc ID 1642800.1)

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.

Symptoms

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.

ERROR
-----------------------

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.


STEPS
-----------------------
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.



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