Ar_periodclose_analyzer.sql is failing with error ORA-00904: "AR"."CREATE_DETAILED_DIST_FLAG": invalid (Doc ID 2298102.1)

Last updated on AUGUST 17, 2017

Applies to:

Oracle Receivables - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.0.6 and 12.1.3 versions:
When installing 'EBS Oracle Receivables Period Close Analyzer (Doc ID 2019636.1)' get following error:

ERROR
-----------------------
Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY AR_PERCLOS_ANALYZER_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
4748/9 PL/SQL: SQL Statement ignored
4748/51 PL/SQL: ORA-00904: "AR"."CREATE_DETAILED_DIST_FLAG": invalid
identifier
========================================================================


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