Data Integration
Discussion List
-
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 19 views 4 comments 0 points Most recent by Jacalyn Munyon Financial Consolidation and Close -
Is it possible to drill through on-prem PeopleSoft General Ledger using URL from FCCS?Summary: Is it possible to drill through PeopleSoft General Ledger using URL from FCCS? Eevnthough we are pulling PeopleSoft table data to FCCS using EPMagent. Our requi…
-
FX rates extracted from ERP is not loading to FCCS rates cubeSummary: Hi all, I am facing two issues when using the standard ERP to EPM adapter - Oracle ERP(Exchange Rates), to bring FX Rates directly from ERP to FCCS, and wonderi…Sarita Menon 109 views 15 comments 0 points Most recent by Dhanasekaran Kasimani-Oracle 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 30 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 52 views 3 comments 1 point Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close -
Data Import failed for already mapped entitiesKindly advice about this behavior in Data load rule. "E1845" is Parent Entity with 200 level zero shared entities under it. E1845 E1845-00 E1 .. E100 E1845-01 E101 … E20…Mangesh K 29 views 2 comments 0 points Most recent by Ashutosh Bhatikar-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 25 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 688 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 57 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS DM access provision and controlSummary: Hi Folks, We are looking for details how to segregate roles in FCCS Data Management. We would like to provision user with Drill through option to connect to Ora…
-
Users Unable to see the existing file and folders (flat file) in Data exchangeSummary: Hi , Power users having access all the entity, he trying to upload the file in Data Exchange card. but he can upload the file but file is not visible and he can…Nagarajan Mouttouvelou 186 views 9 comments 0 points Most recent by Sandeep Hardikar N S 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 20 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 11 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…
-
Unable to retrieve Average exchange rate from Fusion GL to FCCS using direct integrationSummary: The integrated exchange rate import process in FCCS brings only Closing rate, while trying to retrieve closing rate & average rate from Fusion GL to FCCS Conten…Dhanasekaran Kasimani-Oracle 62 views 7 comments 0 points Most recent by Kemp2-Oracle Financial Consolidation and Close
-
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 24 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 65 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 83 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 71 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 91 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 27 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 50 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 53 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.