OTBI
Discussion List
-
Deep Link/table for each task notification?Hi all, I need an SQL query or a deep link to get the link for the tasks in the BPM worklist like this: thanks.Mohammad Borghol 96 views 4 comments 0 points Most recent by Kristy Fung Reporting & Analytics for Fusion Service -
Issue with Month-wise Active Headcount Count in Workforce Real time Trend Subject Area - OTBI ReportHello All, I am working on a report using the Workforce Trend - Real Time subject area in OTBI. The requirement is to show month-wise new joiners, attrition, and total a…KetanChavan 121 views 7 comments 0 points Most recent by Diana Mitrovski Reporting and Analytics for HCM -
Can OBTI “Payment History Real Time” & “Disbursement Real Time” have fields like payment DFFCan below fields like Payment File Reference and Payment DFF extract into OBTI report like “Payables Payment - Payment History Real Time” & “Payables Payment - Disbursem…
-
Can OBTI “Payment History Real Time” & “Disbursement Real Time” have fields like payment DFFCan below fields like Payment File Reference and Payment DFF extract into OBTI report like “Payables Payment - Payment History Real Time” & “Payables Payment - Disbursem…
-
Inputs Needed for BIP Folder Setup.Summary: Inputs Needed for BIP Folder Setup. Content (please ensure you mask any confidential information): By mistake, we removed My Folders in the lower environment. W…
-
Process learning records is not fetching the OTBI analysis reportSummary: Created learning initiative with analysis report and scheduled the Process learning records. But it is not assigning the specialization to the new hires. Showin…
-
What is the required privilege to access and run an existing report?Summary: We created a role to view suppliers, but now I can't access a report I previously created. Which privilege allows me to run this report? I see the report and an… -
Oracle table name to fetch all Supplier Profile Change Request DetailsSummary: We have requirement to build report with below columns. 1. Supplier name 2. Supplier account number. 3. Date of account update- Initiated 4. Account update- Dat…
-
How to capture Tax Registration Number at Supplier Address level in OTBI reportSummary: Requirement is to populate Tax Registration Number from Supplier Address level in OTBI report Content (required): I have created an OTBI report for Supplier Mas… -
How to output a list of all reports and their folders in Production environmentSummary: We are trying to map all reports in our production environment, with their folder locations. Does anyone know of an administrative tool that might be able to ou…Rich R 1.6K views 31 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
How to report on Unsubmitted Timecards?Content Has anyone been able to produce a report showing which employees haven't yet submitted a time card in a given period? Any help would be much appreciatedUser_2025-01-28-05-35-00-925 142 views 8 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Use order date for order pricing not available in OTBI subject areaSummary: Looking for 'Use order date for order pricing' flag in OTBI Analysis Content (please ensure you mask any confidential information): We have recently enabled fea…
-
Position trend real time Subject Area - how to find Position Incumbent?Summary: Hello. I'm trying to build a report of open positions and their previous position incumbents. Is it possible to create this report using a new subject area 'Pos… -
Different vision in OTBI than in UISummary: Hello We have moved to a Redwood theme in our UI but then our OTBI report look at change. It now looks very old school. Also please note that when we open it in…
-
OTBI Dashboard Reverted to Old UISummary: Hi team, We have a dashboard that has reverted to an older UI in both Test and Production environments. However, the same dashboard in DEV looks fine and retain…Josel Pleyto 121 views 4 comments 0 points Most recent by Nicolas-Vahman Reporting and Analytics for HCM
-
Does transfer order line DFF appear on OTBI reports, BI enabled flag is not available on SegmentSummary: Does transfer order line DFF appear on OTBI reports, BI enabled flag is not available on Segment configuration Content (please ensure you mask any confidential …
-
Table name of language Level in skill and qualification sectionSummary: Does anyone know the table name of the language Level table name in the skill and qualification section? Currently, I'm using attached BI query to fetch the oth…Saher 91 views 3 comments 0 points Most recent by YashaswaniSrivastava Reporting and Analytics for HCM
-
Information: Query to get last P2T/T2T Refresh DateSummary: In order to get last refresh date from backend, below SQL can be used: select * from ask_deployed_provision_configs last_update_date column in this table gives …MandeepGupta 411 views 5 comments 14 points Most recent by Sudeep Doke Reporting and Analytics for HCM -
Procurement - Requisitions Real Time not display requistion requesterSummary: OTBI to cannot show requester name Content (please ensure you mask any confidential information): I am trying to create an OTBI report for Purchase Requisition …
-
Changes to expense approval template does not reflect after 24hoursHi all, We have a requirement to modify expense approval template to add the account number to show up on the email notifications. To achieve this, I have modified the '…
-
Combining Oracle HCM Source and data from Microsoft Excel file sourceSummary: Combining Oracle HCM Source and data from Microsoft Excel file source Content (required): We have created a report where we have defined a data model with a joi…Vasanthakumar Ravi 121 views 8 comments 1 point Most recent by ViswanadhK Reporting and Analytics for HCM -
HDL Error ReportingSummary HDL Error ReportingContent Hi Experts, Does anyone have user friendly error reports for HDL Loads. Because PBL is deprecated, we are looking for a good reporting…
-
Only access seeded reports and subject areas in OTBISummary: Client wants a role to allow them to access seeded reports and OTBI subject areas but not any fusion tasks. Is it possible? Can you please guide us?Amit Dey 11 views 2 comments 0 points Most recent by Jehosheba Amruthaluri Reporting and Analytics for ERP
-
Unable to create report using Workforce Management - Assignment Action Occurrence Real TimeWe have a custom role mapped to the Human Resource Specialist role, with a new requirement to grant access for creating reports using the Workforce Management – Assignme…Rica Cruzado 21 views 3 comments 0 points Most recent by Rica Cruzado Reporting and Analytics for HCM
-
Rational for the 14day record retention limit on successful HCM AlertsSummary: What is the rational why successful Alert records are saved to the tables for only 14 days? Content (please ensure you mask any confidential information): We wo… -
List of UI Labels effected with User Interface Text tool - renaming of labelsCustomer needs a list of effected UI labels (on pages/modules) when using the User Interface Text tool for renaming labels in Fusion environment. Is there SQL for me to …