Reports
Discussion List
-
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 15 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 23 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 12 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 92 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 32 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 35 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 2 views 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 12 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 23 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…NK2025 255 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 42 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 -
PCMCS Query - Exporting data using epmautomate with "," as delimiterSummary: Exporting Data from PCMCS using epmautomate exportQueryResults Content (required): Hi, I am trying to export data from PCMCS using a query using epmautomate exp…Amit Agarwal-158816 61 views 7 comments 0 points Most recent by Amit Agarwal-158816 Profitability and Cost Management
-
Dimension Management in PCMCS through Smartview not availableSummary Dimension Management in PCMCS through Smartview not availableContent Hi All- We know we don't have the facility of dimension management in PCMCS through Smartvie…Amit Agarwal-158816 49 views 10 comments 2 points Most recent by NK2025 Profitability and Cost Management
-
Model Snapshot ReportSummary: Model Snapshot Report is not running in the Test environment Content (required): After the monthly update in the Test environment the Model snapshot report is n…Rajen Patil 51 views 5 comments 0 points Most recent by Omar Shubeilat. Profitability and Cost Management
-
Possibility to load in Reporting Cube in PCMSummary: We use PCM for allocating Cost. From a Reporting perspective, we have few details that are not involved in allocation, its mutually exclusive accounts, which we…Mary John-Oracle 41 views 4 comments 0 points Most recent by Mary John-Oracle Profitability and Cost Management
-
Excel Preview in HFRSummary: Hi Everyone, Can we get an excel preview of the reports in Web Reporting Studio (HFR) - PCMCS alongside PDF and Web preview ? Content (required): Version (inclu… -
PCMCS - Extract huge data set and emailHi All, We have a requirement to send out emails with huge volumes(1.3 million records) of data to business users for recon. Wanting your suggestions, as we used to send…Sucharitnarang 22 views 1 comment 0 points Most recent by Amith Kumar Madisetty Profitability and Cost Management
-
Rule definition (system) reportSummary: Where can I get the Rule definition (system) report, where the source-destination-driver members are listed? Content (required): Get a detailed report on the Ru…Rajen Patil 51 views 2 comments 0 points Most recent by Rajen Patil Profitability and Cost Management
-
Change Period/Scenario/Year in PCMCS QuerySummary: Need help on automatically changing the Period/Scenario/Year in PCMCS Query. Content (required): Hi Friends. We have a script to calculate markup which runs a q…Amit Agarwal-158816 41 views 7 comments 0 points Most recent by Amith Kumar Madisetty Profitability and Cost Management
-
HFR ReportingSummary: Hi All, In my report client need Level4,3,2,1 of the center dimension in 4 separate columns. But the problem is in the report the center level did not come as p…Mrinmoy Paul 11 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Profitability and Cost Management