This article has been written because of one interesting consulting question faced.
Find the question, which has been answered within this article. Question raised by one of the top 5 consulting company.
Key points of creation of journal entry through SLA:
There is a new functionality to enter subledger journals through SLA: Create Journal Entry page.
Add the function SLA: Create Subledger Journal Entry, if not available in relevant module. All the modules by default will have this function unless specifically restricted.
Very important point is manual subledger journal entry is not associated with transaction of any subledger application. Meaning we can’t transfer the entries to both Subledgers and GL without customization. This is true whether we use FAH or DRM (Data Relationship Management, which is part of Hyperion) applications.
If required to use Manual SLA Journals functionality to represent accounting treatment in legacy systems, one can use API which allows importing legacy transactions into SLA, change the accounting treatment as per Oracle EBS logic or combination and then transfer to GL.
SLA is a rule based accounting engine not a module, which sits in between Subledgers and GL. The entry that appears in SLA can be controlled or design using SLA rules. Therefore it is known as Rule based accounting engine.
Don’t use SLA: Debug% profile option, which is obsolete. Instead use profile options FND: Debug% for SLA to debug.
To transfer the subledger journal entries to GL from subledgers run the following programs
- Create Accounting
- Run Transfer Journal Entries to GL – conditionally required.
Very important this is the functionality of FAH where we will use API XLA_JOURNAL_ENTRIES_PUB_PKG to load the data into this create journal entry page (see the screen shot below). We don’t need license of FAH to use this package, however.
This is another way of loading the journal entries apart from GL_INTERFACE, Web ADI or manually entering the journals.
This is particularly useful to stream line the accounting string between Oracle EBS and Legacy or third party systems, which is the basic of FAH.
How it works:
Go to Payable Module (any module can be used)
![clip_image002 clip_image002](http://lh3.ggpht.com/-WoBWPocXVAY/TwmHpGgt3uI/AAAAAAAABOg/PSCHzvnm9B8/clip_image002_thumb%25255B2%25255D.jpg?imgmax=800)
Subledger journal entry
![clip_image004 clip_image004](http://lh6.ggpht.com/-O4b-wnw0wAg/TwmHqm7-bsI/AAAAAAAABOw/n3BWV7nZdXw/clip_image004_thumb%25255B2%25255D.jpg?imgmax=800)
Click Create Journal Entry
Enter Debit
![clip_image006 clip_image006](http://lh6.ggpht.com/-vfjpfsinRa8/TwmHsRt_u2I/AAAAAAAABPA/gR0avopn3pk/clip_image006_thumb%25255B2%25255D.jpg?imgmax=800)
Enter credit
![clip_image008 clip_image008](http://lh3.ggpht.com/-jU_ssVWb-ok/TwmHthMjLxI/AAAAAAAABPQ/0dwIbBRK7rk/clip_image008_thumb%25255B2%25255D.jpg?imgmax=800)
Click continue
![clip_image010 clip_image010](http://lh4.ggpht.com/-rMx7O_vbSig/TwmHvKamgeI/AAAAAAAABPc/8i9vD2vCzso/clip_image010_thumb%25255B2%25255D.jpg?imgmax=800)
Select Final and Post and click finish button
![clip_image012 clip_image012](http://lh5.ggpht.com/-Zyx1afZZkIA/TwmHw1QYVNI/AAAAAAAABPw/M3A_38zwV64/clip_image012_thumb%25255B2%25255D.jpg?imgmax=800)
Result
![clip_image014 clip_image014](http://lh4.ggpht.com/-QJb6Xto5Uxw/TwmHyMeq8wI/AAAAAAAABQA/jh3U4R7lVLQ/clip_image014_thumb%25255B2%25255D.jpg?imgmax=800)
System should fire journal import
![clip_image016 clip_image016](http://lh4.ggpht.com/-aHToJEyHIPE/TwmHz3hjh_I/AAAAAAAABQQ/cF3058IyYOE/clip_image016_thumb%25255B2%25255D.jpg?imgmax=800)
Go and check in payables whether any invoice (transaction) created
![clip_image018 clip_image018](http://lh6.ggpht.com/-HSAJ0-G5Xw4/TwmH1pUqcXI/AAAAAAAABQg/GefWdmDqCvo/clip_image018_thumb%25255B2%25255D.jpg?imgmax=800)
Go to GL and check the result
![clip_image020 clip_image020](http://lh4.ggpht.com/--o0yXLH4QMk/TwmH4pOw2wI/AAAAAAAABQw/IeBl90a6AYY/clip_image020_thumb%25255B2%25255D.jpg?imgmax=800)
Note the Category, which is other.
Review the journal
![clip_image022 clip_image022](http://lh5.ggpht.com/-ChQ9GdbBn7U/TwmH6PgzMpI/AAAAAAAABQ8/WvvV9AInqZo/clip_image022_thumb%25255B2%25255D.jpg?imgmax=800)
Click Line Drill down button
![clip_image024 clip_image024](http://lh4.ggpht.com/-YDA4AFzQZmU/TwmH7oLMM-I/AAAAAAAABRQ/1BUOeKhsQLc/clip_image024_thumb%25255B2%25255D.jpg?imgmax=800)
Click view transaction
![clip_image026 clip_image026](http://lh6.ggpht.com/-pI821RZOOb0/TwmH83FVgOI/AAAAAAAABRg/-WAy0bozhZo/clip_image026_thumb%25255B2%25255D.jpg?imgmax=800)
Read the error message, which confirms that no transaction has been created in subledger.
![clip_image028 clip_image028](http://lh4.ggpht.com/-opE5nFJV0Ao/TwmH-iIcUXI/AAAAAAAABRs/uKeo0WNBdVI/clip_image028_thumb%25255B2%25255D.jpg?imgmax=800)