Data Integration
Discussion List
-
EPM Integration Agent connection with JDE on IBM DB2Summary: I'm trying to configure the Integration Agent to pull data from an IBM DB2 Table on-premises into FCC (Data Exchange). I couldn't find any relevant documentatio…Claudio Caceres M. 42 views 6 comments 0 points Most recent by Claudio Caceres M. EPM Platform and Freeform -
Pipeline moved on before job finshed and sets pipeline to failed (even though no error)Summary: Our pipeline emails are showing as failed if a job is still running when it ends. It is also moving onto the next job rather than waiting for the job to finish.… -
How to Pull Incremental Metadata from Fusion to PBCS via Data ManagementHello Team, We are working on integrating metadata (Account, Entity, Custom) from Oracle Fusion to a PBCS application using Data Management in Oracle Cloud. Our goal is … -
Data Integration with conditional factoring of the data/amount columnContent: We load multiple accounts worth of data, value-based and score-based. Both accounts come from the same csv-file and have the same formatted amounts, however sco…
-
How to integrate oData with EPM Integration Agent using REST call.Issue SAP REST API response will be in JSON format. Data Management can only import delimited files and not JSON files. Requirement Load JSON file to Data Management usi…
-
Clear Region feature to clear ERP Cloud scenario runs in errorDear community, Oracle Development, We would like to use the Clear Region feature in Data Exchange to clear a specific Accounting Scenario (LE9+3) in ERP Cloud, before w… -
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 62 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 94 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 …
-
How to pass POV as parameters in URL from EPM as drill through to FDISummary: Hi, We want to drill through to FDI using direct drill option from EPBCS and pass the FORM POV selection as parameters in the URL used in direct Drill. Users re…