OTBI
Discussion List
-
OTBI Report is not giving actual Absense start date and absence date insted it is giving Date StartSummary We developed a OTBI Report to get the Absence details using the subject area Workforce Management - Absence Real Time subject area.To get the absence start date …User_2025-01-30-17-37-30-647 81 views 2 comments 0 points Most recent by Neha H Sharma Reporting and Analytics for HCM -
Discount for multiples. Not tired Based RuleSummary: The requirement indicates that if the order line requests multiples of 5 each of the product, a 10% discount is applied. Any amount that exceeds the multiples i… -
Is it possible to hide unnecessary buttons from OTBI Dashboard?Summary Is it possible to hide unnecessary buttons from OTBI Dashboard?Content I designed an OTBI dashboard, which when I run shows OTBI Header buttons and search option…Dharmendra Shukla 79 views 10 comments 2 points Most recent by AMIT KUMAR YADAV Reporting and Analytics for HCM -
Trying to pull Comments from Mid-Year Performance document into a reportSummary When Employee/Manager Comments fields are added to performance report, errors outContent I have a request to pull a report of all Goals and include the Employee …User_2025-01-28-20-43-56-568 59 views 4 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM
-
how to remove ESS Job "Create Uninvoiced Receipt Accruals" from user so that they cant runSummary: Business is not performing "Create Uninvoiced Receipt Accruals" So we want to remove this so that nobody will not run by mistake Content (please ensure you mask… -
Need access for Custom OTBI Dashboards : "Projects Control Dashboard" reportSummary: Project Role as "Project Team member" on Oracle seeded has no access for Custom OTBI Dash boards (specially "Projects Control Dashboard") . Our request is to pr…SRIRAMULA RAJKUMAR 41 views 6 comments 0 points Most recent by Sudhir Agir-Oracle Project Management
-
Is the accounting status of payments accessible in OTBI?Currently, only the accounting status of invoices appears in the criteria. Could you please specify the location column for the accounting status of payments?Anne Nicole 71 views 9 comments 0 points Most recent by Anne Nicole Payables, Payments & Cash Management -
DOR Report: How would I create a report that allows me to see DOR data by employee?I am trying to build a report that shows the following information for Document of Records, but the fields I add show no data. Would it be possible to know which fields …Jay_Brannan 113 views 11 comments 0 points Most recent by Jay_Brannan Reporting and Analytics for HCM
-
Is it possible to add candidate Hire date using OTBISummary: We have a requirement to include hire date in the report. The intention of the report is to capture all offers that are created, even if they don't end in hire.…Christina Roy 21 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
How to sum (group by) more than one column on OTBII need to create a custom column that aggregates WIP balance by both WO and Cost element. I can create sum(wip balance by wo) and sum(wip balance by cost element) but th…G.Engelmann 183 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Field to report the "Last Hire date"Summary Field to report the "Last Hire date"Content What is the field present in OTBI to report Last hire date. We are looking for the Field to populate Hire date if the…Prabhu Krishnamoorthy 338 views 3 comments 0 points Most recent by Gunjan Bobade Reporting and Analytics for HCM -
concatenate error in otbi reportSummary: CONCAT(NVL(TO_CHAR("Worker"."days"), '0'), ' Days, ', NVL(TO_CHAR("Worker"."months"), '0'), ' Months, ', NVL(TO_CHAR("Worker"."year"), '0'), ' Years') i tried t…
-
Manage Internal Supplier Profile Change ApprovalsCannot find Underlying Oracle Tables For The Setup And Maintenance Task - approval management Looking for the underlying Oracle tables for the Approval Management tasks,…NZ-user999 31 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to provide a Procurement Requester access to OTBI report creation?Summary: How to provide a Procurement Requester access to OTBI report creation? Do we create a custom role and add the BI Author role? Is there a privilege which governs…Asutosh Mishra 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for SCM
-
Global Access Groups clarification - Oracle LearningHi Experts, We have a request to create an access group for a particular course/offerings. Request is that only supervisors and managers should be able to see this cours…
-
How to get Miscellaneous Transaction Serial Numbers range if the serial numbers are consequetive?Summary: I have some report requirement to get the transaction serial numbers as: serial_from, serial_to, and range. The only source table I have is the serial number on…
-
Existing report to check the details about number of users logged into Supplier portal for SupplierSummary: Is there any existing/seeded report to check the details about number of users logged into Supplier portal for a Supplier. Content (please ensure you mask any c…
-
OTBI - recruiting - recruiting real time > Job Application issueSummary: Hi everyone, I'm customizing the 'Applications by Requisition' standard OTBI analysis. Trying to add the candidate Interview feedback field in the current analy…Saher 21 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
OTBI report only showing an individual's supervisor and managerSummary: I have a requirement to create a report showing each workers named supervisor and line manager (mostly these are the same person, but in some cases they're diff…Rich M 41 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Dashbord prompt issueSummary: Hi, I need assistance concerning the OTBI Prompt. I created a recruiting OTBI dashboard by combining two subject area subject areas in my report, 'Recruiting - …
-
Assigned Performance Document Manager not showing Assigned Indirect DocumentsSummary: I have created a dashboard that includes an OTBI report showing Performance Documents by When I run the report I can see all the Performance Documents assigned …Aaron Reynolds 21 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM -
Direct and indirect reports in dashboard promptHi There, We have designed a custom dashboard with is using the subject area Workforce Management - Checklist Real Time. We have a requirement to display direct and indi…MadanMohan 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Unable to add SQL based Dashboard promptSummary: Hi All, I am trying to add an SQL based Dashboard Prompt and facing the Error: Failed to load(Error during query processing (SQLExecDirectW). The SQL I tried to…Abhishek Bhaskar 103 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
SHARING OF OTBI REPORTHello and good day! Dear Oracle community friends, If a user has limited access to other modules (e.g. Procurement and Inventory Management users) and one user in that m…Regie Mercado 51 views 12 comments 0 points Most recent by Regie Mercado Reporting and Analytics for SCM -
In (Fusion HCM)Seniority Date Page How to hide custom field based on selected Rule from Drop DownREQURIMENT: When we select the Rule Is Job Seniority Date section from the drop-down list then the custom field is Seniority Date report needs to be visible under Senior…Ravindr-Oracle 71 views 1 comment 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management
-
SQL Select Query to Oracle SaaS TablesSummary Aside from OTBI, BIP or BI Analysis - is there another way to query-select SaaS Tables? Like an Oracle-provided Tool or 3rd Party ApplicationContent Hello, Aside… -
Specialization Title and Number in OTBI Learning ModuleHi Can you please tell me where can i can able to get the Specialization Title and Specialization Number in the Learning Module of OTBI (Workforce Learning - Learning Re…Shivam_123 81 views 7 comments 0 points Most recent by David Bean - BW Reporting and Analytics for HCM
-
What is the difference between CourseV3.dat and Course.dat?"If you have activity sequencing turned on, you can load courses, offerings, activities, and classroom and instructor reservations to the Oracle Learning catalog using t… -
How to show asset which has been suspended/resumed depreciation in OTBI report?Hi, I am trying to create new OTBI report to show the assets which they have been suspended/resumed depreciation. But I am not sure that which filed and areas should I s…
-
Which OTBI Duty roles trigger licence for PurchasingSummary: Business has a requirement to add OTBI creation access for users for Purchasing and Requisition Subject areas. Below Duty roles would be added to users' profile…Asutosh Mishra 61 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP