Category 143
Discussion List
-
Email Data Integration Output File as AttachmentSummary: Email Data Integration Output File as Attachment Content (please ensure you mask any confidential information): We have data export file from Data Integration a… -
EPM Agent Automatic Vs Manual - Neither works when run as ServiceSummary: EPM Agent automatic does not work for scheduled jobs but whereas when set as Manual it works. Is there any issue with Agent running as a service when set to Aut… -
Consolidation Status Shows “Completed” When Alternate Entity Hierarchy Is SkippedSummary: Why does the Consolidation status show as Completed even when consolidation is skipped for an alternate entity hierarchy (see screenshot below)? If this is the …Gaurav Kabra 15 views 5 comments 0 points Most recent by Gaurav Kabra Financial Consolidation and Close -
untraced balance in closing balance input memberSummary: We have encountered a strange issue in FCCS where stale data is appearing in the Closing Balance Input for December 2025. This data is showing up even for entit… -
In PROD the LoV Period in Data Management > Data Load Mapping is not appear in pop-up windowIn PROD the LoV Period in Data Management > Data Load Mapping is not appear in pop-up window select Point of View and then must setup Period Key in (N) Data Exchange > A…sarahayuputri 21 views 6 comments 0 points Most recent by NarayananS Financial Consolidation and Close -
Advanced Formatting Issue with Expense Accounts in FCCS Income StatementIn the Income Statement, expenses are expected to display as negative values. So I have applied advanced formatting to show brackets for account type as an Expense. Howe… -
FCCS: ADF_FACES-60097 error when opening enterprise journalThe following error is occuring while trying to open the enterprise journal tab where journals are posted using the template. "ADF_FACES-60097: for more information, ple…Aditi Kavdia 97 views 5 comments 0 points Most recent by Larry Geraghty Financial Consolidation and Close -
Need to clear balances for equity accounts at Parent Currency at parent total levelWe have dissolved some entity hence trying to clear out all the balances for equity accounts , we are able to clear out the balances at Local Currency level, but not abl…Himanshu Goenka 48 views 18 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
HCM 'effective date' and EPM Planning IntegrationSummary: HCM 'effective date' and EPM Planning Integration Content (please ensure you mask any confidential information): I would like to better understand the role of t… -
Netsuite integration to FCCS issues with token expiring after 60 daysSummary: My client has an integration with Netsuite to FCCS which runs fine for about 2 months, then the token appears to be become invalid. Content (please ensure you m… -
How To: Handle Consolidate Business Rule's False Positive Completed Job Status.Summary: This article provides an approach to handle Consolidate business rule's false positive Completed message, whereas the Jobs Details shows that not all entities w…Ashutosh Bhatikar-Oracle 4 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Unable to exclude members based on conditional search from a source filter in EPCM Data ManagementWe are trying to pull only certain cost centers which starts with either "PK*" or "Z0*" etc. but cannot put an Essbase function @MATCH to solve our purpose. However, as … -
FCCS Data Exchange – How to clear an Attribute value once it has been loaded?Hello everyone, I’m working with Oracle FCCS – Data Exchange mappings and I need clarification on how attribute values can be cleared or removed. Scenario: I am mapping …Alberto Parisella 25 views 3 comments 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close -
FCCS data storage archieval guidanceHello We are seeking official guidance and best practices for managing historical financial data and metadata within Oracle FCCS, specifically as it relates to archiving…Prashanth0302 7 views 0 comments 0 points Started by Prashanth0302 Financial Consolidation and Close -
Custom MDX Query in a data integration giving errorHello, I am trying to add a custom MDX query to my data integration. I am following the document at https://docs.oracle.com/en/cloud/saas/enterprise-performance-manageme… -
any idea how to import a data form from one application to a different application?I need to import the same set of data forms to another application but it has a different application name.JB_Purchase 75 views 14 comments 0 points Most recent by Tejesh Mhatre Financial Consolidation and Close -
How to run consolidation for current year skipping impacted prior period consolidationSummary: Client unable to run the consolidation for current year as prior period is impacted and need consolidation. Client is not willing to re-open the prior period an…Avinash Roy 41 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
NOL Assessment at Consolidated Level for Tax FilingSummary: Issue: The system is applying NOLs per entity, not at the consolidated level, which leads to incorrect results. We’ve enabled NOL automation. Currently, our sys…Sanjana Soni 75 views 6 comments 0 points Most recent by Ken Kramer-Oracle Tax Reporting (Direct Tax) -
Slow execution of DELETE FROM TDATASEG_THello, We are experiencing a performance issue in our FCCS environment (Data Integration). The execution of the following query in the backend is taking an unusually lon…MKhade 27 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Error loading Exchange Rates to FCCS Rates Cube via AutomationHello All, I have an Integration defined to load Exchange Rates to the Rates Cube in FCCS from an On-premise Database using EPM Agent, but the rates are failing to expor…Simon Eng 41 views 15 comments 0 points Most recent by Girish Joshi Financial Consolidation and Close -
Long loading time to open a data form on FCCSUser requests to have an extra column showing last year's Period12 YTD as a reference on all data forms. So, I created a Dynamic Calc Scenario member with member formula…Ethal Chan 24 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
SmartView formula 'HsDescription' is not yielding result on the Fusion GL SideSummary: We are using Build Function > HsDescription to show Natural Account Description. However it is not working for us. Does it work on the Fusion Side. Reference : …Wilson Chelakadan 22 views 4 comments 0 points Most recent by Wilson Chelakadan Financial Consolidation and Close -
Simple Tutorial: Import System Exchange Rates from a File Using Data IntegrationSummary: Please find attached a simple step by step tutorial to import text-based exchange rates to FCCS Rates cube using Data Integration. Tutorial demonstrates how to …Ashutosh Bhatikar-Oracle 12 views 1 comment 2 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Data Load at Parent EntitySummary: There is a requirement to enter data at the parent-level entity. The parent entity is associated with only one shared member. We introduced the shared member be…Yashaswini 32 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close