A bit on GL Open Interfaces

Posted on August 1st, 2007 by Sanjit Anand | Print This Post | Email This Post

Do you know, except for Oracle Assets, most of the subledgers integrated with GL through the GL_INTERFACE table. Then the next question why not Oracle asset ?? will discuss in granular details some other day. For now , you should note that oracle Assets transfers information directly into the GL_JE_BATCHES, GL_JE_HEADERS and GL_JE_LINES tables. Hence importance of GL open Interface cann’t be ignored. I have already discussed the API availability in GL where potential usage is already been discussed.

With that extension, here is cheat sheet for open Interfaces.

With Open Interface ..

• You can integrate with external systems by using published open interfaces
• You can write import programs to import data from an external system or from your previous accounting system
• You can initiate a full account validation process during import. The validation process checks for several items including :
  • Account combinations
  • Periods
  • Unbalanced journal entries
  • Foreign currency errors
  • Budget information
  • Encumbrance information
  • Other miscellaneous items
  • Sharing Information with Sub ledgers