Reports
Discussion List
-
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…Gary Yip - D. 2 views 0 comments 0 points Started by Gary Yip - D. Profitability and Cost Management -
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 …Hans Villanueva Rojas 19 views 5 comments 0 points Most recent by Hans Villanueva Rojas Profitability and Cost Management
-
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…Hans Villanueva Rojas 12 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Best practice for using PCM_REP vs PCM_CLC for reportingHello, We are working with Oracle EPM – Profitability and Cost Management and would like to validate the recommended best practices regarding the use of the Calculation …Hans Villanueva Rojas 32 views 2 comments 0 points Most recent by Hans Villanueva Rojas Profitability and Cost Management
-
Dynamic Numbering in ReportsHi all, I want to build a P&L Report in PCM for which I want to supress rows with missing values or 0 as a value. I also want to adjust the numbering of the rows, so the…
-
Convert member formula to Groovy scriptHi All, I have multiple Dynamic currencies in ASO cube of EPBCS and they have member formulas. I am planning to convert this member formulas to Groovy and store. I am fa…Sukrut 21 views 1 comment 0 points Most recent by Vijay Mahantesh-Oracle Profitability and Cost Management
-
Model Documentation Report accessIs there a way that users can access the Model Documentation Report WITHOUT the ability to Edit Allocation Rules? So previously I had a thread where users had full acces…Peter Joelson 21 views 2 comments 0 points Most recent by NarayananS Profitability and Cost Management
-
Replace/Remove the Slash Symbol (/) in Folder Names - upcoming considerationSummary: Replace/Remove the Slash Symbol (/) in Folder Names - can someone confirm if this relates only to folders created in the application (like in Data forms, Report…
-
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
-
unable to open financial report in PCMCSwhile opening the report getting the below error in PCMCS Error executing query: Error: Internal Essbase JAPI error: [Cannot perform cube view operation. Essbase Error(1…MaheshBabu 33 views 1 comment 0 points Most recent by Harish Kumar C Profitability and Cost Management
-
Suppress column in MR report for EPCMSummary: I am trying to suppress columns with missing or zero data in the MR report. I have enabled suppression for both zero values and "No data" at the column level as…
-
Error in Rule Balancing reportSummary: Rule Balancing report throwing an error Content (please ensure you mask any confidential information): While running the Rule Balancing Report following error i…
-
Calculation Statistics: Cells updated says 0 but does not show up in "X Rules produced zero cells"Hi All, We have a model that has 117 total rules. When we run the "Calculation Statistics Report" in Calculation Analysis, I can see that 104 rules had 0 for "Cells Upda…Peter Joelson 21 views 4 comments 0 points Most recent by Peter Joelson Profitability and Cost Management
-
Custom role to access "Goods Received Not Invoiced" standard fusion reportHi Team, We are trying to provide access to user to "Goods Received Not Invoiced" standard report using a custom role. What are the privileges required to give access to…Ramneet Kaur 21 views 4 comments 0 points Most recent by Ramneet Kaur Profitability and Cost Management
-
Exportfolder location in Oracle Reporting Web Studio through PCMThe oracle application used is PCM and when scheduling a batch run through oracle reporting web studio, there is an option for the results to be saved in an external dir…
-
Program Documentation Report isn't showing source, destination, and driver basisSummary: When I run the Program Documentation Report, I used to see the Source, Destination, and Driver Basis columns populated for each rule in the report. Now when I r…Jean-Luc Mosley-154935 91 views 6 comments 0 points Most recent by BhavaniGajula Profitability and Cost Management
-
PCMCS SystemSummary: Found the Issue when execute the system report and did not find any context or target for any dimension data Content (please ensure you mask any confidential in…AKKHAPON KUMSARANEE 31 views 1 comment 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
Is there a report available to export out of EPCM to get driver data for all rules?Summary: We are needing to get a report of all rules and the driver that is being used in those rules. Currently we export the Model Documentation and create formulas to…Crystal Eide 31 views 7 comments 1 point Most recent by Crystal Eide Profitability and Cost Management -
SQL query or Table for Cost Accounting DistributionsHi Team, Need a table which stores the information of Cost Accounting Distributions. Required columns: Run control, preprocessor, Cost prcocessor, Status, Cost organizat…
-
How to Query Contract Terms Template ClausesHi Everyone, I need to extract all data on Contract Terms Templates page, and don´t know how to join the Terms Template Table with Clauses and Contracts too. as I've fou…
-
StevenRigby 1 view 2 comments 0 points Most recent by Raavi Divya sri-Oracle Profitability and Cost Management
-
How to pull in Rule Alias in Export DataSummary: We are exporting our EPCM data through 'Export Data' (Navigator - Overview - Export Data) and would to like export the Rule Alias, not just the rule name. Conte…Marmitchell 31 views 3 comments 0 points Most recent by Omar Shubeilat. Profitability and Cost Management -
Is there a way to display the Description of a rule in Model Documentation Report?Summary: I would like my Model documentation report to display the description under the rule name on the rule page. Is that possible?Michael C Stefanavage 11 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management -
EPCMCS Dashboard_Link_ReportHi All, Is there is any option available in Dashboard to link the report???? For example when user open a dashboard and within same page there is option available to att…
-
System Report in EPCMSummary: Need information on how to create the System report in Enterprise PCM Content (required): I am trying to create a System report (Rule Details) in the EPCM envir…Rajen Patil 61 views 3 comments 0 points Most recent by Bhavani Gajula Profitability and Cost Management
-
Can anyone suggest an alternative to PCM Queries in EPCM to extract data in a specific Adhoc formatSummary: Can anyone suggest an alternative to PCM Queries in EPCM to extract data in a specific Adhoc format. We have a requirement to extract nearly 40,000 lines of dat…Vikasitha 21 views 3 comments 0 points Most recent by Gebril Abdellatif -Oracle Profitability and Cost Management
-
How to move data from PCM_CLC to PCM_REP cubeSummary: Content (required): Hi all As per documentation, we have just migrated from Standard PCM to EPCM and we wanted to take advantage of the REP cube. However, I can…NKW 272 views 12 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management -
NEW Reports module open on a different Smartview workbook instead of under a new Excel TabSummary: Content (required): Hi All It seems that the new REPORTS module opens reports on a separate WorkSheet every time we open new Fully formatted reports. We want th…
-
Adding unique Sequence number and system date in EPCM ReportsSummary: We are building a journal entry (WebADI) report for one of the transfer pricing flows using EPCM. Report contains two columns with GL/posting date and transacti…Anantha Krishnan 41 views 1 comment 0 points Most recent by Anantha Krishnan Profitability and Cost Management
-
PCMCS Export data using query not showing AliasesSummary: PCMCS Export data using query not showing Aliases Content (required): Hi, I am trying to export data using query from PCMCS. Even though I select Use Aliases, t…Amit Agarwal-158816 31 views 5 comments 0 points Most recent by Philip Hulsebosch Profitability and Cost Management