Subledger Accounting

API load Journals into Subledger Accounting | Oracle SLA

By Jag - August 01, 2012

Oracle provides the ability to enter manual sub ledger journals via a button on the SLA Journal Inquiry pages.


 A manual subledger journal entry is not associated with a transaction or document of a subledger application. If you are considering using the manual SLA journal feature to represent accounting in legacy systems, you can take the advantage of API which allows you to import such transactions into SLA rather than into the GL directly (via the GL interface).


 You can use the API XLA_JOURNAL_ENTRIES_PUB_PKG and any of these functions:
  • Create_Journal_Entry_Header: This is used creates a new subledger journal entry header
  • Update_Journal_Entry_Header: This is used to modifies an existing manual subledger journal entry header, if journal entry is not Final and GL_DATE used must belong to a valid accounting period.
  • Delete_Journal_Entry:This deletes all information of a subledger journal entry including journal entry header and journal entry line
  • Create_Journal_Entry_Line:This is used to Create the JE line
  • Update_Journal_Entry_Line :This is used to Delete the JE line
  • Delete_Journal_Entry_Line :This is used to Delete the JE line
  • Complete_Journal_Entry: This is used to completes a subledger journal entry
  • Reverse_Journal_Entry : This is used to reverse the entry.
These API's you can find more on Oracle Financial Services Accounting Hub Implementation Guide Release 12 Part No. B14420-01
You don't need to have an FSAH License to be able to use those APIs.
  • Share:

You Might Also Like

1 comments

  1. maFebruary 12, 2013 at 5:17 AM

    Hi How to use this API "XLA_JOURNAL_ENTRIES_PUB_PKG"? what are the parameters used to API?
    Can any one send the example program for this please.

    ReplyDelete