OTBI
Discussion List
-
Last 7 days or week query - Looking to query for Opps, Contacts or Accounts updated in last 7 daysSummary: I am trying to generate reports on Opportunities Created or modified in last 7 days - or "Last Week". Also, I want to do the same with Contacts and Accounts cre… -
Equivalent table/view of GMS_BALANCES from EBS in Oracle CloudSummary: I am not able to find equivalent table for GMS_BALANCES from EBS. I had an interface which fetched period to date values from eBS (mentioned below) but not able…Nilesh R Goyal 41 views 1 comment 0 points Most recent by Shivashish Dwivedi-Oracle Subledger Accounting & Accounting Hub
-
Timecard status reportSummary Trying to retrieve a report in Fsuion which gives timecard at its different status of its lifecycle.Content Does anyone know of a report that would give the time…Shelly-Ann Mahabir 86 views 4 comments 0 points Most recent by Shelly-Ann Mahabir Reporting and Analytics for HCM
-
The promt does not affect the analysis report on the Dashboard screen.I have an analysis report that I use on the dashboard screen and parameters that I expect to affect this report, and one of these parameters does not affect the report, …Cansel Karasoy 61 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Is there a standard report for generating invoice cover letter by contractSummary: Is there a standard report for generating invoice cover letter by contract Any inputs on this will be appreciated. Content (required): Version (include the vers…
-
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 2.8K 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 62 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…