General Ledger - EBS (MOSC)

MOSC Banner

Query about loading data into GL_INTERFACE table and Currencies

edited Aug 6, 2018 5:22AM in General Ledger - EBS (MOSC) 2 commentsAnswered ✓

Hi,

We're using R12.1.3.

We are at the initial stages of looking to create a staging table into which to enter data that will ultimately be loaded into the GL_INTERFACE table via a custom concurrent program.

If we enter Journal Lines into the GL_INTERFACE table for GBP, that's not a problem.

If we enter Journal Lines with a foreign Currency, e.g. USD or EUR - do we need to populate these columns:

  • CURRENCY_CONVERSION_DATE
  • USER_CURRENCY_CONVERSION_TYPE
  • CURRENCY_CONVERSION_RATE

Or is it okay to leave those empty, and assume that as long as the Exchange Rates are defined for the relevant Dates and Currencies in GL, that the system would take care of the conversions?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center