OTBI
Discussion List
-
Syntax for comparing numeric plain text value with number valueSummary: Requirement is to build analysis to identify employees whose payroll run result of a particular element does not match a corresponding value held in assignment …Alastair-dNS 33 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
WIE_MA_MTL_ASSIGNMENTS.EXPECTED_QUANTITY source table?Summary: Is the source table for WIE_MA_MTL_ASSIGNMENTS.EXPECTED_QUANTITY INV_SUPPLY? If so which SUPPLY_TYPE_CODE values are considered? If not, which table is the sour…User_2025-11-28-00-40-41-346 34 views 2 comments 0 points Most recent by User_2025-11-28-00-40-41-346 Manufacturing -
Unable to find the Subject area/SQL query to get the Final close date value in the PayrollRelationUISummary: In the Payroll Relationship UI we have final close date value at the Element duration dates as well as Assignment level. I am unable to find any subject area/SQ… -
Tile visual errors when The Table Visual is not added to ViewSummary: Hi, can anyone please help with the error message that appears when Table visual is removed from the view leaving the Tile visual in view. Content (required): T… -
Job Incumbents 10th 25th 50th 75th 90th incumbent baseSummary: We are building an otbi dashboard that can be leveraged to report on incumbents jobcodes and paygrade ranges. We have the base report with jobcodes and number o…Akshay.Agarwal 44 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Sharing Recruit to Hire Dashboard -- download catalog fileSummary: I know I have seen a posting that shared the delivered Recruit to Hire Dashboard in a customizable download file. Can someone share the link to that posting? I …Ellen Manthei 64 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Pivot table help - Measures dont sumSummary: Measures in a pivot table do not sum, instead appear as a 1 regardless of total. Content (required): Im new to OTBI and dislike pivot table (OTBI, excel, anywhe… -
Need A Dynamic way of setting Date Parameters to begin with the 01st AprilSummary: Hi, I need to schedule an OTBI report that looks at changes made to a salary from the 01st April to the last day of the previous month. For example the report s… -
Best Way to export Cost Accounting Distribution with Concatenated Accounting SegmentSummary: Costing - Cost Accounting Real Time Content (required): Hello Friends We are trying to use OTBI Subject Area "Costing - Cost Accounting Real Time" to export Cos… -
Required to create a report to capture Trade Operations and related PO's in OTBISummary: We are required to maintain a report to capture the Trade Operations and the related Purchase Orders. The report should also capture the status of the Trade Ope… -
how to get Good receipt note details with procurement details on OTBI reportSummary: Content (required): Hello everyone, We have a OTBI report in the production instance related to PR details. The subject area, " Procurement - procure to pay rea… -
Manager Details (more than one)Summary Writing an OTBI Report which pulls all of an employee's managersContent Hello, We record two managers for each employee at our company. One is the line manager a…John Gerbracht 106 views 8 comments 0 points Most recent by Kris Cregger Reporting and Analytics for HCM -
In what table are the item/categories association in the audit trail stored?Summary: The item audit trail report does not give enough information for the auditor to analyze all the information correctly. For example, the item description is not … -
How can I add the manager information of the employees to the Analysis report?I want to add the managers of the employees such as 'head,c-suite,sr.head' to the report I prepared from the analysis report. When I get this information from the "Matri…Cansel Karasoy 44 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM