1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Is api available to insert data to gl_daily_rates_interface?

Discussion in 'Oracle Apps Technical' started by RG Hegde, Jul 24, 2015.

  1. RG Hegde

    RG Hegde Forum Advisor

    Messages:
    185
    Likes Received:
    35
    Trophy Points:
    310
    Location:
    Pune
    Hello,

    Is API Available to insert data to GL_DAILY_RATES_INTERFACE or should we go for direct insert statement.
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    Check this...


    The GL_DAILY_RATES_INTERFACE 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. You do not need to run any import programs. You only need to develop an automated process that populates the interface table with your daily rates information.

    https://docs.oracle.com/cd/A60725_05/html/comnls/us/gl/daily.htm
     
    RG Hegde likes this.
  3. blackgee

    blackgee Active Member

    Messages:
    12
    Likes Received:
    3
    Trophy Points:
    90
    You can develop Custom using this API..


    GL_DAILY_RATES_PKG.insert_row

    Also you can check this package and see the others APIs.

    Regards,
    Gee!
     
    RG Hegde likes this.
  4. blackgee

    blackgee Active Member

    Messages:
    12
    Likes Received:
    3
    Trophy Points:
    90
    PS: If you are working on Migration Project you need.
    Take into account Data Conversion Reference for General Ledger for Data Conversion.