EGL9.2: Cross/Reciprocal Rate Calc (EO9030) Process Fails with "Invalid column name 'eff_status' " Error
(Doc ID 2682091.1)
Last updated on SEPTEMBER 23, 2020
Applies to:Microsoft SQLServer - Version 2005 to 2017
PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
When attempting to run Cross/Reciprocal Rate Calc (EO9030) Process on Microsoft SQL Server, the following error occurs:
Steps to Replicate:
1. Navigate to Set Up Financials/Supply Chain > Common Definitions > Market Rates > Cross/Reciprocal Rate Calc
Or Set Up HCM > Foundation Tables > Currency and Market Rates > Calculate Cross/Reciprocal Rt
2. Enter below parameters:
- Rate Index = MODEL, From Common Curr = USD, Exch Rate Type = OFFIC, As of 5/1/2020
- Select Generate Report, Generate Reciprocal Rate and Rate Triangulate
- From Cur % and To Cur %
3. Click on Run button and select EO9030 process
Replication document attached.
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