Data Integration
Discussion List
-
Can we write TB validation rule (to ensure uploaded TB’s total is zero) in Data Management?Summary We are looking for a solution to add validation at Validation stage of TB loading processContent In existing setup system is considering availability of Data Loa…User_2025-02-06-06-07-43-641 46 views 2 comments 0 points Most recent by Kotak Pramit Financial Consolidation and Close -
Help with script in DMSummary Help with script in DMContent Hi All, is it possible to write a script in Data Management related to Location ID or Location Name? I tried to use PARTIONNKEY cod…Antonio Barbaro 58 views 6 comments 0 points Most recent by Antonio Barbaro Financial Consolidation and Close -
Loading Multi period figuresSummary Loading Multi period figuresContent Hi All, i need to implement an interface by using "Data Management" in FCCS in order to load figures of 12 months for a speci…Antonio Barbaro 26 views 3 comments 0 points Most recent by Thejas Shetty-Oracle Financial Consolidation and Close
-
FCCS - Handling Zero Balances when loading Closing Trial Balance through Data ManagementSummary Handling Zero Balances when loading Closing Trial Balance through Data ManagementContent We are currently loading the closing trial balance to 'Closing balance i…SKM 106 views 7 comments 1 point Most recent by User_2025-02-11-00-54-44-609 Financial Consolidation and Close -
Clear Data function in PCMCS systemSummary How to clear Specifi Period Data rather Entire Data in PCMCS systemContent HI Experts We have uploaded 11 months data in pcmcs now i found some issues in specifi…Karthikeyan 38 views 12 comments 0 points Most recent by Karthikeyan Profitability and Cost Management
-
Initialize error maps: Data managementSummary "Initialize error maps" in "Data file to Export" in Data ManagementContent Hi, In PCMCS im configuring "Data FIle to Export" Target application ["Data Management…Khushbu Premlani 89 views 1 comment 0 points Most recent by Thejas Shetty-Oracle Profitability and Cost Management -
loading metadata from ERP CloudSummary loading metadata from ERP Cloud to FCCS using Data ManagementContent Hi everyone! hope you all are doing great. I have the following question, is it possible to …User_2025-02-05-00-34-04-259 33 views 2 comments 0 points Most recent by User_2025-02-05-00-34-04-259 Financial Consolidation and Close
-
data load rule executionContent Hello All, I have a possible issue when an User uploads data on Data Management using Data Load Rule execution. I have a data file with this header structure: SC…Gianluca Natili 42 views 2 comments 0 points Most recent by Gianluca Natili Financial Consolidation and Close -
Data Export using Data Exchange in FCCS as a fileSummary Data Export using Data Exchange in FCCS as a fileContent Hi Friends, I am exporting data from FCCS in a file using Data Exchange Option. The file contains the da…Amit Agarwal-158816 57 views 3 comments 1 point Most recent by Amit Agarwal-158816 Financial Consolidation and Close -
FCC Data Management Complex Logic AccountContent I am trying to create a logic account in FCC Data Management Complex Logic Account to aggregate a series of accounts I.E. 1001,1002,1003 and if the sum of these … -
Deleted Dimension appearing in Data managementSummary Deleted Dimension causing problem in Data management and Data loadContent Hi, I have created a application in PCMCS, later I deleted a dimension and Added anothe…Khushbu Premlani 65 views 2 comments 0 points Most recent by Thejas Shetty-Oracle Profitability and Cost Management
-
Sending zero value to Closing balance input movementContent We noted recently that when zero value is sent to closing balance input movement (YTD_Input view) from Data Management (using 'Replace' when exporting), the syst…
-
Bank Balance Data to be available to a userSummary Bank Balance Data to be available to a userContent Hi Friends, I have a requirement to share Bank Balance data from FCCS to a user who doesn't have access to the…Amit Agarwal-158816 31 views 2 comments 1 point Most recent by Amit Agarwal-158816 Financial Consolidation and Close
-
FCCS Data management Replace mode creates opening balance offsetContent We use data management to load data in FCC. We load Life to date Balances. We use YTD input, Closing Balance input for ( B/S accounts) and Mvmts Net income for P…User_2025-02-11-00-54-44-609 81 views 2 comments 1 point Most recent by User_2025-02-11-00-54-44-609 Financial Consolidation and Close
-
Extracting large amounts of base data from FCCSSummary Requesting best method for extracting large amount of base level data from FCCSContent What is the best method of extracting large amounts of base data from FCCS…MKLC 63 views 3 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Loading YTD Revenue/Expense Values to Closing Balance Input MovementSummary Loading YTD Revenue/Expense Values to Closing Balance Input MovementContent When uploading Revenue/Expense Values to FCCS_ClosingBalance_Input Movement through D…
-
Enable Drill Region Gives ErrorSummary Enable Drill Region Gives ErrorContent Hey Everyone, Trying to enable Drill Region for FCCS Application in Data Management. I keep getting error. Has anyone face… -
FCCS - Blocking Data Loading for Future PeriodsSummary FCCS - Blocking Data Loading for Future PeriodsContent We are looking for a way to block trial balance loading through Data Management for future periods. Should…
-
Can we load YTD data into TRCS via Data management?Summary YTD data load into TRCSContent HI Team, It is understood from the data management guide that- "The View dimension is not exposed in the Data Management user inte…
-
Cannot extract data from Dynamic Calc members?Summary Trying to extract data from Dynamic Calc members but cannotContent Hi, I am trying to extract data for six lines in the Account dimension which are Dynamic Calc.… -
Extract journal data with the identification of the journal label using Data ManagementSummary Extract journal data with the identification of the journal label using Data ManagementContent Hello, Does anyone know if it is possible, with Data Management, e…Carolina Silva 35 views 6 comments 0 points Most recent by Klaus Andersen Financial Consolidation and Close
-
How best do I create a Proforma scenario in FCCS?Summary A client wishes to have an "adjusted" Actual scenario that adds historical data from acquisitionsContent Since we would be entering new data into the past, this …JoachimB 39 views 3 comments 0 points Most recent by User_2025-02-05-23-45-21-053 Financial Consolidation and Close -
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)