Re:GL Exchange Rates - HandsonERP - Oracle E-Business Suite Training

Welcome

Welcome to HandsonERP.com

This site provides video based training of Oracle Financials.
Learn concepts and functionality in a step by step manner.

Login

	HandsonERP - Oracle E-Business Suite Training	Forum Flat View Rules

Welcome, Guest
Please Login or Register. Lost Password?

HandsonERP - Oracle E-Business Suite Training

HandsonERP.com Forum

Questions Related to Lessons Content

Re:GL Exchange Rates (1 viewing) (1) Guest

Please post inquiries related to lessons content here. All questions and inquiries related to the website should be submitted directly using Contact form in the top menu.

Favoured: 0

TOPIC: Re:GL Exchange Rates

Forum Tools

#2812

handsonerp (Admin)

Admin

Posts: 1989

Re:GL Exchange Rates 12 Years, 1 Month ago

General Ledger provides the GL_DAILY_RATES_INTERFACE table that could be used to automatically insert, update, or delete daily rates in the GL_DAILY_RATES table.
Oracle validates the rows in the interface table and then make changes in the GL_DAILY_RATES table.

Always use the interface table.
Do not load rates directly into the GL_DAILY_RATES table

The insert, update, or deletion of rates in GL_DAILY_RATES is done automatically by database triggers on the GL_DAILY_RATES_ INTERFACE table.
There is no need to run import programs.
Develop an automated process that populates the interface table with your daily rates information.

See Oracle user guide for details.

Report to moderator Logged