Supporting References For Manually Created SLA Journals Fail to Save With JBO-26041
(Doc ID 1088289.1)
Last updated on FEBRUARY 12, 2019
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.
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!