Data Integration
Discussion List
-
Calling Data Management REST API through scheduling PBC Groovy RuleSummary: We've built an Integration between ERP and PBC. We want to execute this integration every two hours for only a few days during a month. We want to automate this…Jeroen Goudvis 171 views 14 comments 0 points Most recent by Tim Good SC&H EPM Platform and Freeform -
Data Management - block data importSummary: Block data import Content (required): When importing data through data load rule, is there any way that Data Management block data import in FCCS because data i…Timestamp EPM Team 21 views 1 comment 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Input via webform - System does not allow to feed value for one of the periodSummary: I was trying to feed % values to a member via webform and I was able to edit and submit the data for all months except January. When the period was selected as …Anantha Krishnan 51 views 6 comments 0 points Most recent by Anantha Krishnan Profitability and Cost Management
-
ExportQueryResults: Slow run time using Member FiltersSummary: Hello Gurus, We are using "Export Query Results" through EPM Automate and noticed unusual behavior in our testing. 1) When we used below query to Export All App…Venkat Peatla 11 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Data Management replaced by Data IntegrationSummary: Hi All, This is regarding Oracle's new feature Data Management will be replaced by Data Integration, How many of you think it is valid thing oracle is providing…Ramsha Ansari 121 views 6 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Data Load Rule Convert character from source to numberSummary: Hello, I need to load data from an external source where one field contains a single character, ie, A, B etc. I need to convert this to a number in the target a…
-
Duplicate Mappings while using Data Management in FCCSSummary Unable to delete/identify duplicate mappingsContent Hi, I am using the same FCCS application as both a source and a target and have set it up in Data Management …User_2025-01-29-22-31-29-149 75 views 3 comments 0 points Most recent by KimK Financial Consolidation and Close -
How to Re-name Data Integration in PlanningSummary: We need to re-name Data Integrations in Planning? How can we do it? Content (required): We need to re-name Data Integrations in Planning? How can we do it? Re-n… -
Loading Text to Planning App - Considerations?Are there any best practices or considerations around loading text to an EPM app (Planning in this case)? I have ~6,000 bottom level members in the Entity dimension, and…
-
Sample groovy script to export aggregated FCC dataSummary: Sample groovy script to export aggregated FCC data Content (required): I am trying to write a groovy script to export aggregated data from FCC for an interface …
-
Data Load Rule still iming out after increasing Batch TimeoutSummary: Content (required): We have a data load rule that is consistently timing out within 5-6 minutes. We increased the Batch Timeout to 60 minutes but the data load …Paulene Lomeda-Oracle 134 views 5 comments 0 points Most recent by Thejas Shetty-Oracle EPM Platform and Freeform
-
Integrating PCMCS to ERP Intercompany ModuleSummary Integrating Transfer Pricing Extract from PCMCS to ERP Intercompany ModuleContent Hi, We are implementing transfer pricing process in PCMCS and we want to integr…User_2025-01-30-00-01-49-367 89 views 8 comments 0 points Most recent by Thejas Shetty-Oracle Profitability and Cost Management
-
How to merge columns in Import FormatSummary: Hello, I am doing a metadata build of the Employee dimension with source from an MSSQL table with multiple fields. The query I defined in Data Exchange pulls 3 …
-
Automated emails with IGNORE file - Data ManagementSummary: Hi My requirement is to email the Data Management IGNORE file (during data load) and rejects file. Can these two files be automated to send emails to admins / s…Sucharitnarang 31 views 1 comment 0 points Most recent by Amith Kumar Madisetty Profitability and Cost Management
-
Dimension Management in PCMCS through Smartview not availableSummary Dimension Management in PCMCS through Smartview not availableContent Hi All- We know we don't have the facility of dimension management in PCMCS through Smartvie…Amit Agarwal-158816 48 views 10 comments 2 points Most recent by NKW Profitability and Cost Management -
FCCS: DSO with PBCS Data for AccountContent Hi all We have a doubt about data import from Planning to FCCS. What happens when account from Planning is set to Dense and we have a new application FCCS where …NKW 76 views 24 comments 2 points Most recent by Shailesh Kumar -Oracle Financial Consolidation and Close -
Data Management - IGNORE like mapping being treated as a memberWe have a bunch of Multi Dimensional mappings for the Account dimension. We want to IGNORE any member that was not part of the previous mappings. When we do a * to IGNOR…Peter Joelson 1K views 8 comments 0 points Most recent by Jonathan A Cohen EPM Platform and Freeform
-
Exporting of attributes along with level 0 dataSummary: We have a ASO plan type from which we want to export level 0 data but at the same time we also want to extract attribute associated with the sparse dimension le… -
Calculate entity on the various members of the Consolidation dimensionSummary: Content (required): Hi, In the project where I am currently, in the entity dimension there is the following hierarchy: The requirements are: Ent1, Ent1_Y, Ent2,…Carolina Silva 31 views 2 comments 0 points Most recent by Carolina Silva Financial Consolidation and Close
-
Rama Rao PallapuSummary: Data loading to multiple versions in PCMCS from EPBCS Content (required): Client requires to load the daat in to two version in PCMCS from EPBCS through one dat…Raama Rao-Oracle 22 views 1 comment 0 points Most recent by Omar Shubeilat. Profitability and Cost Management
-
Possibility to load in Reporting Cube in PCMSummary: We use PCM for allocating Cost. From a Reporting perspective, we have few details that are not involved in allocation, its mutually exclusive accounts, which we…Mary John-Oracle 41 views 4 comments 0 points Most recent by Mary John-Oracle Profitability and Cost Management
-
Error while extracting data from EPBCS to PCMCSSummary: Error while extracting data from EPBCS Financials to PCMCS Content (required): Hi All, I'm trying to extract data from EPBCS Financials to PCMCS, while extracti…
-
Data Management and zero loadingSummary: I thought that when loading data via data management the defualt behavior was that zero balance lines were NOT loaded to FCC Content (required): I am reviewing …Nancy Ackerman 812 views 10 comments 0 points Most recent by JimmyMcFly Financial Consolidation and Close
-
Is it possible to use OAuth 2 in pod-to-pod integrations?Hello, I am wondering if it is possible to use OAuth 2 when setting up pod-to-pod integrations in Data Management? Documentation only shows the ability to setup basic us…Christopher Jolie 51 views 2 comments 1 point Most recent by Mike Casey-Oracle EPM Platform and Freeform -
Calendar Change to Fiscal Year - Impact on data management YTD loads?Hi all, We received a request to change the Fiscal Year from November start to January, as we load data "YTD_Input" via data management to "FCCS Closing Balance Input", …yanni vossos 41 views 1 comment 0 points Most recent by Vani-Oracle Financial Consolidation and Close -
Meta Data IntegrationSummary: Hi All, Can we connect our EPM PCMCS application with DRM for metadata integration? if not what are the other work around available for seamless integration wit…
-
Data Management Import step is taking longer than expected timeSummary: Hello Gurus, Looking for some help in troubleshooting an issue in Data Management Import step to extract the data from PCMCS. We have an Existing PCMCS applicat…Venkat Peatla 52 views 2 comments 0 points Most recent by Aman Kothari-191377 Profitability and Cost Management
-
No Input rule/optionSummary: client is moving from HFM to FCC and currently "locks" data by adding the completed year to a No Input rule - is this available in FCC? Content (required): Is t…Nancy Ackerman 131 views 10 comments 0 points Most recent by David Corredera at DTT Financial Consolidation and Close