OTBI
Discussion List
-
Inventory Accrual ReportSummary: The Finance Department has no data on inventory accruals to as certain as to whether accrued inventory are being offset and balanced. Is there any seeded report… -
How to report on Burden Cost by Burden Cost Code when burden is applied on same expenditure?Summary: Burden amounts by cost code are available when you navigate to Manage Project Costs > select any transaction with burdens, then Select > Actions > View Burden C… -
Columns from View Billing Extension Event Details page not found in the backend tablesNeed backend tables or reference code for the below listed columns. Navigation: Navigator >> Contract Management >> Revenue >> Task >> Manage events >> query a contract … -
Notification to be sent to the maintenance manager to start the work orderHello, can we create a report where we have the start date and system's date, we scheduled every 1 hour for example, and if the system's is very near to the start date b…
-
Compensation OTBI Best PracticesSummary Technical brief discussing compensation related OTBI best practices Content Document 2571003.1 - Compensation OTBI Best Practices (July 2019)Gail Langendorf-Oracle 150 views 2 comments 8 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Transaction Tax Registration NumberSummary: Does anyone know if there is a column in OTBI that reports the Transaction Tax Registration Number? I have checked the Subject Area to Database Mappings via the… -
Benefits arrears OTBI reportHi all, We are trying to develop a new OTBI report for benefits arrears , we have used the following 2 subject areas with effective date prompt. 1.workforce management -…yugandhar 171 views 11 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
How to select more than one filter option in OTBI ReportSummary: How to select more than one filter option in OTBI Report Content (please ensure you mask any confidential information): Hi, we created an OTBI report. This repo…Barile Alberto 61 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM -
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 11 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 11 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… -
Download sample issue for the PVO in BICC consoleSummary: Below are the list of PVO's which are having the download issue for sample file 1.FscmTopModelAM.FosOrchestrationProcessAM.TransactionEventPVO 2.FscmTopModelAM.…Soare Oldrich Alexandru-Oracle 103 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
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 171 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 11 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. https://us.v-cdn.net/…