Data Integration
Discussion List
-
Sending data from EPCM to FAHHi everyone! We have a requirement that we need to send the allocated data from EPCM to Oracle FAH. Does Data Exchange/Data Integration have the option to connect to FAH…GaryYip-Asc 41 views 5 comments 0 points Most recent by GaryYip-Asc Profitability and Cost Management -
For filebased data load is happening in FCCS Data load rule, will only rejected records be skipped?Summary: When running a data load rule to load records in FCCS from file, there are records rejected due to invalid intersections, will none of the records be loaded or …Arvind Moorthy-250185 21 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to load FCCS YTD actual load to EPBCSSummary: We are trying to pull the YTD value for FCCS_Minority Interest to push to EPBCS, however, per checking it is still pulling the Periodic value. Does anyone encou…User_ZCB13 31 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
pipeline, variables and a "prompt" to choose a versionSummary: Allow administrators, when running a pipeline, to specify which data "version" is contained in a load file—without requiring this information to be embedded wit… -
data exchange Import issue Applying Amount MappingSummary: I am facing issue during Import step of Data Exchange. Below error: It is allocation data writeback from EPCM to ERP. Integration is able to extract data out of…Ravinder Singh-63390 31 views 11 comments 0 points Most recent by Ckopparam EPM Platform and Freeform
-
calculate amount column in data load mappingSummary: Requirement is to calculate the amount dimension as * to 1/Amount in FCCS data load integration. Kindly help me in sharing knowledge on the efficient way to han…PrinceKumar 21 views 3 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
Multiple Adjustment Periods in Data Management for ARCS Data LoadSummary: Hello Everyone, I am working on ARCS Data Loads using Data Management and would like to check if anyone has experience with configuring multiple adjustment peri…DarshanJ 1 view 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
Issues Importing Maps in Data Exchange/Management with Comma in Source ValueSummary: We have a number of maps that utilize commas within their Source Value definition. This has never presented as a problem, as wrapping them in double-quotes duri… -
SmartView give errors: Drill through not being availableSummary: The issue appears to be mostly around parent accounts, but I have seen child accounts get the same error as well. when i am trying to do the drill through form …User_8OIEK 33 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Uploaded FBDI Template for PO receipts creation with serial number and PalletDFF?Summary: Uploaded FBDI Template for PO receipts creation with serial number and PalletDFF, upload was success, no error logs were received, but the records was not showi…Anil Mattapally 11 views 1 comment 0 points Most recent by Lakshmi V-Oracle Payables, Payments & Cash Management
-
Need to capture the start and end time of a Data load Rule(Data Exchange) in Groovy Rule.The Request is to get REST API output in json format like start time and end time of a Data load rule in Data Exchange. I have created groovy script to extract the log f…Radha Yerra 51 views 5 comments 2 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
oracle account reconciliation : how to delete data by locationSummary: I need to delete data from two location only and not from all the location Content (please ensure you mask any confidential information): Version (include the v…
-
Unable to Export Attribute Member Consolidated Data in EPBCSCurrently, in on-prem, we are exporting data using attribute members, which means we are getting consolidated data rather than associated members through a report script… -
Default Movements Enabled - FCCS_Retained Earnings child accounts creating out of balanceSummary: Balance Sheet out of balance is system generated by children input accounts under FCCS_Retained Earnings in new year. The Default Movements rule is enabled and …TAMMY_L 81 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Multi Period Data LoadingNeed to know whether multi period (multi column) data loading (12 separate columns for each month) available in FCCS when loading flat files.
-
Is there a way to load adjustments from Oracle ERP to FCCS in different data source members of FCCS?Is there a way to load Period 13, Period 14 and Period 15 adjustments from Oracle ERP to FCCS in different data source members of FCCS? Basically I am looking to load p1…Ashif 31 views 4 comments 0 points Most recent by Ravi Akula Thimmaiah Financial Consolidation and Close
-
Registering application and configuring connection for ARCS Transaction Matching's GL Data SourceWhen configuring ARCS Transaction Matching for AR to GL and AP to GL which data source should we use for the GL? I can see that there are available data sources for AR a…Jmlopez 11 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
Drill thru to data management in FreeForm appSummary: I have a FreeForm app where during configuration Scenario dimension wasn't enabled. I recently setup a drill region for direct drill thru to the staging area of… -
REST API to populate EPM Application with Forecast DataSummary: REST API to populate EPM Application with Forecast Data Content (please ensure you mask any confidential information): We are integrating PMIS (3rd party system…
-
Select Account from Target Dimension in Data MappingWe have to configure data load mapping in such a way where we need to map source to target based on condition that source member should exist in target otherwise all sou…
-
Failure in executing integration with "OWP_Incremental Process Data and Synchronize Definition" ruleSummary: I have executed an incremental file-based integration but whenever I am executing this integration by adding the rule in business rule section, it is showing er…
-
In Data Integration what is the difference between Target Period Year and Target Year?Summary: In Data Management/Data Integration, what is the difference between Target Period Year and Target Year in Period Mappings? Content (please ensure you mask any c…
-
Is new incremental file application mandatory if file has new columnsSummary: I have created an executed an incremental file adapatar based integration, now suppose I have new columns added in my file, do I have to create a new incrementa…
-
How to map missing values in integration in EPBCSSummary: I want to execute an integration wherein if the "Union" column is "APS" or "Unaffiliated" for example, then the "Salary Grade" field for it will be blank. I was…Suravi 41 views 10 comments 0 points Most recent by Vijay Mahantesh-Oracle EPM Platform and Freeform
-
Issue with Period Mapping in Data Management - Source-Period Column Showing Amount Instead of PeriodHello All, We are integrating data between two PBCS PODs. Our goal is to map data from the Jan-Dec periods to 'No_Month' in the target POD. To accommodate this, we have …
-
Data Load Rule "Date format for date data" ignored for User Preferences date formatSummary: The "Date format for date data" setting in a Data Management integration is being ignored and the user running the integration user preference date setting take…
-
How can I use one integration across more than one scenario?Summary: Suppose I have created one integration for actual category to load data into my reporting cube from financials, but I want the same integration to be used acros…Suravi 51 views 4 comments 0 points Most recent by Jeelan Banglewale-Oracle EPM Platform and Freeform
-
Automated Task for Pipeline execution in FCCS NOT WORKINGHello, I am trying to schedule pipeline automated tasks using task manager in order to schedule the integrations using holiday rules. Even after the start data and start…Ashif 41 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can we increase the precision in data management data load file.Summary: We are running to load exchange rates from data management, however we came to a problem where we are trying to load 15 decimal, but it is loading only up to 6 …
-
Executing IPM Insights in EPCM - EPMAutomate/Groovy/RESTSummary: Automation and scheduling IPM Insights in EPCM using either EPM Automate, Groovy or REST API Content (please ensure you mask any confidential information): I am…Andy Das 91 views 7 comments 1 point Most recent by Don Bean-Oracle Profitability and Cost Management