Data Integration
Discussion List
-
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… -
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 2 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…Luigi M 13 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle 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 28 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 6 views 1 comment 0 points Most recent by Timestamp EPM Team 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 12 views 1 comment 0 points Most recent by Lakshmi V-Oracle Payables, Payments & Cash Management
-
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 14 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 71 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle 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…
-
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…
-
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 31 views 4 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…
-
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 43 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 440 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 258 views 10 comments 2 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Print Substitution Variable Value in Pipeline Integration EmailSummary: Hi I am using the substitution variables Consolidation_Period and Consolidation_Year for data loads and its picking the values perfectly, the only issue is that…Shimona Gupta 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCC Pipeline Job Type Import Mapping – RTP for NAMEHi all, The ability to copy pipelines definitely made our work easier. Over time, however, we realized that configuring a specific setting was quite tedious. We need mul…Andreas Otto 31 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Is performance affected by using multidimension mapping for all dimensions in EPM Data Management?Summary: Hello Oracle Experts, We are loading data from a source file with 4 columns (like Account, Entity, Cost Center, Department, Location). In our Data Management se…Vijay_Babu 21 views 2 comments 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Oracle FCC Data Management – Invalid Intersection CustomizingHello all, We are looking for a meaningful solution to provide our data integration users with an Intersection Validation Report - comparable to what we had in FDMEE. We…Andreas Otto 41 views 2 comments 3 points Most recent by user11033576 Financial Consolidation and Close
-
FDM Invalid Intersection report in Oracle FCC data managementHi All, We are having invalid intersection reports in FDM, would like to know how to implement the same in Oracle FCC data management. Also like to know how to invalidat…Prem Siva Kumar Reddy Rami Reddy 237 views 10 comments 2 points Most recent by Jeelan Banglewale-Oracle Financial Consolidation and Close
-
How to schedule Automated Data import from Oracle Fusion to FCCSSummary: We import data from Oracle Fusion to FCCS every month, and we do this manually by executing a job from Data Management for each location separately. However, we…wojciech.furmanek 41 views 7 comments 0 points Most recent by Sinan_Koybasi Financial Consolidation and Close -
How can I leverage groovy to execute the Data Integration in FCCSSummary: I am trying to use groovy to run an integration using groovy in FCCS. I was able to do the same easily in EPBCS. Same is not working in FCCS. Appreciate thought…Srinivas Bobbala 31 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
NewLoadYTDClosingBalanceInput not working as expected with prior period movementsSummary: For a customer we are encountering issues with balance sheet accounts in combination with the NewLoadYTDClosingBalanceInput substitution variable (YTD Reversal …Tjeerd Huisman 81 views 3 comments 0 points Most recent by Camille Dhallenne Financial Consolidation and Close -
SAP source system is not able to maintain connectivity with Oracle EPM FCCS due to TLS version diff.The SAP source system is using TLS 1.2 and Oracle EPM Cloud application support 1.3 ( as per the Oracle docs ) due to which the SAP team is not able to setup the connect…
-
FCCS | Data Exchange - No acess to folders in file browserSummary: When we access Data Exchange > Actions > File Browser, we can´t see any folders, even though they were created. At the same menu but in Data Management, we can …Timestamp EPM Team 74 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS Data Load Strategy Entity wise vs Region wise DLRs Best PracticeHello Oracle Experts, We are currently working on the data integration design for an Oracle FCCS implementation and are seeking guidance on the best approach for structu…Vijay_Babu 11 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Can we reconcile system transactions without using bank statement lines?Summary: Can we reconcile system transactions without using bank statement lines? Content (please ensure you mask any confidential information): Version (include the ver…Varalakshmi N 12 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
IPM Insight- How to start with testing for IPM Insight. Do we need to have different cube for IPM.Summary: Can anyone define the process for testing IPM Insight in FCCS. Content (please ensure you mask any confidential information): Version (include the version you a…SJ00793615 57 views 4 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
Map Member in Data IntegrationI can't access dimension data when map membee in data integration because "Unable To Retrieve Members. Either The Target Is Unreachable Or You Do Not Have Permissions" I…