My Oracle Support Banner

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

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