OTBI
Discussion List
-
Is there a REST/SOAP API to get Production Transaction History Details?Summary: Looking for a REST/SOAP Webservice to get the Review Production Transaction History Details. Content (required): Is there a REST or SOAP service that can be use… -
GL seeded report or similar report requiredSummary: Business wants to generate Foreign currency detail TB. Content (required): Business wants to generate Foreign currency detail TB. UK Ledger currency GBP and the…Kumar 57 63 views 2 comments 0 points Most recent by Suresh Kumarasamy-Oracle General Ledger & Intercompany -
Which table stores the "Assign as" information for initiativeSummary: Hello All, I am trying to build a report to fetch learning initiative details but i am not finding any information regarding the assign as column in the UI.Plea…minati_behera-Oracle 51 views 3 comments 0 points Most recent by minati_behera-Oracle Reporting and Analytics for HCM
-
How can i query the "Active" Organization Tree version description?Summary: How can i query the "Active" Organization Tree version description? Content (required): I'd like to be able to return the value / name of the Version ID tied to…Shant Karakashian 3K views 3 comments 0 points Most recent by Shant Karakashian Reporting and Analytics for HCM
-
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 31 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 31 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 41 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 61 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 102 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 …