Epm 9.1 FTP YC Generator Not Producing Correct SQL in upgraded environment (Doc ID 1330612.1)

Last updated on OCTOBER 03, 2016

Applies to:

PeopleSoft Enterprise EPM Funds Transfer Pricing - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.
***Checked for relevance on 16-Oct-2013***

Symptoms


=== ODM Issue Clarification ===

ISSUE:
---------
When running the YC Generator in the 9.1 upgraded environment, the sql statement is generated incorrectly.
Most of the target values for the insert into PS_YC_PNEQS statement are being listed twice.


SETID,SETID,
YC_CODE,YC_CODE,
EFFDT,EFFDT,
CG_CURVE_DT,CG_CURVE_DT,
YC_CURVE_TYPE,YC_CURVE_TYPE,
YC_FWDMAT,YC_FWDMAT,
YC_FWDMAT_UOM,YC_FWDMAT_UOM,
YC_DOMAIN_START,YC_ DOMAIN_START,
YC_DOMAIN_END 


ENVIRONMENT:
---------------------
EPM 9.1 on Tools 8.51.06
IBM AIX on POWER Systems Ver. 5.3 ML09.
The C++ compiler in UNIX being used is 10.1.0.2

ERROR:
-----------
File: /vob/peopletools/src/pspcm/pcmeidef.cppSQL error. Stmt #: 1955  Error Position: 0  Return: 860 1 - [IBM][CLI Driver][DB2/AIX64] SQL0121N  

The target name "SETID" is specified more than once for a ssignment in the same SQL statement.  SQLSTATE=42701 (SQLSTATE 42701) -121 Failed SQL stmt:

INSERT INTO PS_YC_PNEQS (SETID,SETID,YC_CODE,YC_CODE,EFFDT,EFFDT,CG_CURVE_DT,CG_CURV E_DT,YC_CURVE_TYPE,YC_CURVE_TYPE,YC_FWDMAT,YC_FWDMAT,YC_FWDMAT_UOM,
YC_FWDMAT_UOM,YC_DOMAIN_START,YC_ DOMAIN_START,YC_DOMAIN_END) VALUES (:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:12 ,:13 ,:14 ,:15 ,:16 ,:17 )


BUSINESS IMPACT/LOSS OF FUNCTIONALITY:
---------------------------------------------------------------
The engine fails, and does not populate the table with the required information for the application to be usable.
Unable to move forward with upgrade of production environment until issues are resolved in Dev environment

   STEPS
   -----------------------
   By following these steps the issue can be reproduced:
   1. Upgrade to EPM 9.1/Tools 8.51.06 on an IBM AIX 5.3 environment
   2. Set up necessary data for YC Generator
   3. Run YC Generator process.

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