OTBI
Discussion List
-
Does anyone have any prebuilt Order Management aging OTBI analysis to share?Summary: I am looking for any prebuilt OM Aging OTBI analyses that can be used as a starter file. I am new to using OM and trying to build an OTBI analysis grabbing very…Teresa Meyerhoeffer 12 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM -
How to restrict the List of Inventory orgs from LOV on reportSummary: We have custom report for Inventory on hand. User has to select the Inventory org as a LOV Parameter. How do we restrict the list of Orgs in LOV? Currently any …Shrikant Bhavsar 11 views 1 comment 0 points Most recent by Shabbir M Tahasildar Inventory Management
-
After a work order is completed, how can I query the data of the sales order and wo order details?Summary: I need SO details and WO details after completing the WO, which the direct link will be removed. And is that query available in BICC PVO? Content (please ensure…
-
Account Profile Conversion Rate Type field is showing Id instead of Name in OTBI AR reportSummary: Account Profile Conversion Rate Type field is showing Id instead of Name in OTBI AR report, it is showing name only for the seeded value i.e Corporate. P.N - We…Rahul Kumar Gupta.-Oracle 22 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Recruiter Preferred NameSummary: Wondering if anyone was able to pull the recruiter preferred name and preferred last name in OTBI reports.Marta Martinho 11 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Is there any report for outside processing work orders?Summary: Are there any out-of-box reports for information on outside processing work orders? Content (please ensure you mask any confidential information): Need a report…
-
After a change order is created, is there a table where previous versions of taxes are stored?We are trying to create a report for when a change order is created in the Purchase Order (PO) to change the tax and it gets approved. We want to see what the tax is aft… -
Need OTBI subject area to fetch the Channel Revenue ManagementSummary: Need OTBI subject area to fetch the Channel Revenue Management Content (please ensure you mask any confidential information): I am new to SCM modules. Any input…
-
Invoice Approval Deep LinkSummary: Invoice Approval Deep Link Content (please ensure you mask any confidential information): Hello, Do you know if there is a deep link that can be used to approve…Irina Erhan 173 views 11 comments 0 points Most recent by Alon Hadar Tamir Payables, Payments & Cash Management
-
OTBI - worker assignment real time - user visibility issueSummary: OTBI - worker assignment real time - user visibility issue Content (please ensure you mask any confidential information): Hi team, we have an issue with an otbi…Claudia Schiff 19 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Get all EMP reporting to a manager in certain time periodI am looking to get all direct reports(all active and term) of a manager during the time period 10/31/22 to present day 05/20/24. If termed I need also need the term dat…Trupti Khodke 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Total Compensation Statement OTBISummary: Analysis for Total Compensation Statement - Feedback Survey Content (required): Is there an analysis available in OTBI to pull data for the Total Compensation S…Shelly Feyerherm 81 views 13 comments 0 points Most recent by Art Cannon Reporting and Analytics for HCM -
Absence Daily BreakdownWe have a daily absence breakdown report built using the subject area Workforce Management - Absence Calendar Details Real Time. SQL code attached. There are a number of…
-
Oracle HCM Value Sets Rest APIHi, I want to create a record for value set using Oracle Rest Api information.I found this API for this How should I use the ValueSets_Id information, which is the param… -
Report off of Attachments Within Performance ModuleSummary Managers and employees can add attachements to their performance form. I need to know who has an attachment.Content Our managers can use the attachment field at …User_2025-01-25-00-37-41-739 72 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to get the latest record in OTBISummary: Hi , I am just working on very simple requirement . Where i need to get below columns. Employee/ZinZai ID Person full name Person email address Person status ( …Vishnupriya 457 views 6 comments 0 points Most recent by Vishnupriya Reporting and Analytics for HCM
-
Table for BPM - specifically CONFIGURATIONSContent We are looking for tables to be able to look at the workflow rule configuration. For example, we want to be able to create a report that will tell us things like… -
Can you customize Learning Certifications Report and add to specific courses + specializations?Summary: Hi All, We are trying to leverage the 21D functionality that enables learning completion certifications to be printed and displayed by users. The question is th… -
How can give condition Sysdate betwee effective start date and effective end date in OTBI analysisSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Anup Karmankar 64 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Receivables Aging by General Ledger Account ReportSummary: We are trying to develop a new custom aging report as to ease the reconciliation and make some custom column but we are not able to match the report with the st…
-
link between FND_SESSIONS table to country and stateSummary: link between FND_SESSIONS table to country and state Content (please ensure you mask any confidential information): By using FND_SESSIONS table, we can get the …
-
Learning Incident - Learning Item Owner No Longer in the CompanyHello! If the course owner/creator is no longer with the company (terminated or resigned), who would receive the notification if the course created by them is reported? …