General Ledger - EBS (MOSC)

MOSC Banner

R12 upgradation support

edited Aug 11, 2017 5:30AM in General Ledger - EBS (MOSC) 10 commentsAnswered

Can some suggest which table and column to replace with below 11i .  Some blogs says, use gl_daily_rates but in that, i am not finding Period_name & Actual_flag.  Please suggest.

  SELECT ROUND(avg_rate,2)

      INTO exch_rate

FROM gl_translation_rates_v  

WHERE set_of_books_id = sob_id

AND   functional_currency = from_curr

AND   to_currency_code = to_curr

AND   actual_flag = balance_type

AND   period_name = period;

Thank you.

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