Data Integration
Discussion List
-
Data Exchange ORA-38141: SQL plan baseline SQL_PLAN_7sk2xfbbyuh0s07759eef does not existLoads are failing in Prod and we think the error is shown in the following lines of log: 2024-11-08 13:59:06,840 INFO [AIF]: Fetching dim col mapping for Application:Fin… -
How to customize the email subject or body in Pipeline notifications?Summary: In EPBCS Data Exchange, when triggering a data integration pipeline, the email notification defaults to the following format: Subject: "TestWorkforceMetadata : … -
Can I get an artifact snapshot from an earlier date?Summary: I need an artifact snapshot from an earlier date as the on automatically created. Is it possible to get it from Oracle, since it is overwritten every night? Con…JSchil 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Bank File format load to Predictive Cash ForecastDoes Predictive Cash Forecast Plan type allow to load Bank (BAI2) file format files( for Balances and Transactions) using Data exchange with Category : Data Source ,Type…satishpatakota 64 views 3 comments 0 points Most recent by Chris P-Support-Oracle EPM Platform and Freeform
-
Editing Existing Pipeline Details & Save Remains Greyed Out?Summary: We have created a couple Data Integration Pipelines in FCCS that move data from our FCCS application to our EPBCS application & they work fine. When we needed t… -
Using OIC with Oracle PBCS - Where to find certificate?Hello, We are experimenting Oracle Integration Cloud and thinking of using PBCS with it to see if there are any processes that could be improved. I am looking at the Ora… -
Issue with Loading Data into "Budget Adjustment" in EPBCS to Fusion Budgetary Control CubeHello All, We were able to successfully push data into the initial budget in the Fusion Budgetary Control cube. Now, we are trying to push budget transfers into the "Bud…DarshanJ 92 views 1 comment 0 points Most recent by Suruchi S-Support-Oracle EPM Platform and Freeform
-
EPM Integration Agent- Writeback timeoutHi, I have an integration where I'm extracting to a target RDBMS (Snowflake). The essbase extract is successful. It is timing out. See log. I am using the same agent to …
-
How to load Begbalance data using epmautomate runIntegration?Summary: We need to load data at BegBalance and at No year. We need to load it using epmautomate runIntegration command. What is the correct way to use this command for …
-
CopytoObjectStore feature in pipeline doesnot copy file from Data Management specific locationSummary: I am using CopytoObjectStore feature in pipeline to copy file from Data Management specific location to Object Storage. In source path, I have selected Inbox an…Priyesh P. Rane 11 views 3 comments 0 points Most recent by Priyesh P. Rane EPM Platform and Freeform
-
How do you "review the newly created schedules"?Summary:Looking for clarification on how to complete step 4 in this guide. This is related to the functionality being sunset in Data Management and being moved to EPM Pl…
-
Export business rules and pipeline using EPM AutomateSummary: Hi Oracle, We want to export business rules and pipelines using EPM Automation command or any other automation so we can automate the process Version (include t…
-
data management epm cloudSummary: FCCS data management section expiring date Content (please ensure you mask any confidential information): does anyone know the official date of when data manage…samuel valecchi 12 views 1 comment 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform
-
Sending Budget Data to Fusion Cloud in 'Add_Data' Mode via EPM Integration AgentHello everyone, We are working on transferring budget data from an Oracle database to the Budget Control module in Fusion Cloud using the EPM Integration Agent. Here's a…
-
Pull Dynamic Calc Member with DLRBackground: In FCCS, we currently have a level-0 member of the Account dimension (let's call it Account XYZ), which has a data storage type of "Dynamic Calc and Store". …
-
Exporting attribute values while exporting data into a file using DMSummary: While exporting data into a file from EPM application using data Integration, is it possible to export attribute values as well. For example, If we have Project…
-
Filter out amount less than 0.0001 in Data extract in FCCSWe need to filter out records that are between 0.0001 and -0.0001 while extracting data from FCCS application. We explored Skip row , however it is available in Data Int…
-
created the schedule but not able to see it under the worklist once I created itSummary: We are testing in a Test POD and a schedule was created but it is not in the Worklist Content (please ensure you mask any confidential information): Version (in… -
How to increase the attempts to fetch UCM document ID from Oracle Fusion ERP CloudSummary: We have ESS job in source Fusion and we running it from data management side. Sometimes job run long and not able fatch DocumentID. How to increase the attempts…
-
How to Set Up Integrations from Workday to Oracle EPM CloudSummary: We are trying to figure out how to set up an integration from Workday Financial Management to Oracle EPM Cloud. My only search result is to use Oracle Integrati…
-
Availability of Reference Tables in EPM PBCS for Scripting/MappingHello All, In On-Premise Oracle Hyperion Planning, we have / can access the following tables that can be referenced in scripts: Table --> Info HSP_TEXT_CELL_VALUE --> Ce…
-
Push EPM Cloud data to HFMSummary: We need to push planned data from EPM Cloud to HFM Content: What is the best approach to push data from EPBCS to HFM. The most ideal situation would be that we …
-
Is It Possible to Set Password Expiry to Never for a Specific PBCS Admin Account?Hi All, Could you please confirm if it’s possible to configure the password for a specific admin account in PBCS (Planning and Budgeting Cloud Service) so that it never …
-
DATA EXPORT OUTPUTFILE(I.E CSV) MOVE TO DM FLODERSummary: Hi All, We created one data export rule and we want the export output file i.e csv it is automatically move to one particular dm folder after completing the dat…
-
Upload file to data management inbox via rest API using power user accessSummary: We need to upload file into data management inbox using rest API. However the upload file is only applicable for administrators. any other commands available to…
-
File based to Freeform application which has no period dimensionHello, We have a freeform application which has no period dimension but year dimension exists. Year members are like Y01. We have a source file which contains data for m…
-
Is there a way to add muliple GL balances cubes with same name in data integrationWe have two different ERP prod instances for different business verticals. Both use the same CoA and have the same essbase name. Is there a way to integrate to both Essb…Srikanth_Grandhe 42 views 10 comments 0 points Most recent by Srikanth_Grandhe EPM Platform and Freeform
-
Load data from FCCS to FCCS - service administrator credentialsSummary: We are investigating the possibility to connect 2 FCCS with the aim to load data through task manager integration Content (please ensure you mask any confidenti…
-
Assist us in increasing the time limit in DM to ensure the integration runs successfullySummary: We are experiencing an issue with integration where we have seamless integration with Fusion where it is frequently timing out. The Integration rule it getting …
-
Drill through from EPM Agent to relational tablesSummary: Drill through from EPM Agent to relational tables with Text and other fields Content (please ensure you mask any confidential information): Assuming the EPM Int…