EGL9.2: Multi-Currency Revaluation Process(FS_MC) Encountered 'ORA-00918: column ambiguously defined ' Error At Step FS_MC_RVAL.iWrk.iWrk
Last updated on SEPTEMBER 22, 2017
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
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.
SQL Error: ORA-00918: column ambiguously defined
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