OTBI
Discussion List
-
Return to Vendor Report?Summary: Business needs a report of completed and pending RTV/RMA transactions. Content: Business is using Sales Orders to ship product to customers. Need a report to tr… -
How to create a Bell Curve in OTBI reportSummary: Client team is expecting to show the Performance Rating Distribution results in a Bell curve model as shown in the attached screenshot. Could you please share a…Santhosh Gangishetty 352 views 14 comments 0 points Most recent by Gimhani Perera Reporting and Analytics for HCM -
DFF Value is not available in the BI Subject Areas - INV_LOT_ATTRIBUTESSummary: Do not see new DFF created in 'Inventory - Inventory Balance Real Time'. Please see attached. Content: Name Lot Attributes Flexfield Code INV_LOT_ATTRIBUTES App…
-
Getting merged and blank rows while trying to fetch Performance rating and Salary together in OTBISummary: Hi Peers, I am trying to build an OTBI analysis to fetch both the Performance rating and the Salary. I'm using Compensation - Salary Details Real Time and Workf…
-
Presentation Variable Dashboard Prompt Not Working For KPIsSummary: We created a custom Talent Acquisition Activity Report Dashboard via OTBI and recently added a Presentation Variable prompt for 'Workplace Segment'. The dashboa…Maryellen_Gancena 11 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
How to restrict custom report using cost center management segment Label in oracle fusion CloudSummary: How to restrict custom report using cost center management segment Label in oracle Cloud fusion? What is the Purpose of Management segment Labels in Oracle fusi…Raoof Ahmed 32 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Cost Accounting Period End Error Out -The transfer of transactions from source systems is pending.Summary Period Closure validation process error - Exceptions shows "The transfer of transactions from source systems is pending."Content When the user tried closing the …User_2025-02-08-00-15-22-284 1.8K views 18 comments 0 points Most recent by Arunkumar S-Oracle Costing -
How can we Restrict Users to Access data on OTBI/UI, particularly to those projects they assigned ?Summary: We have created a Custom Role to the Senior Projects Managers to view access on OTBI from """How Can Non Project Managers Access Review Project Performance Dash…
-
Assignment Manager (Unsecured) significantly slower in Workforce Performance Subject AreasSummary: Material / significant slowness that appear to be driven by [Assignment Manager (Unsecured)] folder within Workforce Performance Subject Areas, relative to othe…
-
Position DurationSummary Provides the duration of the workers in a specific positionContent This analysis provides the duration(in days) of the workers in all the positions that they hav…Raghavendra Raghunath-Oracle 206 views 6 comments 4 points Most recent by Shannon_Johnson Reporting and Analytics for HCM -
OTBI Dashboard only shows Indirect on promptSummary: OTBI dashboard is only showing Indirect in drop down prompt. Need to be able to choose between Direct and Indirect reports. Content (please ensure you mask any … -
Which privilege need I to view data in vbs page?I created a vbs page that extract the customer data, but without "Application Developer" role the user can't see nothing when starts the calls. I can access to the page …
-
Cannot add certificate to catalog defaultWe are unable to add the certificate defaults under catalog defaults. it does not render any results for us, are there any other reasons this could happen? Fixes we have…
-
OTBI - Calculate age in years and monthsSummary How to calculate the age in years and months?Content Hi, In OTBI I want to create a column which present the full age of the employee, for example 43.12 (means 4…Yaniv 905 views 18 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
custom report in Thrive that relates to competency assessments within an individual’s profileHi, I am looking to build a custom report in Thrive that relates to competency assessments within an individual’s profile. There doesn’t seem to be a suitable native rep…Chintan Shyara 1 view 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to fetch the time period for fetching the salary details of the employeesSummary: I am working on a query to fetch the period name as per the payroll name selected from the LOV as parameter to fetch the salary details of the employees . I am …Tuhinaa Nanda 84 views 3 comments 0 points Most recent by Will Paddock -Support-Oracle Reporting and Analytics for HCM
-
How long applicant is staying in Each PhaseSummary: I want to create OTBI analysis to find out how long an applicant is staying in each phase of a requisition. I tried to use "Phase or State Duration" column from…User_2025-01-28-19-26-47-704 71 views 7 comments 0 points Most recent by Justice Z Reporting and Analytics for HCM
-
Some Requisitions Dropped from OTBI Reports after Adding any Data Column that is not HyperlinkedSummary: Some requisitions were dropped from OTBI report after adding a data column that is not hyperlinked. Content (please ensure you mask any confidential information…Kathleen Nguyen 21 views 2 comments 1 point Most recent by Kathleen Nguyen Reporting and Analytics for HCM
-
Changing Oracle out-of-the-box data model of invoice print templateSummary: We have a requirement in the invoice print template to group and print the Bundle Name for lines with a bundle and just the product name for lines that are not …
-
How to enable Report Job History to BI Consumer in Home page of BI Catalog?Summary: Please refer to the BI Catalog Home page of BI Author and BI Consumer. How to enable also Report Job History link in Home page of BI catalog to BI Consumer? Wha…CS Yuen-Oracle 111 views 2 comments 0 points Most recent by CS Yuen-Oracle Reporting and Analytics for HCM
-
Can we display the count in the graph while creating dashboard?Hi Team, I was trying to create a dashboard so what happening is if u out the cursor in the graph the counts are coming. So is it possible to display the counts in the t…Abhisek Kanungo 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Capture in OTBI the Attachment field in a Person Profile Real Time subject areaSummary: Content (please ensure you mask any confidential information): hi there, There is a field "Attachment" out of the box field at the bottom of the Talent Profile …Bobby Jourdan 11 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
I need sql query for Consumed Allocation in GOP Review Supply AllocationSummary: I need sql query for Consumed Allocation in GOP Review Supply Allocation to create a BIP report Content (required): Business requirement to prepare a report tha…
-
Generate a count of employee self service requests for certain employee data fieldsSummary: Is there a way in OTBI to generate a count of the number of times an employee changed personal information data in self-service over a period of time? My unders…