OTBI
Discussion List
-
OTBI reportOTBI reportVineet Srivastava Graviton 23 views 1 comment 0 points Most recent by Erick.B Reporting and Analytics for ERP -
SQL Query to Extract Accurate Last Login Date for Active Users in Oracle Cloud SCM PlanningDear Oracle Experts, We are seeking assistance in generating a report from the PROD environment that provides a list of all active users across the following Oracle Clou…Nagaraj A 100 views 2 comments 0 points Most recent by Nagaraj A Supply Chain Planning and Collaboration
-
Modify Actual Effort in hoursSummary: Can the "Actual Effort in Hours" field be modified after a training has been completed?: I am very confident that this EE did not spend 2300 hours to complete t…
-
How to Generate a Dynamic template based on the assigned Business UnitSummary: Hi Experts, I am seeking assistance regarding a specific requirement from our client. The client has expressed a need to create a document that is customized ac…
-
Capturing the Learning outcome from the Learning Record Real Time subject area- OTBISummary: Content (required): hi there, we have as learning outcome a custom certificate. The certificate has a name, issued by field and issued date. I wonder if this ca…Bobby Jourdan 31 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Audit report to capture critical events of user activitySummary: Hi Everyone, One of our clients is looking for the reports that show logons, access attempts, and data modifications. Does any seeded report exists in the Oracl…Mahamood Sk 31 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
Request for Guidance on Managing DEI Attributes in OTBI Analysis Following Executive Order 14151In response to the Executive Order 14151, "Ending Radical and Wasteful Government DEI Programs and Preferencing," signed on January 20, 2025, our Compliance team is work…SwatiSharma 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SQL query to display Purchase Category hierarchySummary: SQL query to display Purchase Category hierarchy Content (required): For anyone who might find this useful, I've written a SQL to pull the Purchase Category hie… -
Convert this filter to SQLSummary: Convert this filter to SQL does not function Content (please ensure you mask any confidential information): I try to using 'Convert this filter to SQL' function…
-
How Receivables Begin Balance is calculated for Receivables to Ledger Reconciliation Summary Report?Summary: How Receivables Begin Balance is calculated for Receivables to Ledger Reconciliation Summary Report? In the Receivables to Ledger Reconciliation Summary Report …
-
Identify persons active both as Employee and Contingent WorkerSummary: I have a requirement to identify employee records that have a User Person Type "Employee" AND a User Person Type "Contingent Worker" where Assignment Status Typ…JHaden3 255 views 5 comments 0 points Most recent by Gopinath.Ulaganathan Reporting and Analytics for HCM
-
Display Formatted Job Description Details on OTBI or BIP ReportSummary: Display Formatted Job Description Details on OTBI or BIP Report Content (required): We are trying to display Formatted Job Description Details onto an OTBI repo… -
What table stores reports that have hdl templates and hsdlSummary: I want to list all BIP reports that have HDL templates and list all HSDL templates. Is there a table backend that I can use or subject area that can pull this i… -
Is there a way to filter the result of OTBI Report?Summary: I am creating Asset OTBI Report to capture the assets that registered with past dates since there is no standard report is available. I have created OTBI below …Karen Ito-Oracle 2 views 1 comment 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets -
OTBI Learning - Unable to extract certain informationHi, I'm facing an issue on OTBI for Learning Module on the "Workforce Learning - Learning Management Real Time" subject area. When I try to extract these information of …
-
we need to modify the "reply to" on the dashboards and analysis that we send via emailSummary: We have different dashboards or emails that are sent via email to different users. However we want the users to be able to "reply" to any of those emails and th…
-
How do I report on the field 'Order Reference'In Court Order Calculation Card page, I need to report on the Order Reference field - how and where can this be found?Helen Tilling 1 view 2 comments 0 points Most recent by Helen Tilling Reporting and Analytics for HCM
-
Reporting on assessment attempt scores when there's more than one assessment in the offeringSummary: I need to report on the score achieved for each attempt within an assessment however I find that if an offering contains more than one assessment activity, the …
-
Report not displaying Barcode when executed from ESS jobSummary: Report not displaying Barcode when executed from ESS job Content (please ensure you mask any confidential information): We have customized the Receipt Traveler …
-
OTBI report on Project analysisSummary OTBI report on Project analysisContent Hi Experts, I am creating OTBI report on project analysis. I got all the columns in work area. Now need to add one column …
-
Sql query listing transactions with 'Pending' status with transaction tablesI want display_name and person_number information of records in 'Pending' status from transaction tables.Is there a sample query you can share?Cansel Karasoy 764 views 6 comments 0 points Most recent by Nitin Kashiv-Oracle Reporting and Analytics for HCM -
OTBI Report for Learning module, to extract expiration dates of coursesSummary: I'm trying to create an OTBI report that will show the courses, assignees and expiration dates from the Learning module but am struggling to pull through validi…