My Oracle Support Banner

Supporting References For Manually Created SLA Journals Fail to Save With JBO-26041 (Doc ID 1088289.1)

Last updated on FEBRUARY 12, 2019

Applies to:

Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.


Creating Supporting reference and when trying to use the supporting reference creating a manual journal entry in SLA the manual journal entry does not save.
Get error when saving manual journal entry with supporting reference:

JBO-26041: Failed to post data to database during "Rollback to Savepoint" SQL Statement "null".

FND log shows and error is thrown while inserting data into xla_ae_lines table in XLA_JOURNAL_ENTRIES_PKG.create_journal_entry_line. Error is :

An internal error has occurred in the program xla_journal_entries_pkg.create_journal_entry_line. ORA-01400: cannot insert NULL into ("XLA")

Creating a supporting reference and using it works fine when running Create Accounting on an item, issue with supporting reference is only with SLA Manual Journal Entry.


Oracle Subledger Accounting Implementation Guide Pg 2-72:

Supporting References
Define supporting references to store transaction information on your journal
entry. You can choose to maintain balances for each account and supporting
reference detail value combination.
After the supporting reference is defined, assign it to the application
accounting definition on the journal line types or on the header for event
class and type. The accounting program will then associate values from the
transaction to the journal entry created, based on your application
accounting definition. You can also enter supporting references for manual
journal entries. Use the online inquiry to view the account balances for a
specific ledger and supporting reference.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.