Data Integration
Discussion List
-
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 17 views 2 comments 0 points Most recent by Ramya Kalaparthi Financial Consolidation and Close -
When zero is loaded to a Historical Amount Override account, the zero is not recognizedWhen zero amount is loaded to a Historical Amount Override account, the zero is not recognized in FCCS in Parent Currency after consolidation runs. Instead, the Parent C…Jacalyn Munyon 14 views 4 comments 0 points Most recent by Jacalyn Munyon Financial Consolidation and Close
-
FCCS YTD Data Extract from FCCS to a file using Data Integration produces file with only headersI am trying to pull YTD data from FCCS into a file using Data Integration. I see rows in workbench with correct periodic numbers but the data file that gets generated on…Karthiga Devi Ramanathan 32 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Drill Through Error - EPMFDM-140138:No valid scenario could be found for the passed category:nullSummary: Getting error message as "EPMFDM-140138:No valid scenario could be found for the passed category:null" Content (please ensure you mask any confidential informat…PratikYadav 21 views 6 comments 0 points Most recent by Riyaz Shaik-Oracle Financial Consolidation and Close -
NewLoadYTDClosingBalanceInput not working as expected.Summary: The documentation says "When this substitution variable is set to True, Financial Consolidation and Close reverses the YTD closing balance from the prior period…Zenithz 92 views 3 comments 1 point Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close -
Extracting Data from FCCS for YTD without Data ExchangeSummary: Hi, Currently, users use HFM Extract data load option to extract data from HFM. However, they want to have similar option in FCCS but they do not have access to…Sudha V 22 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Pipeline feature using EPM commandSummary: Pipeline feature triggering EPM command and EPM automate command triggering pipeline Content (required): Is there any EPM Automate command to trigger pipeline? …Ramsha Ansari 747 views 13 comments 3 points Most recent by DJ Banga Financial Consolidation and Close
-
Task Manager connection to Oracle ERP fusionSummary: Task Manager Integration to Oracle ERP fusion Content (please ensure you mask any confidential information): Hello, I am trying to integrate FCC Task Manager wi…Rashmi Subash 61 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can we load .xlsx file format in FCCS data management?We want to load .xlsx file format into data management? Is there any work around available apart from converting the format externally using macro into .xls or .txt form…Utkarsh Choudhary 12 views 1 comment 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
Hi, what is the approach used for regression testing for Oracle PrimaveraSummary: what's the period Oracle expects the customer to complete the regression testing Content (please ensure you mask any confidential information): Version (include…User_6Q25H 12 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Inconsistent behavior of data load in FCCHello, We came across strange issue as mentioned below: Using Data Exchange, file based load was done for one of the entity and it is visible in Workbench. But same is n…
-
Issues in Drill thru in Forex and ERP cloudSummary: I am experiencing problems with drilling through forex data. I am utilizing an ERP adapter to extract forex data from the ERP cloud. We have deployed the BI rep…
-
All Data Extract from FCCSSummary: We want to extract all the data from FCCS to a csv file and are facing challenges. Content (please ensure you mask any confidential information): Hi Experts, Ou…
-
Is there any way to get behind the system user "frs_epm_prod" to see the actual userSummary: We use a number of data load rules (DLRs) that combine several steps to make the data load process as easy as possible for the users. When these rules are run w…Erringc 22 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Different job types in Pipeline - how to set variables?I have created a Pipeline with different job types. I have Integration job types on first stage card and Business Rules on second one. On runtime variable I have start p…soile.alm 63 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Seeking REST API Endpoint for detailed Failure Information on FCCS Data Load Rule ExecutionSummary: When executing the FCCS Data Load Rule via REST API, we are unable to retrieve the exact failure message from the Error Log file. The response JSON from the DLR…dkr_epm1 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Change Consol Operator for FCCS_Total Liabilities/Equity and ExpenseSummary Change Consol Operator for FCCS_Total Liabilities/Equity and ExpenseContent Have anyone have tried to change the Consol opeartor for FCCS_Total Liabilities, FCCS…
-
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…Jessican 81 views 21 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
EPM Integration Agent Query data from JDEThe EPM Integration Agent was built and the data was queried from JDE. Our requirement is to TRIM and concatenate the data using a CASE expression. Are there any suggest…Dharanidharan M 73 views 13 comments 0 points Most recent by NarayananS Financial Consolidation and Close
-
DM: Data load is taking over 1h to load data when it used to take 30 secondsSummary: Content (please ensure you mask any confidential information): Hi all We have an issue where data load from EPM Data Management is taking over 2 hour to load wh…Nkehli 92 views 32 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Error log Limit 1000 linesSummary: EPM has a limit of error lines for importing data into data management which is 1000 lines. We suggest this limit be parameterizable since in many cases informa…David Mata 21 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Integration execution failed, Outline load finished with errors.Hi, I am trying to import data using data integration. Once I have run the integration. I am getting this error in log "Outline load finished with errors" Here is the lo…Noah01010101 69 views 10 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close
-
Request for list of ERP service user 'roles / Privileges' for Direct integrations to FCCSSummary: Hi, Can anyone suggest what the Oracle suggested roles to be assign while creating a Service user in ERP, which we use for ERP to FCCS direct integrations. I ca…Anand Rasa 35 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS integration with Microsoft dynamicsSummary: Customer is looking for an option to do direct integration with MSD ( Microsoft dynamics ) - can we utilise integration agent? Content (please ensure you mask a…Alok P DAMAC 51 views 5 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Data export of same combination to two different targets drops export for second targetWe are trying to export data for a combination to two different target members. It exports data for the first Target member but does not export for seconds Target member.
-
Enable Default Movement Setup FCCSummary: Enable Default Movement in FCC. Currently we manually set up our movements in FCC when new accounts are created. To avoid manual process, we would like FCC to p…Sanjana Soni 315 views 38 comments 0 points Most recent by Sanjana Soni Financial Consolidation and Close -
@ILvl0Descendants() function extracting Dynamic calc memberWe have DLR to extract numbers from FCC. We have defined @ILvl0Descendants("[Custom1].[Total Custom1]") for Custom1 dimension in source filter and expecting level 0 memb…
-
EPM Agent Seeded QuerySummary: From Planning I set up a app with the "EBS GL Balance" app and can execute the Preseeded Query against the agent, I see the query string it in the log. How do I…
-
FX rates pull from ERP to FCCS - Dimensions mapping questionSummary: I have this request from my client to Pull FX rates from ERP to FCCS application. and am following this document: am stuck at Dimension Mapping (step #9 in the …Kemp2-Oracle 11 views 1 comment 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
Correct amount is not being retrieved in Data IntegrationHello, In Financial Consolidation and Close, when I ran Data Exchange>Data Integration. The correct amount is not being retrieved. I have attached my mapping and the scr…Noah01010101 71 views 12 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close