Data Integration
Discussion List
-
Excluding one particular Level 0 account from Data Exchange exportSummary: Content (please ensure you mask any confidential information): We are exporting data from FCCS data exchange feature to a file. There is a requirement that we d…ShubhamV 131 views 16 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Drill Through from FCCS back to JDE through OICSummary: We are Integrating JDE(on-prem) to FCCS using OIC. Here JDE is connected to OIC through JDE Orchestrator using REST API. Also FCCS is connected to OIC using RES…Dharanidharan M 1 view 2 comments 0 points Most recent by Dharanidharan M Financial Consolidation and Close -
Extract Entity currency through Data ManagementSummary: Hi There, We have created a location in Data Management which uses source as FCCS application(Consol). When we extract the data by running the data load rule wi…Sashidhar Reddy K 21 views 5 comments 1 point Most recent by Sashidhar Reddy K Financial Consolidation and Close
-
Pipeline StartPeriod and EndPeriod VariablesSummary: We would like to use Substitution Variables set at the application level to drive the date values for the StartPeriod & EndPeriod integration from ERP to EPM/PC…
-
Data integration: Is there a way to load/drop a file into Integration inbox using API or GroovySummary: Content (please ensure you mask any confidential information): Hi all Can you let me know if there is a way to load/drop and file into the data integration INBO…NKW 51 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Oracle EPM cloud to AWS Latency issue.We are using EPM integration agent to do writeback from EPM cloud to a data warehouse in AWS. We are seeing significant latency while doing this writeback. The ping test… -
401 error when running data integration in data exchangeSummary: When running a data integration I am receiving a 401 error for the target application. I am using a service account. I verified the service account can log into…
-
EPBCS - what are the reasons for 200MB limitation for export file in EPBCS?Hi, Currently there is a limitation of 200 MB on the size of the export file when executing a Datamap in EPBCS via a Groovy Rule which is causing us a bit of a headache …AyandaKrumalo12 111 views 2 comments 0 points Most recent by AyandaKrumalo12 EPM Platform and Freeform -
FCCS delete method in groovy script returns errorWe have a requirement to delete members in Accounts dimension via a groovy script. However the delete() method returns an error stating it is not allowed. We've been abl…Randy Haight 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
EPM REST Download ZIP file not as a content but the actual file - Metadata ExportSummary: EPM REST allows to download ZIP as a content but wanted to know if it can be downloaded as a file itself same as EPM Automate? The concern is as is it zip it do…NarayananS 42 views 1 comment 0 points Most recent by Vijay Mahantesh-Oracle EPM Platform and Freeform
-
Pipeline Integration for Non-admin UsersSummary: Hi , Can Pipeline Integration jobs be executed by Non-admin Users? Any thoughts on this Content (required): Version (include the version you are using, if appli…
-
Retained Earnings Prior balance becomes zero when data is loaded in current periodSummary: Current year Retained Earning Prior is successfully populating from previous year Retained yearning CB. However when data is loaded in current year, Retained ea…
-
Groovy Pipeline execution - Variables are mandatory?Summary: Using a Groovy BR to trigger a pipeline (export mapping job) and it was working fine with no variables defined. When the rule was triggered today interestingly …NarayananS 14 views 1 comment 0 points Most recent by Suruchi S-Support-Oracle EPM Platform and Freeform
-
Data ExchangeSummary: Hi All, Is there is any webinar or workshop conducted by oracle for Data Exchange topic. Can any one share the Link. Thanks in Advance.Avtar 31 views 3 comments 0 points Most recent by Raavi Divya sri-Oracle Profitability and Cost Management
-
Enabled Pipeline Execution for non-admin users but it is not working.We have Enabled Pipeline Execution for non-admin users but it is not working. When logged in as a user, we are unable to see the Pipeline job in Data Exchange. We follow…Mamtha Deepak 29 views 4 comments 0 points Most recent by Mamtha Deepak Financial Consolidation and Close
-
How to Pass System date and (System date-1) value for BIP report integration parameter valueHi Everyone, We've a requirement where i need to use From Date and To Date as parameters for BIP report integration in Data Management. I know we can use $SYSTEM_DATE[yy…Kishan Kesanakurthy 256 views 2 comments 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform -
Data Clear POV via PipelineSummary: Hi All, We are using pipeline feature to clear POV. We are getting error while executing the pipeline. I am attaching the configuration below is the parameters …
-
Data Management folder securitySummary: We would need a security on Data Load Rule folder in Data Management for TXT files Content (please ensure you mask any confidential information): Dear Experts, …Stefano Francese 31 views 6 comments 0 points Most recent by Stefano Francese Financial Consolidation and Close -
Disable/Skip/Mark as dummy for a particular stage or a job in a pipelineSummary: We would like Oracle to add a functionality to disable/skip/mark dummy a particular stage or a job in a pipeline across all Oracle EPM Cloud applications Conten…Priyesh P. Rane 21 views 5 comments 1 point Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Drill through to data source using Apache Web serverWe are trying to drill through from FCCS to SQL Database for that we have configured the Apache Web server but still, we are not able to achieve so could you please help…Prem Siva Kumar Reddy Rami Reddy 11 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
How to export the DM of all process details logs into an excel format with status for month in EPBCSSummary: We need to export EPBCS Data Management process details logs with status into an excel/report. This report is for auditing purpose on monthly basis. Is there a …Neelima Dasari-78355 61 views 2 comments 0 points Most recent by Krishna_0601 EPM Platform and Freeform -
Direct Drill through passing fully qualified name in FCCSummary: Hello Experts, The drill through report which was configured to pull back the data from relational database is sending fully qualified entity and cost center me…Swaraj Vamaravelli 31 views 3 comments 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close