Data Integration
Discussion List
-
How to put validation to make sure that intercompany account is always tagged with ICP EntitySummary: We wanted to make sure that we always have Intercompany accounts being tagged with ICP entity so that the data in the Intercompany account will be eliminated pr…Kumara Surendra 31 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Multi Period & Multi Year Integration-RowSummary: Hi All, In My flat file Year and Period are exist in ROW and there are multiple period and multiple year existing in the same file and I want to load the file i…Avtar 21 views 1 comment 0 points Most recent by Gebril Abdellatif -Oracle Profitability and Cost Management
-
Set Global POV in System Settings screenIn the new System Settings screen in Data Exchange I set Global POV to 'Yes' and set a value in Default POV Period. But it doesn't seem to apply the setting. My work aro…
-
Can I execute a data map process through groovy using a diffent IDSummary: User need to run a data map but we cannot give them admin access Content (please ensure you mask any confidential information): We have a data map that is set u…
-
TRCS Hybrid model impacting DM Integrations which use Dynamic Calc Members on the Account DimensionSummary: After converting TRCS to the Hybrid model we are unable to use Dynamically Calculated Members from the Account Dimension in Data Management Integrations. Prior …Ivor Davies 41 views 1 comment 0 points Most recent by GaneshN-Support-Oracle Tax Reporting (Direct Tax)
-
Quick Mode - Accumulate Works!Summary: When running the Quick Mode load, only the Replace export mode is supported as per guided document but am able to do accumulate (EPM to EPM same app) Content (r…NarayananS 121 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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 111 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 131 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 31 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 131 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…