Data Integration
Discussion List
-
pipeline change logSummary: Is there a log (hopefully in the Audit Log) that shows date/time/UserID of changes to an existing pipeline Content (please ensure you mask any confidential info…Russ 31 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
The form RestDataGrid_xxxxxxxxxx is invalid.Summary: We are seeing this error when loading the data into FCCS from ERP. What does this error mean? Can you please help us? Content (please ensure you mask any confid…Divya_Masoodi 41 views 2 comments 0 points Most recent by Divya_Masoodi Financial Consolidation and Close
-
Map default_movement in accounts dimension to a movement member in data exchangeSummary: We have created customized movement dimension members for our current client and utilized the default movement attribute in the account dimension. However, we e…Jane Wang 61 views 11 comments 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
Drill Through from summary not working in FCCSummary: I've set Create Drill Region and Enable Drill from Summary to "Yes" and reloaded the data. Drill through works when you try drilling from a base-level member bu…Joao Carlos Monteiro 31 views 2 comments 0 points Most recent by Joao Carlos Monteiro Financial Consolidation and Close
-
Integration fails with not so common error msgWe have a file based data load to FCC system and it has failed with a very strange Error msg: ERROR [AIF]: The rest service request has failed: 400 - {"status":400,"deta…MKhade 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
When zero is loaded to a Historical Amount Override account, the zero is not recognizedWhen zero amount is loaded to a Historical Amount Override account, the zero is not recognized in FCCS in Parent Currency after consolidation runs. Instead, the Parent C…Jacalyn Munyon 11 views 4 comments 0 points Most recent by Jacalyn Munyon Financial Consolidation and Close
-
FCCS YTD Data Extract from FCCS to a file using Data Integration produces file with only headersI am trying to pull YTD data from FCCS into a file using Data Integration. I see rows in workbench with correct periodic numbers but the data file that gets generated on…Karthiga Devi Ramanathan 32 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Extracting Data from FCCS for YTD without Data ExchangeSummary: Hi, Currently, users use HFM Extract data load option to extract data from HFM. However, they want to have similar option in FCCS but they do not have access to…Sud VJ 21 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Pipeline feature using EPM commandSummary: Pipeline feature triggering EPM command and EPM automate command triggering pipeline Content (required): Is there any EPM Automate command to trigger pipeline? …Ramsha Ansari 821 views 13 comments 3 points Most recent by DJ Banga Financial Consolidation and Close
-
Task Manager connection to Oracle ERP fusionSummary: Task Manager Integration to Oracle ERP fusion Content (please ensure you mask any confidential information): Hello, I am trying to integrate FCC Task Manager wi…Rashmi Subash 84 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can we load .xlsx file format in FCCS data management?We want to load .xlsx file format into data management? Is there any work around available apart from converting the format externally using macro into .xls or .txt form…Utkarsh Choudhary 14 views 1 comment 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
Hi, what is the approach used for regression testing for Oracle PrimaveraSummary: what's the period Oracle expects the customer to complete the regression testing Content (please ensure you mask any confidential information): Version (include…User_6Q25H 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Inconsistent behavior of data load in FCCHello, We came across strange issue as mentioned below: Using Data Exchange, file based load was done for one of the entity and it is visible in Workbench. But same is n…
-
Issues in Drill thru in Forex and ERP cloudSummary: I am experiencing problems with drilling through forex data. I am utilizing an ERP adapter to extract forex data from the ERP cloud. We have deployed the BI rep…
-
All Data Extract from FCCSSummary: We want to extract all the data from FCCS to a csv file and are facing challenges. Content (please ensure you mask any confidential information): Hi Experts, Ou…Aditya Mehta 158 views 13 comments 0 points Most recent by Eddie F Financial Consolidation and Close
-
Is there any way to get behind the system user "frs_epm_prod" to see the actual userSummary: We use a number of data load rules (DLRs) that combine several steps to make the data load process as easy as possible for the users. When these rules are run w…Erringc 21 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Different job types in Pipeline - how to set variables?I have created a Pipeline with different job types. I have Integration job types on first stage card and Business Rules on second one. On runtime variable I have start p…soile.alm 61 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Seeking REST API Endpoint for detailed Failure Information on FCCS Data Load Rule ExecutionSummary: When executing the FCCS Data Load Rule via REST API, we are unable to retrieve the exact failure message from the Error Log file. The response JSON from the DLR…dkr_epm1 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Change Consol Operator for FCCS_Total Liabilities/Equity and ExpenseSummary Change Consol Operator for FCCS_Total Liabilities/Equity and ExpenseContent Have anyone have tried to change the Consol opeartor for FCCS_Total Liabilities, FCCS…
-
EPM Integration Agent Query data from JDEThe EPM Integration Agent was built and the data was queried from JDE. Our requirement is to TRIM and concatenate the data using a CASE expression. Are there any suggest…Dharanidharan M 71 views 13 comments 0 points Most recent by NarayananS Financial Consolidation and Close
-
DM: Data load is taking over 1h to load data when it used to take 30 secondsSummary: Content (please ensure you mask any confidential information): Hi all We have an issue where data load from EPM Data Management is taking over 2 hour to load wh…NK2025 91 views 32 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close -
Error log Limit 1000 linesSummary: EPM has a limit of error lines for importing data into data management which is 1000 lines. We suggest this limit be parameterizable since in many cases informa…David Mata 30 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Integration execution failed, Outline load finished with errors.Hi, I am trying to import data using data integration. Once I have run the integration. I am getting this error in log "Outline load finished with errors" Here is the lo…Noah01010101 144 views 10 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close
-
Request for list of ERP service user 'roles / Privileges' for Direct integrations to FCCSSummary: Hi, Can anyone suggest what the Oracle suggested roles to be assign while creating a Service user in ERP, which we use for ERP to FCCS direct integrations. I ca…Anand Rasa 31 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS integration with Microsoft dynamicsSummary: Customer is looking for an option to do direct integration with MSD ( Microsoft dynamics ) - can we utilise integration agent? Content (please ensure you mask a…Alok P DAMAC 61 views 5 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Data export of same combination to two different targets drops export for second targetWe are trying to export data for a combination to two different target members. It exports data for the first Target member but does not export for seconds Target member.
-
Enable Default Movement Setup FCCSummary: Enable Default Movement in FCC. Currently we manually set up our movements in FCC when new accounts are created. To avoid manual process, we would like FCC to p…Sanjana Soni 390 views 38 comments 0 points Most recent by Sanjana Soni Financial Consolidation and Close -
@ILvl0Descendants() function extracting Dynamic calc memberWe have DLR to extract numbers from FCC. We have defined @ILvl0Descendants("[Custom1].[Total Custom1]") for Custom1 dimension in source filter and expecting level 0 memb…
-
EPM Agent Seeded QuerySummary: From Planning I set up a app with the "EBS GL Balance" app and can execute the Preseeded Query against the agent, I see the query string it in the log. How do I…
-
FX rates pull from ERP to FCCS - Dimensions mapping questionSummary: I have this request from my client to Pull FX rates from ERP to FCCS application. and am following this document: am stuck at Dimension Mapping (step #9 in the …Kemp2-Oracle 11 views 1 comment 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close