Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

API than can be used to load Journals into Subledger Accounting (SLA)

Posted on August 6th, 2011 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

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.

Related Posts

Posted in R12, Subledger Accounting | 1 Comment »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
One Response
  1. shekar Says:


    You are providing some useful information which is useful for many Oracle apps people…keep it up.

    Thanks & Regards,

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.