Data Integration
Discussion List
-
TRCS Forms Replacing Null with Zero ValuesSummary Replace Null values with 0 in TRCS FormsContent We have a number of Forms in TRCS where users enter adjustments. The editable cells in these forms initially cont… -
How to connect to FCCS using REST API ?Summary Requirement is to connect to FCCS data for post elimination with MS P-BIContent Hi There, I have an requirement to connect to the FCCS cubes to pull out financia… -
Unable to un-deploy the SDM template post renaming the Entity dimension nameSummary Unable to un-deploy the SDM template post renaming the Entity dimension nameContent Hi, I have renamed the Entity dimension name from JPPL to ENT_01. Post refres…Pradeep Kumar-230381 24 views 2 comments 0 points Most recent by Pradeep Kumar-230381 Tax Reporting (Direct Tax)
-
Back Tracing Automated Amount in System Account TRCS_DeductIncTaxReg on Current ProvisionSummary Creating new Tax App and amount in referenced account is not present in our current Production EnvironmentContent Looking for some direction on how to root cause…Brian Robinson 41 views 9 comments 0 points Most recent by Siva G.-Oracle Tax Reporting (Direct Tax)
-
How to use "Update Dimensions As a Job" REST API in PCMCSContent Hi Experts, Please can you explain when and under which scenarios can we use "Update Dimensions As a Job" REST API. REST Resource POST /epm/rest/{api_version}/fi…Parmit Choudhury-Deloitte 22 views 1 comment 0 points Most recent by User_2025-02-05-23-55-14-602 Profitability and Cost Management
-
PCMCS query generating blank fileSummary PCMCS query generating blank fileContent Hi Friends, I have created a query in PCMCS using global context to export data. However when I run the query, it shows … -
Retrieving Capital Allowance (CA) amounts in TRCS based on multiple CA rate categorizationSummary As per Singapore tax regulations, companies can claim the wear & tear allowances for the qualified fixed assets, based on different CA rates (33 1/3% over 3 year…Pradeep Kumar-230381 27 views 1 comment 0 points Most recent by Ken Kramer-Oracle Tax Reporting (Direct Tax)
-
File based load that works will start failing if database isn't refreshedContent Hi. Wanted to see if something is common behavior or not. Please comment if you're seeing or not seeing this behavior (or you know what's going on). In all cases…ericerikson 25 views 4 comments 0 points Most recent by ericerikson Financial Consolidation and Close -
Data migration from Prod to TestSummary Getting warning message 'Essbase data import is only supported during create application'.Content I am trying to copy data from Production to Test instance by ta…Hari Nagumalli - Oracle EPM-Oracle 110 views 3 comments 0 points Most recent by Vasantha Kumar Raman Financial Consolidation and Close -
Data Management - Download Source FileSummary Data Management - Download Source FileContent Hi All, there is a short problem in "Data Management" section. From Data Management (Workbech section) we are not a…Antonio Barbaro 38 views 3 comments 0 points Most recent by Antonio Barbaro Financial Consolidation and Close -
DM with FCCS: Too many objects match the primary key oracle.jbo.keyContent Hi all While trying to create 4 different cloud connections for the same user under Data management for FCCS, we have this error: Too many objects match the prim… -
Update Dimension Causing the PCMCS Instance to go down and unresponsiveContent Hi Everyone, Please can i request some one to share the best practices to update dimension into PCMCS. Currently, we are executing Rest API scripts to update dim…Parmit Choudhury-Deloitte 26 views 4 comments 1 point Most recent by Alecs Profitability and Cost Management
-
Data Management Export from FCCS - two columns of amountsSummary Output of values in two columns (Amount, Quantity) - Depending on the accountContent Does anyone have an idea how I can export the amounts to two different colum…Bjoern Schumacher 63 views 5 comments 0 points Most recent by Bjoern Schumacher Financial Consolidation and Close
-
Extracting data with Data Management - Two header lines requiredSummary data export file with two headlines requiredContent The system to be supplied with data from FCCS needs two header lines. The first header consists solely of 1;2…Bjoern Schumacher 45 views 2 comments 0 points Most recent by Bjoern Schumacher Financial Consolidation and Close
-
Substitution Variables in Data Exchange when Integrating with On-Premise EBS when utilizing EPM InteSummary Can a substitution variable be utilized in a Data Integration->Option->Filters for Ledger Name and Period when utilizing EPM Integration AgentContent We have con…User_2025-01-28-16-03-29-902 130 views 1 comment 0 points Most recent by Thejas Shetty-Oracle Financial Consolidation and Close -
Options for One to Many in FCCSSummary Options to Migrate One to ManyContent Hello all, have a client that performs a one to many allocation of gl balances. However, not sure what option to use. 1) Da…mhylton 28 views 1 comment 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close -
DM - Mapping file is empty for only one dimensionContent Hello, I am using data management to integrate data. Usually I export the mappings to Excel file, setting the mappings and then import the file. However, now whe…Carolina Silva 32 views 1 comment 0 points Most recent by James Liaskos Financial Consolidation and Close
-
DM - Mapping accounts according sum valueContent Hello, Does anyone know if it is possible, in Data Management, mapping members according the sum of the data? I need to create the following mapping: If the sum …Carolina Silva 46 views 7 comments 0 points Most recent by Jeffry Kadarusman Financial Consolidation and Close
-
Integration Agent with PCMCSSummary Can we use integration agent with PCMCSContent In Data Management, we have an option to choose Data Source -> On Premise Database very much like Planning but I d…User_3HEOY 26 views 3 comments 0 points Most recent by Mike Casey-Oracle Profitability and Cost Management