OTBI
Discussion List
-
Benefit Eligible - Working Hours ChangesContent Hi all - we have requirements for our benefit eligible population: Person Type = Regular Employee, Limited Term Employee, Casual/Seasonal Employee Assignment Cat… -
Open Prepayment OTBI ReportSummary Open Prepayment OTBI Report with Validation status of Available that can be back dated to the prior month.Content I have an Open Prepayment report in OTBI from s… -
Report of Questions and Answers on AssessmentsSummary Report of Questions and Answers on AssessmentsContent I have having a hard time making a report that will give me answers a user input to the questions on an ass…Chris Pomager-27736 130 views 5 comments 1 point Most recent by User_2025-02-07-08-20-40-999 Learning -
Creating a report with questions and answers from assessmentsContent Hi everyone, we are trying to create a report, which provides information about Learning assessments. We would like to see the answers, the score and the persons…User_2025-02-07-08-20-40-999 57 views 0 comments 2 points Most recent by User_2025-02-07-08-20-40-999 Learning -
Country of Origin - How to enableSummary I cannot see the "enable inventory tracking by country of origin"Content Hello, In 20A we expected to see COO (country of origin) as a new attribute in PIM or In…User_2025-02-04-16-34-29-464 194 views 2 comments 0 points Most recent by Pradeep - Adroit Inventory Management -
Workforce Trend Headcount by User Person TypeSummary We have a requirement to trend headcount by person type. It appears the workforce trend real time subject area only returns the latest person type and not the pe…Ryan_Sullivan 60 views 5 comments 0 points Most recent by Ryan_Sullivan Reporting and Analytics for HCM -
Supplier address withholding tax tableSummary Supplier address withholding tax tableContent Hi, Which view contain the Withholding Tax Exemptions details and how to connect it with POZ_SUPPLIER_ADDRESS_V vie…Shlomo Elnekave 64 views 8 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for ERP -
Azerbaijan letter Ә Show Box In PDF Format. Font Displays Properly In Other FormatsSummary Azerbaijan letter ' Ә 'Showing as a Box In PDF Format when it is written in Uppercase . the letter Displays Properly In Other FormatsContent Azerbaijan letter ' … -
Inventory OnHand Balance ReportSummary Inventory OnHand Balance ReportMahgoub S.Mohamed 94 views 1 comment 0 points Most recent by User_2025-02-07-08-26-19-537 Reporting and Analytics for SCM
-
Effective Date Issue?Content Hi Experts, I've built an analysis in OTBI to extract Work Schedules doe Employees. Even though my report has the P_DATE effective date SQL prompt, it is bringin…User_2025-01-28-05-39-23-766 126 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Revoking User Access to the Shipped OTBI Content in Fusion HCM 19CSummary This white paper documents the steps to revoke access to the seeded OTBI content for all users in 19C.Content In 19C, OTBI introduced a new set of BI reporting r…User720640-Oracle 175 views 6 comments 11 points Most recent by Andra Maria Popescu-Oracle Reporting and Analytics for HCM -
Create Purchase Order from more than one RequisitionSummary Can not Create any Purchase Order from multiple RequisitionContent Hi Everyone, Basically, I can not create from multiple requisition. I researched from the foru… -
Table "ALL_TABLES" - does not include all tables?Content Hi, When I run a query in BI Publisher Enterprise, I can for example, get results from this query: SELECT DISTINCT UPPER(table_name), num_rowsFROM all_tablesWHER… -
Requisition Filled Date and Time to fill on ORC reportContent I am looking for a way to pull in the requisition filled date into a filled requisition report for ORC. I cannot find that field in the subject areas. In additio…Jennifer Eichholz 105 views 4 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Combining Multiple Question RowsContent I have an ORC report that is pulling our filled reqs and the candidates' information that have been hired into those reqs. We want to see on the report their ans…Jennifer Eichholz 46 views 2 comments 0 points Most recent by Jennifer Eichholz Reporting and Analytics for HCM -
Manager Detail ReportSummary My report doesn't show changes of managerContent Hi, Please see attached XML file. I have copied the output of an old report (I don't have the sql or xml for the…User_2025-02-05-22-44-35-842 60 views 4 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
How to create a Public View Object based on a SQL query and make it available on Order Management ExSummary We want to create a PVO in order to get the query data on Order Management ExtensionsContent Hello guys! We are looking for some information on how to create a P… -
Absence Report with Between DatesSummary Report not workingContent Hi, I have attached the XML for this absence report, can anyone work out why it won't run? I've tried different combinations in the cri…User_2025-02-05-22-44-35-842 30 views 10 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
Getting month and year into one column while maintaining date date type - EVALUATE NQSCOnfig.INI errSummary Getting month and year into one column while maintaining date date type EVALUATE NQSCOnfig.INI errorContent Hi - We are trying to graph an analysis that would sh…Roy Paolo Paunlagui 42 views 7 comments 1 point Most recent by Roy Paolo Paunlagui Reporting and Analytics for HCM