EGL9.2: Multi-Currency Revaluation Process(FS_MC) Encountered 'ORA-00918: column ambiguously defined ' Error At Step FS_MC_RVAL.iWrk.iWrk (Doc ID 2277121.1)

Last updated on SEPTEMBER 13, 2017

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:
-------

Multi-currency Revaluation process encountered 'ORA-00918: column ambiguously defined ' error at step FS_MC_RVAL.iWrk.iWrk

Steps to Replicate:
---------------------
1. Set up revaluation step with 'Source Chartfields' tab having 'How Specified' option for chartfields selected as 'Selected Tree Nodes'
2. Repeat step 1 until the total no of such tree node related criteria becomes at least 27
3. Include all the revaluations steps in a single multi-currency process group
4. Request to run multi-currency process using FS_MC application engine

Please see replication screenshots for more details.

Error:
------
 SQL Error: ORA-00918: column ambiguously defined

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