Reports
Discussion List
-
Importing MR reports from Narrative Reporting to PlanningContent I am trying to explore the new functionality rolled out in Planning where Management Report (MR) comes as standard. We have a good amount of MR reports that were… -
Export Excel new Report ModuleContent Hello, How can I export reports to excel in the new reporting module? Thanks, Michael -
Simple Math on a Pivot TableSummary I need some help with some math that I might be overcomplicating.Content I have created a pivot table that groups employees into temporary, seasonal and regular … -
21B Project Performance is picking up the wrong data as compared to Manage Committed Cost and ManageSummary 21B Project Performance page is picking up the wrong data as compared to Manage Committed Cost and Manage Project Cost Page?Content Hi Experts, Please for your a… -
Reporting Error with Worker.AssignmentNumber fieldSummary OTBI error being generated when user attempts to access report - specifically states user does not have access to Worker.AssignmentNumber fieldContent Hi all, We… -
OTBI Issue - Costing - Receipt Accounting Real TimeSummary OTBI Receipt Accounting -- Concatenated SegmentsContent Hi All, Appreciate your inputs or suggestions on the below issue. OTBI Report having timeout issue Subjec…Swapnil Kashid 83 views 4 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Field in form - how to find the corresponding attribute and tableContent Hi experts :) I have been working in many different ERP systems. Oracle Cloud is new to me. In some ERP systems it is possible in a form to access information ab…NajaBM 67 views 2 comments 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
How to stop dashboard auto runSummary How to stop dashboard auto runContent Hi Team, Greetings of the day!!. Dashboard is getting auto run even the parameter was not passed in oracle fusion. Is there…Vasanthakumar Ravi 249 views 4 comments 0 points Most recent by Seiichiro Yasui Reporting and Analytics for HCM -
Report as reference doclet: grid per individual member (pov) in doclet?Content Narrative reporting: When using a management report (one grid, several cost centers) as a reference doclet, you are asked to set the POV when inserting the repor… -
Generate Data in Query with ThresholdSummary Generate Data in Query with ThresholdContent Hi - Is there a way we can generate Data through PCMCS Query with a threshold, say I would like to have only the Cos…Amit Agarwal-158816 43 views 3 comments 2 points Most recent by User_2025-02-05-23-55-14-602 Profitability and Cost Management -
How to identify position of Nth occurance of a character or string similar to INSTR functionalitySummary Objective is to display one of the segment values from People Group Flexfied Structure in OTBI ReportContent I have requirement to show a segment value from Peop… -
OTBI > Ability to get the work schedule assigned to Employee in reportContent Hello All, I will appreciate your support in the following issue: Do you have an idea if possible to get the work schedule assigned to employee in OTBI or via SQ… -
Unwanted grouping of data in OTBI AnalysisSummary OTBI analysis giving multiple data against employee instead of one rowContent I have created an analysis with a custom column to interpret employee's adoption of…User_2025-02-11-13-38-56-242 39 views 5 comments 0 points Most recent by User_2025-02-11-13-38-56-242 Reporting and Analytics for HCM -
Detail vs Summary flagContent I have a report that prompts the user for a beginning and ending check date. Is there a way to add a flag to an OTBI parameter that when selected, the report wil…Annette M 29 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is it possible to have conditional Display of report parameters on the basis of value in other paramSummary Is it possible to have conditional Display of report parameters on the basis of value in other parameter ?Content Hi Experts, Is it possible to have conditional …Abhishek Sood HCM 191 views 6 comments 1 point Most recent by Abhishek Sood HCM Reporting and Analytics for HCM -
EPBCS, EPM Cloud Planning Custom Expense DriversSummary I have created custom expense drivers, which relies on 2 different accounts. However when using the driver based expenses tab, every time I click save I 'm getti… -
BI Pub folder/object security reportContent Hello, Are the catalog folder/object level permissions stored in a DB table? Can we report on what users/roles have been applied to folders/items to secure them?…JBlain 25 views 1 comment 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
What is Talent Rating Subject areaContent Hi Team, We have the talent rating where we have, Performance rating, Risk of loss etc. Is there any possibility to get the from OTBI? I know, We can get through…User_2025-02-11-13-25-48-351 28 views 2 comments 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM -
Curiosity Question_Excel BI Templates NamingContent Good morning! I wanted to reach out to see if anyone has run into the error below when trying to preview data in an Excel template. I am running Excel M365 and a…User_2025-02-10-17-54-21-557 16 views 0 comments 0 points Most recent by User_2025-02-10-17-54-21-557 Reporting and Analytics for ERP -
Query to return employees related to a particular Representative type for a given AoR and scope of rSummary Query to return employees related to a particular Representative type for a given AoR and scope of responsibilityContent Hi All, Please share Query to return emp… -
HCM Cloud - OSHA ReportsSummary Looking for documentation (HCM Cloud) on 300, 300a and 301Content I cannot find any configuration documentation related to these reports. Can someone please dire…David Zajac 45 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Accounts Receivables Month end closing in Cloud 20 ASummary Accounts Receivables Month end closing in Cloud 20 AContent We want to close AR month end closing in Cloud 20A. I developed a query from AR tables withe invoice …Rama Pedamallu-193980 64 views 4 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP -
BI publisher SQL for finding users who are active in the security console but terminated in the applContent Hi experts, We have found an issue where sometimes when an employee is terminated in HCM they are still showing as an active user in the security console. To res… -
RTF TemplateContent Scenario: I have created two data sets in my data model: G1 and G2 G2(Parent) G1(Child) Parent will always have one row and its corresponding child can have a ro… -
Project task Exceptions-PPM Tables/ViewSummary Looking for Project Task Exceptions information in DBContent Hi All, I am looking for information about Project task exceptions data in PPM tables Or BI report t…
-
PJC_TXN_TASK _NAME_IS_INV ALIDSummary PJC_TXN_TASK _NAME_IS_INV ALIDContent I keep getting this error for below. some transaction load and others error. Task Number Task Name 3 Overtime PJC_TXN_TASK … -
Use subject area tile missing for create reportContent Hello, Financial Analyst and Accounts Payable Manager do not have the excel or Use Subject Matter tiles when creating reports. Am I missing a role, as the implem…