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.'

(Doc ID 2392976.1)

Last updated on APRIL 30, 2018

Applies to:

Oracle Fusion Project Foundation Cloud Service - Version 11.13.17.11.0 and later
Information in this document applies to any platform.

Symptoms

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



Cause

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