OTBI
Discussion List
-
Payables to Ledger ReconSummary: Payables to Ledger Recon Content (required): Payables to Ledger Recon Payables Ending Balance differ from the Payables Trial Balance. Is there a Report to valid…CraigX 31 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management -
How to map an Subject Area Field to an Oracle tableSummary: I am trying to find the table that holds the company name for our contingent worker the field that I am trying to map to SQL is I thought the data would be in t…User_2025-02-04-08-51-08-912 41 views 9 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
Workforce Learning – Learning Management Real Time - How to restrict access on Grade\Positions\JobsContent Hi, The Learning Specialist role provides access to OTBI Subject area "Workforce Learning – Learning Management Real Time". This subject area also gives access t… -
Analysis report to exclude new hires using hire date only within the current yearSummary: Analysis report to exclude new hires using hire date only within the current year Content (required): I am looking to develop an analysis report that excludes n… -
Termination - reporting offboarding commentsSummary: Content (required): We are trying to create a report that selects all terminated employees within a date range, along with the term action reason. Many times ou…Annette M 61 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
T.nareshkumarratnakaram-Oracle 21 views 1 comment 0 points Most recent by nareshkumarratnakaram-Oracle Self Service Procurement -
OTBI report logic to fetch Employees who were in current position as of 1st June,2019Summary: We have a requirement to create an OTBI report which will fetch all Employees who were in current position as of 6/1/2019. I was looking at the subject area - '…Sovan Mishra-Oracle 131 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report on all the comments that the enrolled users have done in Enrollee Self-service conversationSummary: Content (required): Hi there I want to run a report on all the comments that the enrolled users have done in Enrollee Self-service conversation in a course. Is …Bobby Jourdan 11 views 2 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM -
How to find 'User Defined Column' within Compensation PlanSummary: Can anyone help locate this field within a Compensation Plan. I need to find "Numeric Column 18", preferably within a Subject Area or if it's only within a tabl…Andrew_Schmitz 41 views 5 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Join "Approval Notification Archive Real Time" & "Transaction Administration Real Time" subject areaSummary: How to join Human Capital Management - Approval Notification Archive Real Time & Human Capital Management -Transaction Administration Real Time subject area Con…Nikhil Bhandari 371 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Unable to find Filing Status, Allowances and Exempt fields in OTBI in 19CContent Hi All, We are unable to find the "Filing Status" , "Exempt" and "Allowances" fields in "Payroll - Calculation Cards Real Time" OTBI subject area. When we click … -
Subject Area filtering - empty valuesSummary: Subject Area filtering - empty values Content (required): Subject Area filtering of Assignment Type filters out empty values as well. For example, if we have pe…User_2025-02-11-21-40-21-159 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is supplier audit report available in fusion payables?Summary: We are looking for standard report to track old value and new value when supplier name, supplier bank number, etc is changed. Please let us know is there any st… -
Can we pull Formatted Description attribute at the Item Level into a OTBI Report?Summary: Is it possible to pull the Formatted Description attribute at the Item level to be pulled into a report? This is an rich-text attribute and wasn't showing up in… -
Data StrategySummary: I am in need of running a report that pulls how many minorities in a certain grade were promoted to an officer status. Please help guide me to the correct subje…User_2025-02-11-00-58-38-371 21 views 2 comments 0 points Most recent by User_2025-02-11-00-58-38-371 Reporting and Analytics for HCM -
Need sample analysis/SQL to get various balance values for each assignment for EE with multiple GTSummary: When global transfer happens for any employee, we need to validate various balances to confirm if they are transferred to the new LE. During a year if an EE is … -
Average Salary for Job over TimeSummary: Need average salary for a job code over time Content (required): Is it possible to look at average salary for a job code month over month? Version (include the …Riti Malhotra 22 views 12 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM