PJF: Create Accounting Gives No Output for a Single User. Error in Log is 'Inserting into xla_fsn_events_int A system error occurred. Your help desk was notified.'
Last updated on APRIL 30, 2018
Applies to:Oracle Fusion Project Foundation Cloud Service - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
When running Create Accounting in Project Costing, two users can run the process successfully but one user, receives no output and the following appears in the log file:
xla.plsql.xla_fsn_acct_parent_pkg => 20-04-2018 14:46:27 - Inserting into xla_fsn_events_int
20-04-2018 14:46:27 - Failure =
A system error occurred. Your help desk was notified.
xla.plsql.xla_fsn_acct_parent_pkg => 20-04-2018 14:46:27 - Post Accounting Started
xla.plsql.xla_fsn_acct_parent_pkg => 20-04-2018 14:46:27 - Global Context cleared
The server log shows:
ORA-20969: Request 23795 exited with ERROR: : Review the Create Accounting Program Execution Report with process identifier 23796 for the events processed and journal entries created.
The successful user receives:
xla.plsql.xla_fsn_acct_parent_pkg => 20-04-2018 14:32:40 - Inserting into xla_fsn_events_int
xla.plsql.xla_fsn_acct_parent_pkg => 20-04-2018 14:32:40 Number of Events Inserted in XLA_FSN_EVENTS_INT =1
xla.plsql.xla_fsn_acct_parent_pkg => 20-04-2018 14:32:40 - Done inserting
Suspected the users didn't have access to xla_fsn_events_int but the user has the Project Accountant role with the proper data set assigned
The following is also returned in the log file for the 3 users and thus does not seem related (confirmed sequencing is off for this ledger)"
Sequence is not defined for the Ledger : XXX XXX Primary Ledger
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