My Oracle Support Banner

FSCM PUM 31 - DB2 - Run Post Data Conversion AE - ABENDED At Step PODC28351754.COMPREF.Step03 (Doc ID 2542358.1)

Last updated on FEBRUARY 13, 2020

Applies to:

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

Symptoms

When attempting to apply FSCM 9.2 PUM 31 while running "Post Data Conversion App Engine" it abended at Step PODC28351754.COMPREF.Step03 with the following error.

Issue did not occur during Initial pass; it only occurred during MTP.

ERROR
-----------------------
PeopleTools 8.56.11 - Application Engine
Copyright (c) 1988-2019 Oracle and/or its affiliates.
All Rights Reserved
File: e:\pt85611c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 8601 - [][CLI Driver][DB2/AIX64] SQL0134N Improper use of a string column, host variable, constant, or function "PORTAL_NAVPATH". SQLSTATE=42907
 (SQLSTATE 42907) -134
Failed SQL stmt: INSERT INTO PS_EODP_COMPDETREF (PNLGRPNAME, MENUNAME, MARKET, PORTAL_NAME, PORTAL_REFTYPE, PORTAL_OBJNAME, PORTAL_NAVPATH, EODP_SYS_FLG, DATA_TYPE_CD) SELECT DISTINCT SYS.PNLGRPNAME, SYS.MENUNAME, SYS.MARKET, SYS.PORTAL_NAME, SYS.PORTAL_REFTYPE, SYS.PORTAL_OBJNAME, SYS.PORTAL_NAVPATH, 'Y', 'Y' FROM PS_EODP_COMPDETSYS SYS WHERE NOT EXISTS ( SELECT 'X' FROM PS_EODP_COMPDETREF X WHERE X.PNLGRPNAME=SYS.PNLGRPNAME AND X.MENUNAME=SYS.MENUNAME AND X.MARKET=SYS.MARKET AND X.PORTAL_NAME=SYS.PORTAL_NAME AND X.PORTAL_NAME=SYS.PORTAL_REFTYPE AND X.PORTAL_NAME=SYS.PORTAL_NAME) AND EXISTS ( SELECT 'X' FROM PSPNLGRPDEFN X1 WHERE X1.PNLGRPNAME=SYS.PNLGRPNAME ) AND EXISTS ( SELECT 'X' FROM PSMENUDEFN X2 WHERE X2.MENUNAME=SYS.MENUNAME ) AND (SYS.PORTAL_NAME = ' ' OR EXISTS ( SELECT 'X' FROM PSPRSMDEFN X3 WHERE (X3.PORTAL_NAME=SYS.PORTAL_NAME AND X3.PORTAL_REFTYPE=SYS.PORTAL_REFTYPE AND X3.PORTAL_OBJNAME=SYS.PORTAL_OBJNAME) ))

 Message Set Number: 200
 Message Number: 0
 Message Reason: File: e:\pt85611c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 8601 - [][CLI Driver][DB2/AIX64] SQL0134N Improper use of a string column, host variable, constant, or function "PORTAL_NAVPATH". SQLSTATE=42907
 (SQLSTATE 42907) -134
Failed SQL stmt: INSERT INTO PS_EODP_COMPDETREF (PNLGRPNAME, MENUNAME, MARKET, PORTAL_NAME, PORTAL_REFTYPE, PORTAL_OBJNAME, PORTAL_NAVPATH, EODP_SYS_FLG, DATA_TYPE_CD) SELECT DISTINCT SYS.PNLGRPNAME, SYS.MENUNAME, (200,0)
Process 44004 ABENDED at Step PODC28351754.COMPREF.Step03 (SQL) -- RC = 8601 (108,524)
 Message Set Number: 108
 Message Number: 524
 Message Reason: Process 44004 ABENDED at Step PODC28351754.COMPREF.Step03 (SQL) -- RC = 8601 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open Change Assistant and Run Step - Run Post Data Conversion AE - PODC28351754

Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.