To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Profitability and Cost Management
Discussion List
-
Migrate Data Exchange artifacts from lower environments to Production?Summary: Migrate data exchange integrations between environments. Content (please ensure you mask any confidential information): I have tried to migrate import formats a… -
Potential Destination Count is exceeding the Upper Limit when importing backupWe needed to restore from artifact snapshot and received error: "Potential Destination Count 15,789,151,498,680,180,990,720 is exceeding the Upper Limit 15,000,000,000,0…
-
Data load Rule Error Cannot perform cube view operation. Essbase Error 1030742 Invalid cell offsetHello All, While Executing Data load rule it is giving an error Cannot perform cube view operation. Essbase Error(1030742): Invalid cell offset [0]. Before Apr-26 patch …
-
The Groovy script failed to compile with internal error: Compile Error: [Static type checking]Summary: Since the recent groovy validation update I get this error → The Groovy script failed to compile with internal error: Compile Error:[Static type checking] - Can… -
EXPORT MODE as "REPLACE" when sending data from EPCM to Oracle GLHello everyone! We built a data load rule to send the EPCM allocated data to Oracle GL. We normally use "Merge" in the EXPORT MODE. What is the use case for using "Repla…
-
I can not update Period mapping in PCMCS.When I click on the Data exchange / Setup / Period mapping in PCMCS I get a blank page. -
data exchange applicationSummary: We are unable to open the Application from Data Exchange in the test environment. The page does not load as expected. This issue is not observed in the producti…
-
Pipeline Scheduled Job Not Sending Email Notifications in PCMCSSummary: Hi Team, We are facing an issue in Oracle Profitability and Cost Management Cloud Service (PCMCS) where scheduled Pipeline jobs are not sending email notificati…
-
Time out setting in Data ExchangeHi team! We have a situation that it was timed-out in Data Exchange but the report job is still running in Oracle GL. The data load rule runs a out-of-box report in Orac…
-
HPCM Management Ledger on premise (version 11.2.18) to EPCM MigrationSummary: We are about to migrate HPCM Management Ledger to EPCM . Experts, Please can you share the steps to be followed for this migration from HPCM Management Ledger (…
-
How to use attribute dimensions in data integrationsSummary: Hi All, My source cube is aso, and I am looking to use attribute dimension to filter on data. I tried adding a new dimension in the application but that dint se…
-
ERP Cloud Configuration → PCM Integration from the PCM EnvironmentHello, I am currently working directly within the Oracle Enterprise Profitability and Cost Management Cloud environment and would like guidance regarding the configurati…
-
Oracle EPCM sustainability for 1.5M Patients Along with 10x Visits per Patients per yearSummary: Oracle EPCM sustainability for 1.5M Patients & Approx 10x Visits per Patients. Can we get the profitability at Patient Encounter level using Oracle EPCM solutio…
-
Cannot Perform Custom Calc. Essbase Error(1042017): Network error:Summary: Hello All, I am getting this error Cannot Perform Custom Calc. Essbase Error(1042017): Network error: Timed out before receiving all data using Custom rule. No …
-
Custom rule taking longer time not completingSummary: The PCM custom rule is not completing. I also tried using NONEMPTYTUPLE I want to apply multiple project % drivers with the PR000000 project value. Any idea hin…
-
Quick Data Copy in Aso by GroovySummary: In PCM, I have 30,000 Src,100 Bu,1000 Client and 5000 Accounts and will be copying data from one grid to another. In Groovy code I am using 3 List to read row(S…
-
EPCM filter to exclude a UDAOur product hierarchy contains UDAs like this: Member Name UDA P0001 25kg P0002 300g P0003 300g P0004 25kg P0005 950g We wish to exclude 25kg members in the target dimen…
-
Artifactsnapshot Size increasedHi All, My artifact snapshot size increased to 500 GB in planning application, is there any action i should be taking
-
Amount allocated in earlier rule getting allocated againSummary: This may seem surprising, but the amount for a source intersection that has been completely allocated out is available. The Offset set is set to 'default.' What…
-
How to add a substitution variable with mass edit to allocation rulesSummary: I use the same allocation rules for actual and planning (2 different models), but planning allocation shall still be based on actuals hence I want to change the…
-
PCM is calculating allocation for two excluded membersSummary: Source filter not excluding all cost centers. Content (please ensure you mask any confidential information): I am using a parent level source and excluding cert…
-
Combining Debit and Credit columns into Amount - Data ExchangeSummary: Hi All - I am integrating with the Account Analysis report from ERP and need to take Debit - Credit in data exchange since they are in separate columns in the r…
-
Is there a way to make a custom cube in EPCM be available for POV actions like copy POVSummary: I have a 3rd custom cube in EPCM besides PCM_REP and PCM_CLC. I was intending to copy data into the custom cube for historical reporting. I understand export/im…
-
what are the MDX functions supported in EPCM and how to use them in custom calcsSummary: Content (please ensure you mask any confidential information): Hi all Can someone please point to the the list MDX functions supported in EPCM latest versions a… -
Display alias in traceability reportHi everyone! I setup the data form and display the Alias for the row and Column dimension. But when I use that data form in Traceability report, it shows member name onl…
-
Average cost Calculation via Custom calculationSummary: Hi All, We need to calculate a rolling 6-month average cost per unit based on monthly data. For the current period (June), the calculation should consider Janua…
-
Rule Data Validation report running for all rules at onceHi team! We know it has Rule Data Validation report running for each rule to check the Source and Driver based for individual rule. Can we know if it can run for all rul…
-
Managing Filters for Source DimensionSummary: Is there a way to pick all zero level descendants of parent member I want to exclude from my entity dimension source. So If my top level entity is All Entities …
-
How to publish calculated data from PCM_CLC to PCM_REP for reporting purposes?Hello, We are currently working with Oracle EPM – Profitability and Cost Management and would like to gain a better understanding of how the PCM_REP cube is intended to …
-
Best practice for defining formulas in Profitability (Account members vs pre-calculated KPIs)Hello, In Oracle EPM – Profitability and Cost Management, we currently use formulas defined in the Account dimension, since many of our reports directly consume these me…