Data Integration
Discussion List
-
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 783 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 61 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 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 12 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 103 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…
-
Map Member in Data IntegrationI can't access dimension data when map membee in data integration because "Unable To Retrieve Members. Either The Target Is Unreachable Or You Do Not Have Permissions" I…Jessican 82 views 21 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 75 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…Nkehli 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 66 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 52 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 325 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 84 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…
-
FCCS | Data Exchange - No acess to folders in file browserSummary: When we access Data Exchange > Actions > File Browser, we can´t see any folders, even though they were created. At the same menu but in Data Management, we can …Timestamp EPM Team 31 views 2 comments 0 points Most recent by Angela Lewis Financial Consolidation and Close
-
Snowflake to FCCS integrationIs it possible to integrate data from Snowflake to FCCS? Are there any reference documents/whitepapers around this?SR912 33 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