Create Accounting Errors Out For Cost Management Sub-ledger Application

(Doc ID 2385328.1)

Last updated on APRIL 22, 2018

Applies to:

Oracle Fusion Cost Management Cloud Service - Version 11.13.17.11.0 and later
Oracle Fusion Cost Management - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

Create Accounting Execution Report fails for Cost Management sub-ledger application.

Following error is seen in the log file

Error:
Cannot get context MPA_ACCRUAL_EXISTS for client

xla.plsql.xla_fsn_acct_reports_pkg.BeforeReport=>p_parent_gl_date_sel = NULL

xla.plsql.xla_fsn_acct_reports_pkg.BeforeReport=>p_accrev_from_str =

xla.plsql.xla_fsn_acct_reports_pkg.BeforeReport=>p_accrev_where_str =

xla.plsql.xla_fsn_acct_reports_pkg.BeforeReport=>P_EVENT_FILTER =

xla.plsql.xla_fsn_acct_reports_pkg.BeforeReport=>P_ZERO_AMT_FILTER = AND (NVL(ael.accounted_dr,0) <> 0 OR NVL(ael.accounted_cr,0) <> 0)
  AND NVL(aeh.zero_amount_flag,'N') = 'N'

10-04-2018 10:07:44 - Finished Before Report



Steps:
The issue can be reproduced at will with the following steps:
1. Navigator > Scheduled Processes
2. Submit the 'Create Accounting' process
3. Create Accounting process ends in warning
4. Create Accounting - Subprocess completes successfully
5. Create Accounting Execution Report ends in error with the above errors in the logfile

Changes

 

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