Data Integration
Discussion List
-
YTD PL Account can't be filtered when integrating from FCCS to PBCSSummary: I did integration from FCCS instance to PBCS instance. I already filter the dimension that I need (YTD data for BS and PL account). Unfortunately, the result is… -
Write back to fusion ERP GL from EPCMSummary: Errored on the last stage of Importing Journal to GL Interface Table Content (required): Following is the error on the GL side. ORA-06502: PL/SQL: numeric or va… -
FCCS | Data Exchange - Export Data ErrorFCCS | Data Exchange - Export Data Error In Data Exchange > Workbench > Actions > Export Data: when tryinng to export mode online, the process ends with the error "Expor…Timestamp EPM Team 112 views 7 comments 0 points Most recent by Timestamp EPM Team Financial Consolidation and Close
-
FCCS Data Management job fails with tunnelling error messageSummary: We have jobs being run overnight with EPMAutomate used to extract data from our Oracle Fusion ERP and load into FCCS and EPBCS within 5 minutes of each the one …Jeremy Stubbs 31 views 4 comments 0 points Most recent by Jeremy Stubbs Financial Consolidation and Close -
EPM Integration Agent - Windows Services ErrorSummary: I have setup the EPM Integration Agent on our remote desktop and it works when I run it manually and can retrieve data from Snowflake just fine. However, trying…Erik_Olson 132 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
HCM to Strategic workforce planning integrationWe have exported the extracts from EPM instance and imported to HCM and able to configure integration. but when we run the integration we are getting errors. looking for…
-
Unable to extract data from FCCS with 4 decimal pointsSummary: We are trying to export data from FCCS to flat file using data target application for particular POV and we have specified data precision and data number of dec…ShubhamV 51 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Copy file from Object StorageHello all! I'm not able to configure properly my EPM instance to copy a file from Oracle Object Storage to 'inbox' in my Pipeline. 1- I created a Connection named Object… -
Netsuite source period mapping not working with FCC data integrationSummary: Hi please can anyone help with defining the source period mapping using Netsuite as a data source and bringing data into FCC via data exchange? I have added the…
-
Pipeline Limitation - Combination of Static and Substitution VariablesHello, When submitting a Pipeline with a combination of static and substitution variables, say StartPeriod of Jan-23 and EndPeriod of &SubVar(Value is another period), t…
-
EPMAUTOMATE command doesn't exist to launch pipelineSummary: EPMAUTOMATE commands are not available to launch Pipeline. Content (please ensure you mask any confidential information): Unable to launch pipeline job. Version…Sreenivas Rayala-Oracle 32 views 1 comment 0 points Most recent by NarayananS Profitability and Cost Management -
How to access data management load rule log file using EPM REST APISummary: We are using REST API to trigger a data lod rule and we are able to expose the output as a REST API CSV content but we need to access the corresponding log file…NarayananS 132 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Setup EPM Agent (Additional?)Hello all, How do you get the EPM agent to pull data from an additional data source? How or where is it configured? We have a single EPM which pulls data into our FCC/AR… -
Downloading file from OCI sub-directory using Pipeline Object Store JobsSummary: Using EPM Pipeline - Object Store Jobs, I tried downloading a file from root folder of OCI bucket, it worked fine. I need to download the SOURCE file from sub-d…Mohit Sharma-73954 91 views 14 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
Where i can find sequence option available on Target application in DM in Data ExchanageDear Experts, I want to change order/ sequence of processing order for dimention in data load mapping. Earlier Squence option was available in DM target App screen now i… -
Metadata load from Data Management fails for Replace in Import and Export modesSummary: Metadata load from Data Management fails for Replace in Import and Export modes, it works for Replace and Merge when executed from Pipeline. Error is 'Plan type…
-
Warning status in Data ManagementSummary: In Data Management, processes can finish successfully with a warning indicated by a yellow icon. This usually happens when there are no records imported from th…
-
Error in loading PCMCS data to EPBCS financialsSummary: Trying to push data from pcmcs to epbcs but facing a issuse in transform step. Content (required): We tried mapping the target application values(EPBCS Financia…
-
Import Fusion Supporting References in EPMSummary: Is there a way to import Fusion Journal Supporting References as attributes/use them as LOOKUP mappings in EPM applications (FCC)? Content (please ensure you ma…
-
SubVar DataLoadConsolMember set to TRUE is not workingSummary: We add this subvar DataLoadConsolMember to TRUE to prevent data amount override being cleared during export data to FCCS using Replace Method, but don't know si…J Mahero L 133 views 20 comments 0 points Most recent by Joost Mellegers Financial Consolidation and Close
-
Data Load Rule Data Not Populating FCCSHi all, We are trying to directly integrate FCCS and OAC, so we have set up a data load rule that extracts the data from FCCS and puts it in an excel file that gets pick…Sarah Paroya 51 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Unable to refresh members from source (EPBCS) application in an EPBCS to EPCM integration.Summary: In Data Management I am unable to refresh members from the source application (EPBCS Reporting cube) after registering the EPBCS application. In error log it's …Sanchari Chakraborty-Oracle 136 views 4 comments 0 points Most recent by Sanchari Chakraborty-Oracle Profitability and Cost Management
-
Period name - Source filter in Data load ruleSummary: The EBS on-premise data base is integrated with FCC using the EIA agent . We have used the EBS adaptor for the integration which internally uses two parameters …
-
EPCM - YTD from PTD source data for every periodSummary: In EPCM, all of my current month calculations require previous month YTD data for calculation. we have not created any additional period type dimension and its …Anantha Krishnan 182 views 9 comments 0 points Most recent by Anantha Krishnan Profitability and Cost Management
-
Drill through from FCCS to Cloud ERP redirecting to a different URLSummary: Drill through from FCCS to Cloud ERP redirecting to a different URL Content (please ensure you mask any confidential information): A connection is setup in Data…