Data Integration
Discussion List
-
Data at Entity Currency is not Populating in Parent Currency or Reporting Currency on ConsolidationSummary: Hi Experts, The data for specific accounts in FCCS is not populating for Entity Currency, Reporting Currency (USD Reporting), and Parent Currency. The data is c… -
How to get parent child expression for entity dimension in "Data Export to File" Target Application?Summary: How to get parent child expression for entity dimension in "Data Export to File" Content (please ensure you mask any confidential information): we are extractin…Harshith J Rao 61 views 2 comments 0 points Most recent by Jane Wang Financial Consolidation and Close
-
Import data into dynamic calc memberHi! Recently I've got a situation where in the csv file, to import data through Data Exchange, contained some Dynamic Calc members from Account dimension. I expected an …Guido Zanella 51 views 11 comments 0 points Most recent by Guido Zanella Financial Consolidation and Close -
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 132 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 41 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 11 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 21 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 267 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