Data Integration
Discussion List
-
Process Monitor Report Customized as per Client Requirement from Data ManagementSummary: Process Monitor Report Customized as per Client Requirement from Data Management: Business Requirement : User have 2 categories Actual_JD and Actual_AM where so… -
Planning data exchange power user with Administrator role cannot run integrationSummary: Content (please ensure you mask any confidential information): Hi all We have applied to the Power user the new Integration role of Administrator so we can run … -
Linking Source Documents in Cell text – Transferring and Using Document URLs from Source SystemsSummary: We’re currently exploring a scenario where, in addition to transferring numerical data from our source systems, we also transfer hyperlinks pointing to the unde…Bjoern Schumacher 11 views 1 comment 0 points Most recent by Bjoern Schumacher EPM Platform and Freeform
-
How to export data from TPROCESSLOG table data managementIm trying to create a process with sql qurey on maintenances tables (Like TPROCESSLOG, TPARTITION and others) to export data to a file . This is to get process details h…
-
How Does Data Integration Order Columns for Load?Summary: How does Data Integration order the columns for load? Content (please ensure you mask any confidential information): We are integrating some data from an on pre…
-
Creating Integration in EPM to extract data to FDISummary: We are trying to following this Doc: https://docs.oracle.com/en-us/iaas/analytics-for-applications/doc/managing-data-connections.html#FAWAG-GUID-A3EDE603-BF95-4…Sera Hager 41 views 1 comment 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform
-
Can we reconcile system transactions without using bank statement lines?Summary: Can we reconcile system transactions without using bank statement lines? Content (please ensure you mask any confidential information): Version (include the ver…Varalakshmi N 11 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
IPM Insight- How to start with testing for IPM Insight. Do we need to have different cube for IPM.Summary: Can anyone define the process for testing IPM Insight in FCCS. Content (please ensure you mask any confidential information): Version (include the version you a…SJ00793615 62 views 4 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
Map Member in Data IntegrationI can't access dimension data when map membee in data integration because "Unable To Retrieve Members. Either The Target Is Unreachable Or You Do Not Have Permissions" I…
-
How to update time zone on email sent by no.reply@epm.oraclecloud.comwe have built pipelines which sends email on completion, but the emails it sends is showing different time(GMT) though we changed user preference for service account tha…
-
EPM Integration Agent: Connection Timed outHi Everyone, We are currently facing an issue at the client side with the EPM integration Agent. When attempting to connect to the cloud we are getting the "connection t…
-
Is there any EPMautomate command to update period mappings in FCCS?Summary: Clients wants to update the period key under period mapping for one of the target application on everyday basis. They also want it to be automate. How can we do…Harshith J Rao 32 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Is there a way to create the reports folder under the outbox folder in the Data management EPM FCCS?I have mistakenly deleted the reports folder in the outbox folder in the Oracle EPM FCCS data management. I was trying to delete the reports generated in the reports fol…RatnaMaruboina 41 views 6 comments 0 points Most recent by Vinay Gupta-Oracle Financial Consolidation and Close
-
How to lock a POV for several periods in Data ManagementSummary: Content (please ensure you mask any confidential information): Hi all In Data Management for EPM there is a option to LOCK a POV for a specific period, but I do…
-
EPM Platform Job Job Type for Planning Jobs to run integrationsHi, We have a requirement, where we need to run the integration/Data Load Rule present in EPBCS from FCC using Pipeline. Could you please me know if there is a way we ca…Prem Siva Kumar Reddy Rami Reddy 11 views 2 comments 0 points Most recent by Prem Siva Kumar Reddy Rami Reddy Financial Consolidation and Close
-
How to load data in No currency member in CbCR?Hello We have a requirement to load CbCR Constituent Entity Information data into the application using Data Exchange. We have already created the Data Load Rule (DLR), …Priyansh SURYAWANSHI-Oracle 11 views 1 comment 0 points Most recent by Sanjana Soni Tax Reporting (Direct Tax)
-
How to integrate secondary ledger of of Oracle ERP to FCCSSummary: There is a requirement in our project to integrate secondary ledger of Oracle ERP in FCCS. Is it possible to have a direct connection like Oracle primary ledger…Pooja Jain 31 views 1 comment 0 points Most recent by Preston Oakes Financial Consolidation and Close
-
Can we hold SO if customer is having past overdue invoices?Summary: While creating the sales order need to put hold if customer having any past due invoices Content (please ensure you mask any confidential information): Version …Varalakshmi N 41 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
"ODMC" (oracle demand management cloud) to EPM integration feasibilitySummary: We are trying to integrate from "ODMC" (oracle demand management cloud) to EPM. But we are not seeing direct integration feasibility let us know any feasibility… -
OAuth POST method not workingWe are doing App to App integration in EPM. We are using OAuth 2.0 Client Credentials for Authentication. We have created Confidential APP and are able to get access tok…
-
Data is getting loaded partiallyWhen loading data to freeform BSO cube through file based integration, partial data is getting loaded. For one our dimension, example member name is LVMH TEST and in the…
-
Data Integration-Global Periods error for RuntimeError: The Current Process Status '' is InvalidUsing a groovy rule to trigger a dataload rule that exports data to file. Rule prompts for scenario, version, entity. Start/End Year on Scenario drives periods to cycle …
-
FCCS Import Data with member not allowedHi all, i'm trying to copy an application and i need to copy data, so i'm using import functionality. The import job is failing due to not allowed members (all reporting…MS. 21 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Failing Drill-through from GL on pod 1 to pod 2Summary: Hello, I'm having an issue with the drill-through. Although I was able to successfully implement a drill-through from the GL to pod 1, my new drill-through is f…Zut Alors 21 views 3 comments 0 points Most recent by Shanthi Subramanian-Oracle EPM Platform and Freeform
-
Integration> Load from FCCS to TAX fail due to COMMA in the Account nameSummary: Content (please ensure you mask any confidential information): Hi all Could someone please let me know how to go about this limitation: In Planning it is possib…
-
How to pull the data of a specific date from Oracle GL Average Daily Balance cube?Summary: Client wants to pull data of a specific date from Oracle GL ADB cube. They do not want to pull the data from last day of the month. For example, Today they want…Harshith J Rao 101 views 1 comment 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close
-
FCCS - File based FX rates load through Data Management best practice.Hi Team, We have recently set up the DataManagement process to load FX rates file to FCC. The steps we followed 1.Created FCC Rates target application 2.In target applic…
-
Pipeline email: is it possible to print the value of the substitution variable?Summary: The March 2025 update added pipeline variable definitions to the email notifications generated from pipelines (see Oracle Fusion Cloud Sales Planning March 2025…
-
In EPCMCS, data is not getting pushed to REP cube using Data ManagementI'm pushing data from the Oracle Planning Cloud to the EPCMCS Reporting cube using "Data Management", I'm getting the below error, my metadata is Refreshed, and there is…Kumari Soni Umesh 392 views 11 comments 0 points Most recent by NKW Profitability and Cost Management
-
Is it possible to decrypt a PGP encrypted file available in EPBCS data exchange inbox?Summary: We are getting PGP encrypted employee data file from Workday. It is placed in SFTP folder. We plan on using the OIC to load that encrypted file to EPBCS inbox f…Ravinder Singh-63390 1 view 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform