Supporting References For Manually Created SLA Journals Fail to Save With JBO-26041
Last updated on MAY 15, 2018
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:
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms