Data Integration
Discussion List
-
Can Process Details from Data Exchange be Exported to excel?I’m trying to extract data to identify when the first trial balance for each location was loaded. The information is available in Process Details, but I’m unable to expo…Rekha S 41 views 6 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close -
Loading of entire Trail Balance to Closing Balance InputSummary: Hi All, Customer does not want to load zeros, in case no data is present for Balance Sheet specifically for January to have the reversed Movement as its increas…Mary John-Oracle 56 views 8 comments 0 points Most recent by JameyBoozer Financial Consolidation and Close
-
Where is Account Type stored for DM?Summary: We had an issue (still open SR under investigation) with a journal load from DM. When the journal rule was run, the end result was an OOB journal in FCCS. An As…Alyssa Longo 42 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Downloading Validation errors report and restricting loading invalid intersections dataAt present in workbench there is no option to download Validation errors data. So is there any workaround to download this data? At present data in invalid intersections…Amara Sai Sandeep 59 views 13 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
Invalid Intersection in DM - Output FileSummary: Hi, When data is loaded on an invalid intersection in DM, it marks the process as failed on Export step and creates an output file of the invalid rows. In this …Alyssa Longo 32 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Derive Pipeline ParametersHi Community, We use Pipelines to optimize our processes. To make the process more secure, I am looking for a way to derive certain Pipeline variables from others during…Andreas Otto 24 views 3 comments 0 points Most recent by Andreas Otto Financial Consolidation and Close -
Option to configure dont map to a particular target account code.In Data Management or Data Exchange is it possible to define negative mapping "Not to map to a particular target coa code" For eg For Target Custom 1 mapping I DONOT wan…Amara Sai Sandeep 12 views 0 comments 0 points Started by Amara Sai Sandeep Financial Consolidation and Close
-
Source Period Not Available in FDMEE - Custom ApplicationSummary: Hi All, I created a custom application (Load_to_Oracle) in order to produce a txt file to load in a specific target system. In the custom Application I added th…Antonio Barbaro 11 views 2 comments 0 points Most recent by Antonio Barbaro Financial Consolidation and Close -
Input Currency Journal Adjustment Load Via Data ManagementSummary: Can Input Currency Journal Adjustment be loaded in FCC Via Data Management/FDMEE Content (please ensure you mask any confidential information) Can Input Currenc…
-
FileName Variable in Run Time PromptsI have an integration rule in the data exchange for importing a data file, and associated with it, I have a business rule (Groovy) set to run on the "Before Import" even…Timestamp EPM Team 3 views 2 comments 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
Import Format "Factor" expression working twice for Admin Users for FCCS.Hi All, We have an import format , where the source amount is getting divided by 1000 (Factor = 0.001) and then getting loaded into FCCS. Ex. Source amount =12345678 , T…Twink-Oracle 1 view 2 comments 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
FCCS data export issue on mappingSummary: Export to essbase contains the source member however mapping and workbench contains target member which causing the issue on member not found and failing the DL…
-
Simple Tutorial: Import Text based Consolidation Journals via Data IntegrationSummary: Please find attached a simple step by step tutorial to import text-based Consolidation Journals using Data Integration and Data Management. Tutorial is used to …Ashutosh Bhatikar-Oracle 31 views 3 comments 2 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS ConnectorsHi Team, We are in a journey of integrating Oracle FCCS to Workiva, We have some Oracle seeded connector in Workiva which can pull Data,Metadata,Mapping & Snapshot. Woul…Ramya Kalaparthi 84 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Moving from HFM to FCCS CloudWe have 5 yrs of Historical Data in HFM that we want to Archive. What are my options? Reason for not moving these in FCCS as I am told that the recociliation becomes a c…
-
INFO [AIF]: EPMFDM-140274:Message - Import Mappings: Current DimensionsHi Experts - We are getting this DM error when we try to import mappings from OIC→EDM→FCCS. We have not changed any file format till now but still getting this error. Ca…
-
Rounding FDMEE - Issue decimal FormatSummary: Rounding FDMEE - Issue decimal Format Content (please ensure you mask any confidential information): Hi All, in my FCCS application I noticed an issue in export…Antonio Barbaro 21 views 4 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
Create Drill regionClient is trying to drill back to workbench via SmartView. We have enabled Create Drill Region in our integration options and loaded the data. I am able to drill back to…
-
Guidance Required for Setting Up OAuth2.0 Connection Between FCC and OIC with Different IDCS DomainsHello Oracle Community, As part of our current project, we are working on establishing an OAuth 2.0 connection between Oracle Integration Cloud (OIC) and Oracle Financia…
-
For filebased data load is happening in FCCS Data load rule, will only rejected records be skipped?Summary: When running a data load rule to load records in FCCS from file, there are records rejected due to invalid intersections, will none of the records be loaded or …Arvind Moorthy-250185 23 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to load FCCS YTD actual load to EPBCSSummary: We are trying to pull the YTD value for FCCS_Minority Interest to push to EPBCS, however, per checking it is still pulling the Periodic value. Does anyone encou…User_ZCB13 35 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
calculate amount column in data load mappingSummary: Requirement is to calculate the amount dimension as * to 1/Amount in FCCS data load integration. Kindly help me in sharing knowledge on the efficient way to han…PrinceKumar 22 views 3 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
SmartView give errors: Drill through not being availableSummary: The issue appears to be mostly around parent accounts, but I have seen child accounts get the same error as well. when i am trying to do the drill through form …User_8OIEK 22 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Uploaded FBDI Template for PO receipts creation with serial number and PalletDFF?Summary: Uploaded FBDI Template for PO receipts creation with serial number and PalletDFF, upload was success, no error logs were received, but the records was not showi…Anil Mattapally 11 views 1 comment 0 points Most recent by Lakshmi V-Oracle Payables, Payments & Cash Management
-
Default Movements Enabled - FCCS_Retained Earnings child accounts creating out of balanceSummary: Balance Sheet out of balance is system generated by children input accounts under FCCS_Retained Earnings in new year. The Default Movements rule is enabled and …TAMMY_L 82 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Multi Period Data LoadingNeed to know whether multi period (multi column) data loading (12 separate columns for each month) available in FCCS when loading flat files.
-
Is there a way to load adjustments from Oracle ERP to FCCS in different data source members of FCCS?Is there a way to load Period 13, Period 14 and Period 15 adjustments from Oracle ERP to FCCS in different data source members of FCCS? Basically I am looking to load p1…
-
Automated Task for Pipeline execution in FCCS NOT WORKINGHello, I am trying to schedule pipeline automated tasks using task manager in order to schedule the integrations using holiday rules. Even after the start data and start…Ashif 47 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
IGNORE Mappings in SQLSummary Error exporting to FCCS when mapping to IGNORE utilizing SQL scriptingContent Was hoping someone could help with this. I setup Data Load Mapping using SQL script…user3948450 460 views 6 comments 0 points Most recent by Jennifer Lin Financial Consolidation and Close
-
FCC multi cubeSummary: FCC multi cube was trailed at KScope 24 as 'coming soon' but we can't see it on the road map now - what is the current status? Content (please ensure you mask a…Ben Walwyn 275 views 10 comments 2 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close