My Oracle Support Banner

FCCS Data Management Unable Pull ONLY TOP Level Parent Data From FCCS Application (Doc ID 2633326.1)

Last updated on JULY 07, 2021

Applies to:

Oracle Financial Consolidation and Close Cloud Service - Version N/A to N/A [Release 11.1]
Information in this document applies to any platform.

Symptoms

While trying to extract ONLY TOP LEVEL Members from FCCS Application using  Data Management,  in data load rule even if source filters are defined at top-level Members , data Management is pulling the level zero data.

Example of Extract Fix Statement

FIX ("FCCS_Intercompany Top",@Relative("FCCS_Balance Sheet",0),@Relative("LTDCN",0),"FCCS_ClosingBalance","FY18","Total Additional Analysis","Dec","FCCS_IFRS","FCCS_YTD","Actual","Total Business unit","Total Business Class","FCCS_Entity Total","FCCS_Total Data Source",@Relative("Currency",0))

Example of Extract Data

FCCS_Balance,LE-0012-USD,FCCS_No Intercompany,FCCS_Entity Input,FCCS_Managed Data,Local IFRS,FCCS_ClosingBalance,No Business Class,No Business unit,Actual,Dec,EUR_Reporting,XXXX.XXX
ST Debt,LE-0012-USD,FCCS_No Intercompany,FCCS_Entity Input,FCCS_Managed Data,Local IFRS,FCCS_ClosingBalance,No Business Class,No Business unit,Actual,Dec,USD_Reporting,XXXX.XXX
FCCS_Surplus,LE-0012-USD,FCCS_No Intercompany,FCCS_Entity Input,FCCS_Managed Data,Local IFRS,FCCS_ClosingBalance,No Business Class,No Business unit,Actual,Dec,EUR_Reporting,XXXX.XXX
FCCS_Balance,LE-0012-USD,FCCS_No Intercompany,FCCS_Entity Input,FCCS_Managed Data,Local IFRS,FCCS_ClosingBalance,No Business Class,No Business unit,Actual,Dec,Entity Currency,XXXX.XXX
FCCS_Surplus,LE-0012-USD,FCCS_No Intercompany,FCCS_Entity Input,FCCS_Managed Data,Local IFRS,FCCS_ClosingBalance,No Business Class,No Business unit,Actual,Dec,Entity Currency,XXXX.XXX

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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