Data Integration
Discussion List
-
Open Batch - Processed file does not appear anymore in the process id's post completionSummary: We are using Open batch to execute certain data loads. Post the data load completion, the files (that are uploaded in open batch folder for data loads) were app…NarayananS 11 views 1 comment 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform -
Error Export data to budgetary Control FusionSummary: Hi, I have an error issue when exporting data from PBCS to Budgetary Control. Could you please help me to solved this issue? I have attached the full log as wel…Ruosidah 31 views 2 comments 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform
-
Email setup and subject setup for email notificationsSummary:We have a requirement where we need to setup an email inbox as a recipient of all emails from the ARCS cloud. We would also need help on setting the subject for …
-
Data Exchange Integration - Map one source coulumn to multipleSummary: I am loading data from HCM to Workforce: AS seen below, I want to map Assignment Start Date to OWP_Start Date (employee Start Date), OWP Start Month (Employee S…Ravinder Singh-63390 11 views 5 comments 0 points Most recent by Stu G-Oracle EPM Platform and Freeform
-
Data Management recalculate showing in POVWe are noticing a recalculate icon in Data Management production and test environments for Oct only. We have reloaded some prior periods and do not get the recalculate d…
-
Direct Data push from EPCM to GL creates records in GL for debit and creditSummary: Direct Data push from EPCM to GL creates records in GL for debit and credit. On what basis are these records created in GL? Need Logic was differentiate debit a…Subhojyoti Chakraborty 11 views 1 comment 0 points Most recent by SureshM-Oracle EPM Platform and Freeform
-
How to set up Explicit period mappings vs Default?Summary: Setting up alternate period mapping for specific DLR Content (please ensure you mask any confidential information): I have a requirement to load prior period re…
-
Open batch Archive filesSummary: Files Placed in Open Batch files are processed but does not land into Archive folders after processing. Content (required): Files Placed in Open Batch files are…
-
Oracle EPBCS Integration Option with Azure DatabricksSummary: General questions on available functionality between Oracle EPBCS Data Integration and Azure databricks Content (required): Specific questions regarding the fun…
-
Is it possible to build dimension named "Highest Education Degree" in WFP reporting cubeSummary: Is it possible to build dimension named "Highest Education Degree" in Workforce Planning reporting cube (for demographics) via Data Exchange. I am thinking of p…Ravinder Singh-63390 21 views 7 comments 0 points Most recent by Stu G-Oracle EPM Platform and Freeform
-
Data Load rule vs Quick Mode Data RuleSummary: Data Load rule vs Quick Mode Data Rule not behaving same in REST API executions Content (please ensure you mask any confidential information): We are using Quic…
-
Groovy CreateFileWriter bug/defect? File generated not located in Outbox.Summary: The Groovy documentation for CreateFileWriter method (https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/groov/oracle/epm/api/script…Chad Alexander 51 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Can we integrate EPBCS with Accounts Payable in a way that drill through would work from EPM to APSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Missing File When Using an Export Dimension by Name (EDMCS) Job Type in PipelineSummary: I am testing export Dimension by Name (EDMCS) Job Type in Pipeline. I created EDM connection: https://edmcs-test-domain.epm.****.oraclecloud.com/epm Parameter: … -
Customizing default integration with DFF (Flexfields) between EPM and PPMSummary: Is it possible to adjust "Import Project Actuals" (EPM side) to pick up 2 flexfields from PPM? Customer uses 2 flexfields into PPM (Oracle Project Management) t…HMMgl-Oracle 53 views 2 comments 1 point Most recent by Kyle Goodfriend-Oracle EPM Platform and Freeform
-
FDMEE artifact migration issues since 24.02 patchSummary: Since the 24.02 patch we are unable to import snapshots without errors for the FDMEE artifacts. The process we took was: Overview -> Remove application Import f… -
Importing data records surrounded by quoteHello. I'm trying to import data into FCC and the records, while comma delimited, are surrounded by quotes. They look like this: "Account,CostCenter,Amount" So the whole…ericerikson 21 views 4 comments 0 points Most recent by Kyle Goodfriend-Oracle EPM Platform and Freeform -
GL to EPCM inbound integration failing with Replace modeSummary: GL to EPCM inbound integration failing with Replace mode for Entity dimension members only. Error message says failing to clear data for Entity members which ar…Bala Vishwa Gautam 51 views 9 comments 0 points Most recent by Pratap Ball EPM Platform and Freeform
-
Can a pipeline validate metadata in FCCS?Summary: Can a pipeline validate metadata in FCCS? Content (please ensure you mask any confidential information): I'm building an automation using EPM pipeline to load m…Handel Zhuang 21 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Extract Data with the Full Qualified Name for All AccountsSummary: Content (please ensure you mask any confidential information): Hi All, We are extracting data using the data export feature in data integration and it is extrac…Ayeshan 31 views 3 comments 0 points Most recent by Kyle Goodfriend-Oracle EPM Platform and Freeform
-
Data Exchange - Clear Region broke after Jan-24 UpdateHi, Unable to select members from the hierarchy in the 'Clear Region' option in Data Exchange on all DLR's. Anyone else notice this? Our last successful run was Jan 19th…Hyperion_Junkie 61 views 8 comments 0 points Most recent by Hyperion_Junkie EPM Platform and Freeform
-
Pipeline Move from Outbox OR Download/Upload File OperationSummary: Pipeline as per 23.09 includes 'Move' from Inbox. Could we know about 'Move' from Outbox? OR Download/Upload File operation availability? Content (required): Pi…
-
Pipeline Start and End Period failing though REST API but successful when executed manually.Summary: Pipeline variables for start and end period work properly when executed manually but fail whenever the job is executed through a REST API call. Content: I've cr…
-
DLR Members Selected if no Source Filter GivenI have a DLR which is pulling data from an FCCS application to a TRCS application. The DLR has no Source Filter specified for the dimension Data Source. The structure of…annaschmult 51 views 1 comment 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform
-
How to view update details for report querySummary: How to view update details for report query Content (please ensure you mask any confidential information): The query for our Process Monitor Report was updated …Ryan DeFilippi 91 views 5 comments 1 point Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
Data Management file to FCCS - Power users unable to export the data.Hello, We have a group of people as Power Users in FCCS, even though their access to the dimension is fine, while trying to load the file data in Data Management (DM), t…yanni vossos 252 views 9 comments 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform -
Is it possible to generate .dat to .csv in DM?Summary: In data management, Is it possible to generate .csv instead of .dat ? Content (please ensure you mask any confidential information): Version (include the versio…Subhojyoti Chakraborty 41 views 4 comments 0 points Most recent by Kyle Goodfriend-Oracle EPM Platform and Freeform
-
Pipeline option to pull a file from third party serverSummary: Currently in data load Automation script, we have a third party server for maintaining the file (loading the file based integration) from e.g. like PeopleSoft. …
-
How to extract data file with date timestamp in data managementSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Subhojyoti Chakraborty 32 views 2 comments 0 points Most recent by Subhojyoti Chakraborty EPM Platform and Freeform
-
How to ignore Header and Footer rows in Flat Files for Data IntegrationHi team, Using the new UI of Data Integration. How do you ignore header and footer rows of a flat file? I know with multi-column load you can have it in the expression, …Peter Joelson 714 views 4 comments 0 points Most recent by Jeelan Banglewale-Oracle EPM Platform and Freeform