My Oracle Support Banner

EGL9.2: Multi-Currency Translation Process(FS_MC) Encountered "Correlation Name 'T' Specified Multiple Times" Error At Step FS_MC_XLAT.iWrk.iWrk When Run Through MSS (Doc ID 2410511.1)

Last updated on JULY 09, 2018

Applies to:

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

Symptoms

Issue:
-------
FS_MC multi-currency errors out during the translation step.


Steps to Replicate:
---------------------
1. Define the translation rules.
2. Define the translation step and add the translation rule to translation step.
3. Tag the translation step to the process group.
4. Run the FS_MC multicurrency process.

Please see replication screenshots for more details.


Error:
------
[Microsoft][SQL Server Native Client 11.0][SQL Server]The correlation name 'T' is specified multiple times in a FROM clause.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE 37000) 8180
Failed SQL stmt: INSERT INTO PS_MC_WRK_TAO4 (PROCESS_INSTANCE, LEDGER, ACCOUNT, GAINLOSS_ACCT, ALTACCT, DEPTID, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, BUSINESS_UNIT_PC, PROJECT_ID, ACTIVITY_ID, RESOURCE_TYPE, ANALYSIS_TYPE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, BOOK_CODE, GL_ADJUST_TYPE, DATE_CODE, BUDGET_PERIOD, BUDGET_DT, SCENARIO, CURRENCY_CD, STATISTICS_CODE, FISCAL_YEAR, ACCOUNTING_PERIOD, KK_BUDG_TRANS_TYPE, POSTED_TOTAL_AMT, POSTED_TRAN_AMT, POSTED_BASE_AMT, RESTATED_AMT, REVAL_ADJUSTMENT, CUR_EXCHNG_RT, RATE_MULT, RATE_DIV, TARGET_CURRENCY) SELECT 159574, 'GBP', A.ACCOUNT, 'N', ' ', A.DEPTID, A.OPERATING_UNIT, A.PRODUCT, A.FUND_CODE, A.CLASS_FLD, A.PROGRAM_CODE, ' ', A.AFFILIATE, ' ', ' ', A.CHARTFIELD1, A.CHARTFIELD2, ' ', ' ', A.PROJECT_ID, ' ', ' ', ' ', ' ', ' ', A.BOOK_CODE, A.GL_ADJUST_TYPE, A.DATE_CODE, ' ', NULL, ' ', A.CURRENCY_CD, ' ', 2018, 2, ' ', SUM(A.POSTED_TOTAL_AMT), SUM(A.POSTED_TRAN_AMT), 0, ROUND(SUM(((((A.POSTED_TOTAL_AMT) / (R.RATE_DIV))) * (R.RATE_MULT))),2), 0, 0, R.RATE_MULT, R.RATE_DIV, 'GBP' FROM PS_LEDGER A, PS_MC_RATE_TAO4 R , PS_MC_TSEL_TAO4 T, PS_MC_TSEL_TAO4 T, PS_MC_TSEL_TAO4 T WHERE A.BUSINESS_UNIT = '49000'"

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!


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