My Oracle Support Banner

EAP: WorkCenter Migration Error FIELD: PAGELET_CONFIG_ID on the RECORD: FSPC_ADM_TBL is not found in the PROMPT TABLE: FSPC_ADM_TBL (257,501) (Doc ID 2052112.1)

Last updated on AUGUST 09, 2018

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Migrating AP WorkCenter from FS Demo image to Test/Dev environment and a validation error is received trying to Load Project from File.

ERROR
FSPC_ADM_TBL Static Prompt Validation Error VALUE: AP specified for the FIELD: PAGELET_CONFIG_ID on the RECORD: FSPC_ADM_TBL is not found in the PROMPT TABLE: FSPC_ADM_TBL (257,501) While performing a prompt validation, the provided value does not seem to be available on the prompt table. Please address this issue and perform the validations again.

STEPS:
1.  PeopleTools > Lifecycle Tools > Migrate Data > Data Migration Workbench > Add a New Project
     a.  Data Set Name: WORKCENTER_CONFIGURATION , WORKCENTER_FILTERS
     b.  Insert Data Set Content
          WORKCENTER_CONFIGURATION: PAGELET_CONFIG_ID = AP
          WORKCENTER_FILTERS:  All FILTER_ID values Line AP_ (25 listed)
3.  Save Project
4.  Run Data Migration Workbench PTADSAEPRCS
5.  Copy Project file from Demo environment to Test/Dev environment
6.  Log into Test/Dev environment > PeopleTools > Lifecycle Tools > Migrate Data > Data Migration Workbench > Load Project From File

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.