Data Integration
Discussion List
-
EPCM - Data Import and Export with a period range using EPM AutomateHi All, In Enterprise Profitability and Cost Management, I can load source balances for a range of periods in one go by specifying a start and end period in the UI using…Anantha Krishnan 18 views 2 comments 0 points Most recent by NarayananS Profitability and Cost Management -
Performance issue with Writeback in Snowflake table using EPM Integration AgentHello, I am trying to load some data in Snowflake table using EPM Integration agent. It is crossing default batch timeout of 30 minutes to load just 5k rows and integrat…
-
DLR needed to use Qualified Member Name for one EPBCS cube but not another?Hey all, We hit the following error when we ran a direct data integration from EPBCS to EPCM (running the integration from the EPCM environment): "Cannot perform cube vi…Peter Joelson 6 views 0 comments 0 points Started by Peter Joelson Profitability and Cost Management
-
Set up integration with Fusion GL with custom cube in EPCMSummary: We are trying to fetch data from Oracle Fusion GL and want to set up integration with Oracle Enterprise Profitability & Cost Management. Can we have this inform…NikhilDeshpande 14 views 2 comments 0 points Most recent by NikhilDeshpande Profitability and Cost Management -
using substitution variable in source filter of EPM cloud outbound integration not workingSummary: I have an integration. EPCM as source and EPBCS as target and used Current Year substitution variable as a source filter. It is not working as expected. if I pa…Srinivas Bobbala 11 views 1 comment 0 points Most recent by Venu-Oracle Profitability and Cost Management -
Data exchange export job is not saving target file to outbox folder if specified with /Summary: Data exchange job that exports data to data target is not saving file to outbox/ folder. It works with backward slash though. It was working fine with outbox/ u…Itali Madhusmita 151 views 19 comments 0 points Most recent by NarayananS Profitability and Cost Management
-
Send Allocated Journals from Enterprise Profitability to Financial Accounting HubSummary: Hello Experts, I'm having a need to send the allocated journals from EPCM to FAH. Content (please ensure you mask any confidential information): Hello Experts, …NikhilDeshpande 21 views 2 comments 0 points Most recent by NikhilDeshpande Profitability and Cost Management
-
Sending data from EPCM to FAHHi everyone! We have a requirement that we need to send the allocated data from EPCM to Oracle FAH. Does Data Exchange/Data Integration have the option to connect to FAH…GaryYip-Asc 26 views 5 comments 0 points Most recent by GaryYip-Asc Profitability and Cost Management
-
Executing IPM Insights in EPCM - EPMAutomate/Groovy/RESTSummary: Automation and scheduling IPM Insights in EPCM using either EPM Automate, Groovy or REST API Content (please ensure you mask any confidential information): I am…Andy Das 83 views 7 comments 1 point Most recent by Don Bean-Oracle Profitability and Cost Management -
PTD data from Fusion into PCMCS in YTD by Data ManagementSummary Loading of Periodic data from Fusion into PCMCS in YTD by Data ManagementContent Hi, In order to perform monthly costing cycle, I want to load periodic data from…Khushbu Premlani 44 views 8 comments 0 points Most recent by NarayananS Profitability and Cost Management -
Post the allocated result to next period to Oracle GLSummary: Hello everyone! It is about EPCM. But it is mainly about Data Integration/Data Exchange in Oracle EPM application. We have a situation: Data pulled from Oracle …GaryYip-Asc 23 views 4 comments 0 points Most recent by GaryYip-Asc Profitability and Cost Management
-
How can a POV or Period be locked in EPCM to block data update of any kind (Submit Data or DM)Summary: Publishing a POV (from Calcualtion Control) seems to only block any calculations being run, but data upload is still being allowed. We need to lock a POV once i…Itali Madhusmita 11 views 6 comments 0 points Most recent by Itali Madhusmita Profitability and Cost Management
-
Member selection does not display members in Integration rule -> Option -> FiltersSummary: Hi everyone, I encounter the following issue regularly in EPCM as well as in Planning. Sometimes the following solves the issue: 1. going to the application doi…Mueller 28 views 2 comments 0 points Most recent by Harish Kumar C Profitability and Cost Management
-
In EPCMCS, data is not getting pushed to REP cube using Data ManagementI'm pushing data from the Oracle Planning Cloud to the EPCMCS Reporting cube using "Data Management", I'm getting the below error, my metadata is Refreshed, and there is…Kumari Soni Umesh 360 views 11 comments 0 points Most recent by NK2025 Profitability and Cost Management
-
HCM Integration with Oracle EPCMCSWe have been trying to load Headcount data to EPCMCS by Integrating with Oracle HCM. There is no documentation available to load data to EPCMCS from HCM. I would like to…P Avinash 21 views 2 comments 0 points Most recent by Jeelan Banglewale-Oracle Profitability and Cost Management
-
Cannot create integration to get data from FCCSHello everyone, I am trying to create an integration to get data from FCCS to PCMCS. However, when I clicked on Save button for step "Map Dimensions", it showed the erro… -
Unable to use Rule dimension in EPCM to populate Journal Line Description in Integration with ERPSummary: We are sending data from EPCM to ERP as a single journal using Data Integration. The requirement is for the user to be able to see in ERP which allocation rule …
-
Does 'Calculate Model' pipeline job create POV if it's not created?Summary: Just wanted to know if I pass new POV (which is not created in the application) will it throw an error or will it create new POV automatically in the applicatio… -
Need to delete pipelines or scheduled jobs via script post PCMCS snapshot import in DR instanceIn our PCMCS application, we have an automation that performs a daily snapshot refresh from Production to our DR environment. This includes importing the application sna…
-
Unable to exclude members based on conditional search from a source filter in EPCM Data ManagementWe are trying to pull only certain cost centers which starts with either "PK*" or "Z0*" etc. but cannot put an Essbase function @MATCH to solve our purpose. However, as …
-
Is it possible to use User Defined Attribute (UDA) in Data Management for PCMCS?Summary Is it possible to use User Defined Attribute (UDA) in Data Management for PCMCS?Content Hello experts, I want to build a a DLR in Data management to export data …Parmit Choudhury-Deloitte 226 views 8 comments 0 points Most recent by User_511P1 Profitability and Cost Management
-
Authentication error when importing data into Profitability and Cost Management from EPM Planning.Hello!!! I have an integration to import data into a Cost and Profitability environment from an EPM Planning environment. Initially, the integration worked correctly, bu…User_F8Z0S 21 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Unable to set decimal precision for Data integration and EPCMSSummary: Content (please ensure you mask any confidential information): Hi all When exporting Data using data management with EPCMS I am not able to set the data decimal… -
REST API to execute Multiple POVs does not return all Child jobsSummary: REST API to execute Multiple POVs does not return all Child jobs Content (please ensure you mask any confidential information): When executing calculation for M…NarayananS 121 views 12 comments 0 points Most recent by Ryan Fell Profitability and Cost Management
-
Rounding Issue in PCMCSWe are facing an issue in rounding decimal places in a file that we are extracting from Data Mangement Interface of PCMCS. In custom calculation rules, the decimal place…Kavita Ganesan 121 views 6 comments 0 points Most recent by NarayananS Profitability and Cost Management
-
EPCMCS Pipeline FunctionalitySummary: Pipeline functionality has been released. Can you run PCM Models using this capability? Content (required): In more complex environments with a significant rule…Adam Spiller 324 views 11 comments 1 point Most recent by NarayananS Profitability and Cost Management
-
multi column-all data type export through Data ExchangeSummary: Hi Experts, We have a requirement to export smartlist and 2 data values of DataSource dimension from ePCM into a file. We chose to use Data Management for this …Sahitya Guruju Veena 93 views 1 comment 0 points Most recent by NarayananS Profitability and Cost Management
-
PCM Essbase data load on member with Chinese charSummary: Our application has products with chinese characters in the member name (not alias), so when we are trying to load data to the PCM_CLC cube its throwing error s…HarryEPMUser 11 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Loading allocation results to ERP GL CloudSummary: Loading allocation results to ERP GL Cloud Content (please ensure you mask any confidential information) We have a need to load the results of our EPCMCS alloca…SAW23321 21 views 2 comments 0 points Most recent by Pat McCarty-Oracle Profitability and Cost Management
-
Does integration between PCM_CLC and PCM_RPT timeout more often because of enormous data size?Could the timeout issue in the integration between PCM_CLC and PCM_RPT be caused by the large dataset stored in PCM_CLC, which is slowing down the query performance? Cur…Supanut Sinphatsirikul 31 views 3 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management