Data Integration
Discussion List
-
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 11 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 132 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 62 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 92 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 21 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 131 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 384 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
-
Correct amount is not being retrieved in Data IntegrationHello, In Financial Consolidation and Close, when I ran Data Exchange>Data Integration. The correct amount is not being retrieved. I have attached my mapping and the scr…Noah01010101 71 views 12 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Error connecting to FCCS from Data Management of on-prem HFMI am getting below error when connecting to our Cloud POD and I am pretty sure, all the details I entered are accurate. Both the source and target are in same domain.SR912 91 views 15 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How can Data Integration Pipeline or Integration be copied?Hi! I need to copy couple of Data Integration Integrations and Pipelines from Test environment to Production. Is there a way to do that without copying anything else (so…
-
Snowflake to FCCS integrationIs it possible to integrate data from Snowflake to FCCS? Are there any reference documents/whitepapers around this?SR912 31 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
DI: Drill Through does not work with FCCSSummary: Content (please ensure you mask any confidential information): Hi all We are trying to rul a Drill through in FCCS via Data exchange but we are getting this err…
-
Usage of Drill throughHi There, We have enabled the Drill through option in FCCS and loaded the data through data integration(Current period). We are unable to drill through for the previous …Sashidhar Reddy 21 views 3 comments 0 points Most recent by Sashidhar Reddy Financial Consolidation and Close -
Deletion of IntegrationsIs there any faster and fastest way to delete integration from Data Exchange/Data Integration? In data management terms, we have 5 DLR connected to a location , moreover…MKhade 11 views 1 comment 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
Error while import application (data source) ERP fusion CloudError while import application (data source) ERP fusion Cloud (test environment) in FCCS (test environment) Data Exchange for integration. The log issue is below; 2024-0…
-
What is the size of FCC Outbox?Summary: What is the size of FCC Outbox? Content (please ensure you mask any confidential information): What is the size of FCC Outbox? What happens to the files in outb…Vidhi Nenwani 11 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Functional Currency under Location DetailsSummary: Exchange Rates via BIP Report from GL to FCCS Content (please ensure you mask any confidential information): We wanted to check if and confirm if the Functional…Kenneth John Asper-Oracle 31 views 4 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close