OTBI
Discussion List
-
Query to fetch the list of recommended courses again each employeeshi Team, Can anyone share a query to fetch the list of recommended courses against each employees? Thanks, Vinod -
MOT_REF_ENTITIES custom object table not pulling dataSummary: There is a OTBI report built using custom object subject area whose dimension and fact tables are populated with data thorugh some integration reports through s… -
Add requisitioner email address to purchase order rtf templateSummary: We got a requirement to add 'Requesitioner email id to purchase order document. At the moment buyers email id is included in the RTF template Content (please en…
-
Participant Feedback Report SQL Issue - HelpSummary: Hi, can someone pls help check what's wrong with this SQL below. When I add the Performance Document Participant"."Role Type, I receive this error: I want to fi…
-
Issue Accessing Data in Custom HCM BI Report in Lower EnvironmentHi Team, We have a custom BI report in the HCM module that retrieves both Salaried and Hourly employee data. Although the required data access and roles appear to be cor…Deepak kumar Rai 1 view 0 comments 0 points Started by Deepak kumar Rai Reporting and Analytics for HCM
-
Why are some users receiving error:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P ?Summary: Some users are receiving Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P when attempting to access a OTBI Dashboard. However, other …Edlyn Almanzar 784 views 10 comments 0 points Most recent by Bo Tøpgaard Reporting and Analytics for ERP
-
How To Change The Date Format For Date Columns In BICC ExtractSummary: Hi Team, My requirement is to insert the values from the date columns of BICC extract into ATP using DBMS_CLOUD.COPY_DATA functionality. COPY_DATA is not workin…VishnupriyaSelvakumar 2 views 0 comments 0 points Started by VishnupriyaSelvakumar Reporting and Analytics for ERP
-
How to add Shipment Header DFF in OTBI report?How to add Shipment Header DFF in OTBI report?Mugdha 21 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
How do I create an aged report for open transfer orders in OTBISummary: I am trying to create an OTBI Analysis for Open Transfer Orders. We would like to see a count by destination, date, cost of inventory item and possibly the GL A…
-
Oracle criteria to identify OTBI reports with specific column in itHi All, We are migrating to V3 Seniority Date from V1 Seniority dates. This migration is impacting our OTBI reports which are using ‘Enterprise Seniority Date’ column. S… -
Fixed Assets Report Showing Data from Financial Book but Not from Tax BookWhen generating a Fixed Assets report, the output displays information from the Financial Book, but no data appears from the Tax Book. Could this issue be related to a m… -
Subscription OTBI Report is not Fetching Amount data for non-USD currenciesOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Description (Required): I have observ…
-
No email notification after Payment Process Request in DEV (Expense Reimbursement)Summary: Not receiving email notification after Payment Process Request (PPR). Content (please ensure you mask any confidential information): After submitting a Payment …
-
Workforce Learning OTBI: Learning Community Hierarchy and Course NameHi Team, https://us.v-cdn.net/6034893/uploads/M8KQZ39LW7BG/course-community.txt I have a requirement to build an OTBI report that includes course details such as Course …
-
OTBI report is erroring outSummary: An OTBI report is giving error. Would appreciate if anyone can share your inputs. Content (please ensure you mask any confidential information): Version (includ…Global Support Desk 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI report prompt to display only direct reports for Line managersSummary: We have created an OTBI report using the subject area - 'Workforce Learning - Learning Management Real time'. We have created a prompt which displays all the Em…Sovan Mishra-Oracle 542 views 10 comments 0 points Most recent by Lakshmi Neelima Gollapalli Reporting and Analytics for HCM
-
OTBI Report to fetch List of Line ManagersSummary: OTBI Report to fetch a List of Line Managers who have at least one direct report and the direct reports(Employees) should be Salaried. Content (required): For t…Thulasi Ram 482 views 6 comments 0 points Most recent by Lakshmi Neelima Gollapalli Reporting and Analytics for HCM -
I am looking for a report to validate or find missing goals in PerformanceSummary: I am looking for a report where it has Employee number, Name, Performance Document Name, Goal Period Name, manager, and Goals Status(Has goals or No goals ) Con… -
OM Redwood - Ability to embed OTBI report to create order pageHi, We need an option to embed a custom OTBI report to redwood order management create order page. We need to be able to pass bind parameters to the report. This was pos…
-
Can we use two Subject Areas together in OTBI Report?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Tejas Chirke 1 view 1 comment 0 points Most recent by Saravanan Veeraragavan Product Master Data Management
-
Saved but not submitted Promotability assessment questionnaire responses from Talent assessmentWe are trying to report on 'saved but not yet submitted' Talent Assessment Manager evaluation responses, using multiple avenues but not getting intended results. Subject…
-
Populate if an employee is a Manager in HCM OTBISummary: I'm trying to create a report in OTBI with the subject area Worker Assignment Real. And in the Worker Assignment folder there is Manager Flag. However all our p…
-
OTBI - Checklist Questionnaire ReportingSummary OTBI Reporting on HR Checklist QuestionnaireContent Hello, Did any one try out OTBI report on Checklist questionnaire in 20C update. I have tried one, I am able …User_2025-02-05-07-43-29-505 728 views 32 comments 2 points Most recent by PranitSawant Reporting and Analytics for HCM -
Is it possible to change the subject/content of the email sent out to requestors on a PO?Summary: Currently, once a PO is implemented, the requestor on the PO lines will be notified via bell icon and email notification. Is it possible to update the email con… -
Convert Double Data Type to Words in OTBISummary: I am trying to build a report (OTBI analysis) where a double data type field (the Amount column) needs to be displayed in words. For example, if the amount is 3…Nur Anisa Zulkhairi 21 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Report to extract initiatives associated to Learning ItemsHello all, We're trying to create a report which should extract for each learning item (specialization, course, offer etc) the initiative(s) created and its status (acti…