PBCS FDMEE Drill Through Produces Errors (Doc ID 2077780.1)

Last updated on APRIL 20, 2017

Applies to:

Oracle Planning and Budgeting Cloud Service - Version 11.1.2.3.400 and later
Information in this document applies to any platform.

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

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