Data Integration
Discussion List
-
Batch to Pipeline conversionSummary: Batch to Pipeline conversion Content (required): In 23.06.60 as expected I am seeing Pipelines are introduced. Based on what I understood from earlier Oracle ev… -
Export of data with data management and suppression of zerosIn step 1 - when importing the data from FCC into Data Management, the zeros are suppressed. (by default) In step 2 - if the accumulation of rows in Data Management resu…Bjoern Schumacher 155 views 2 comments 0 points Most recent by User_KKXP6 Financial Consolidation and Close -
data exchange validation checkerSummary: In Data Management, under the mapping section, there is a VALIDATE button which checks your maps are using a valid target dimension member. Is there currently s…
-
Export mode Replace in Data Management does not zerolize YTD valuesSummary: Export mode Replace in Data Management does not zerolize YTD values when there is no line of data for a given POV Content (required): We noticed that exporting …MCV 191 views 8 comments 0 points Most recent by Shailesh Kumar -Oracle Financial Consolidation and Close
-
Is it possible to copy one scenario to another, including performing math on source data?Summary: Copying Scenario A to Scenario B, with Scenario B's data being scaled/rounded to thousands. Content (required): I have a DLR to load data to Scenario A. I would…SAW23321 71 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
GL Integration with Oracle Tax ReportingSummary: Can Oracle GL Integration be done with Oracle TRCS using Data Management. Also, can the GL data be pulled in real time or upon a refersh? Content (required): Ve…
-
FCCS_110 rule to load 0 in place of #missingSummary: Need to write a config consol rule to replace #missing values with 0 Content (required): DSO application. I'm running into a variant of the issue where an accou…SAW23321 341 views 20 comments 0 points Most recent by Maggie Reed-Oracle Financial Consolidation and Close
-
Has anyone tried an integration between Oracle Fixed Assets module to TRCS?Summary: Has anyone successfully done an integration (by Data Management) b/w Oracle FA to TRCS. I am trying to do it through a flat file by setting a connection as Data…
-
Limit Power User Access for LocationSummary: Content (required): Can you limit which locations a power user can load to in data management? We would like to limit them to one location, so they don't accide… -
No records exist when Batch job is executed in Data ManagementSummary: When data load rules are run in Data Management, it successfully loads transactions but when the Batch job which contains the same data load rules is run, the p…Paulene Lomeda-Oracle 62 views 4 comments 0 points Most recent by Paulene Lomeda-Oracle EPM Platform and Freeform
-
Default Export Mode in Data IntegrationSummary: In data management -> target application -> application options -> Default Export Mode. We put the value as Replace. Is there a way to do that in data integrati…Casey Kempel 61 views 9 comments 0 points Most recent by Jeremy Stubbs Financial Consolidation and Close
-
DM clone for Gen2 issues with Explicit Maps performance - running 600% or more longer then ProdSummary: I have been having issues in our DM production application with increased times in the Staging and Validation stages - we are preparing to go live in GEN2 - it …
-
Using DM Extract YTD data from EPBCS to load into Periods 3, 6 and 9Summary: Content (required): I have read how to pull YTD data from FCCS and was able to apply the same logic to pull YTD data from EPBCS and push the data into TRCS for …
-
Size of supporting attachments for JournalsSummary Size of supporting attachments for JournalsContent Hi All, Is there any actual or recommended limit with respect to size of supporting attachments for journals i…User_R8P92 57 views 3 comments 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
Attribute Columns getting loaded with only Start Position of 1 - not pointing to correct column #Summary: I am connecting to a Custom Oracle Fusion BI Report - I have everything linked correctly and all the UD fields are populating correctly, however; when I try to …
-
False error from Batch execution in Data ManagementSummary: False error from Batch execution in Data Management Content (required): We have been getting this false error message from Batch execution in DM "EPMAT-1:EPMFDM…
-
EPM Integration Agent - Export to FileSummary: Content (required): We need to create a process to export data from FCCS to a data file, using the EPM Agent. Is it possible? We set up the agent and he pings w…Timestamp EPM Team 32 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Data load from Data management to FCCSSummary: We have loaded data from Data management to FCC, every thing went smooth and exported successfully. but when we check in FCCS there is a discrepancy for what we…Naveen Kumar Vasa 81 views 6 comments 0 points Most recent by Shanthi Subramanian-Oracle Financial Consolidation and Close
-
FCCS with GL Ledger setsSummary: We are planning to use ledger sets in GL. Can FCCS work with GL ledger sets. Content (required): Version (include the version you are using, if applicable): Cod…PrasadCCC 31 views 1 comment 0 points Most recent by SureshM-Oracle Financial Consolidation and Close
-
Rejected Rows in Data ManagementSummary: In Data Management, the log file says rows rejected: 1 , but no information captured. [TC] - [Amount=NN] SourceSystem|EntityCode|Account Code|Account Descriptin…Naveen Kumar Vasa 111 views 2 comments 0 points Most recent by SureshM-Oracle Financial Consolidation and Close
-
Are there any known issues between EPM Integration Agent and EBS v9.2?We have been using the Integration Agent with EBS numerous times successfully, but running into a very puzzling problem. Our usual process is to connect directly to the … -
EPM Integration Agent initialize ErroeSummary Hi all, i'm trying to initialize EPM agent but i'm getting the below error as the screenshot, please note that i'm already installed JAVA, and set the JAVA home …Hussein Mahmoud 51 views 2 comments 0 points Most recent by Ankur Shrivastava EPM Platform and Freeform -
Batch in Data Management gives a false green check when the Load Rule has failedSummary: Batch in Data Management gives a false green check when the Load Rule has failed Content (required): Batch in Data Management gives a false green check when the…
-
Data Management/Data Integration Performance TuningSummary: A new section of the admin guide has been released that discusses performance tuning strategies for Data Management/Data Integration. This is a great place to s…Mike Casey-Oracle 181 views 1 comment 7 points Most recent by Ganesh Golla EPM Platform and Freeform -
Loading Consolidation Journals using Data Integration/Data ManagementSummary: We are looking into allowing users to load Consolidation Journals using Data Integration and found a few drawbacks: 1) Users will need to update the journal lab…Matt Maurer 81 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
EPCM - Currency Exchange rate loading TemplateSummary: Hi, When I try to download the template of currency exchange rate from the EPCM application, a blank csv file even without headers has been downloaded. Any idea…Anantha Krishnan 61 views 2 comments 0 points Most recent by Ganesh Golla Profitability and Cost Management
-
Use Case for the BegBalance member in Data ManagementSummary: When configuring DM, there is a default period mapping that is created called "BegBalance" that references the last period of the prior year of the first year i…Valerie Fisher-279201 63 views 1 comment 0 points Most recent by Patrick Northcraft Financial Consolidation and Close
-
How to import non-numeric & numeric data to multiple accountsSummary: I'm trying to import employee data through data management for NetSuite PBCS. Content (required): We have employee number, department, and subsidiary. The non-n…
-
Experience with booking TAR difference back to ERPContent Hi all, I would like to ask you to share your experiences around pushing EPM Tax Reporting book difference (in the TAR) back to any Oracle ERP system. It seems t…Xaviro Jokhoe-62628 51 views 1 comment 0 points Most recent by Ken Kramer-Oracle Tax Reporting (Direct Tax) -
Exchnage Rate Loading ...Summary FCCS Exchnage Rate Loading ... from ERP CloudContent Good People, We are looking to see if FCCS product can pull these rates (Exchange Rates) via the connector f…Soumya Prakash Parhi 96 views 4 comments 0 points Most recent by Soumya Prakash Parhi Financial Consolidation and Close