PBCS FDMEE Drill Through Produces Errors (Doc ID 2077780.1)

Last updated on NOVEMBER 10, 2022

Applies to:

Symptoms

PBCS FDMEE Drill Through Produces Errors. User get drill region errors for data loads to Finance:FIN.

• Number of Plan Types – 2. FIN, Sales.
• Drill Region Errors for Which Plan Type – FIN
• Map Types – Explicit for all drill region dimensions (Account, Entity, Version, Year, Period, Scenario)

Error Message – 2015-10-05 13:25:57,903 INFO [AIF]: DrillRegion msg:com.essbase.api.base.EssException: Cannot Create Drill Through URL. Essbase Error(1200315): Error parsing formula for [REGION DEFINITION] (line 0): invalid object type.

User understand that Doc ID 1467728.1 makes reference to the issue they are having. However, it doesn't address why they have the issue and below is the concern.

When user export data to a plan type, e.g. Finance or Sales, FDMEE crates a drill regions file.  Information in this file allows users to drill through from the target plan type back to FDMEE. A PBCS FDMEE data load applies to one plan type only.  Therefore, an export to the Finance plan type should only include drill regions for members in the associated Finance location.  Problem : User seeing drill regions for target Sales members for data loads associated with the Finance plan type.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.