OTBI
Discussion List
-
Incorrect value/Same Value being displayed in Projects-OTBI reportsSummary: Content (required): Projects-OTBI reports show incorrect values, Budgets, Actuals, and Commitments are all displayed as "3".Occasionally, or depending on what e… -
How can I get only the latest results when reporting on the status of a certain training?Summary: I try to report on the status of a certain required learning to see who has not completed it yet. If the learning was deployed this year, but also the year befo…Cora_Stanciu 31 views 3 comments 0 points Most recent by Cora_Stanciu Reporting and Analytics for HCM -
Using Country of Origin field in Inventory TransactionsSummary: We have disabled the checkbox for tracking inventory by Country of Origin in Organization Parameters. But the Country of Origin field is available on receiving …Mugdha Tilwe 66 views 1 comment 0 points Most recent by Lynn Warneka-Oracle_inactive Inventory Management
-
Restrict the access for creating data model and create analysisSummary: Hi All, How to find the roles which are giving create and edit access of analysis and BIP report? is anyone have any SQL for to find out these in any custom rol…Amit_Ekbote 42 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
While running whole population in OTBI we are facing issue.Summary: Content (required): we are using Pivot table output in the OTBI report for 1 or 2 employee it's working fine when we are running whole population, we are gettin…challa praveen 21 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need sql query to get invoice number in fulfillment line detailsSummary: Need query to get invoice number in Fulfillment lines. Screenshot attached. Content (required): As business request we have to add invoice number to order fulfi…kalyan gade 1.1K views 2 comments 0 points Most recent by kalyan gade Reporting and Analytics for SCM
-
Unable to see the Goal Status for Goal plan reportSummary: Unable to see the Goal Status for the Goal Plan OTBI report Content (required): Employee has submitted the goals for approval, but the same is not reflecting in…
-
Report to extract LRU Calculation cards configuration detailsSummary: Report to extract LRU Calculation cards configuration details Content (required): Hi Team, Greetings! Does anyone have the report or the query to extract LRU Ca…Parag Hiremath 61 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
OTBI-Expense-Expense Transactions - SQL to Link Expense and PPM ?Summary: OTBI-Expense - Expense Transactions - SQL to Link Expense and PPM Content (required): Hello I have an OTBI report with the subject area Expense-Expense Transact…Cesar Saveedra 41 views 1 comment 0 points Most recent by Vinodhini Vobhilineni-Oracle Project Management
-
How to report date/time stamp when a Candidate Label was added.Summary: Content (required): is there a way to report the date/time stamp when a label was added to recruiting>candidate>candidate - labels> label Name ? I see there is … -
Report to get the duplicate element entries in a given pay periodSummary: Report to get the duplicate element entries in a given pay period Content (required): Hi Team, Greetings! Is there an existing report to get the duplicate eleme…Parag Hiremath 12 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to add account balancing segment filter in Receivables Aging report?Summary: I need to add multiple balancing segment filters in "Receivables Aging by General Ledger Account Report" Content (required): Hello, What i see now in the balanc…Teodora Bulancea 61 views 2 comments 0 points Most recent by Teodora Bulancea Receivables & Collections
-
Mass Update messagesSummary: Content (required): What table stores the messages from Mass Update transactions? Version (include the version you are using, if applicable): Code Snippet (add …Scott Paulin 41 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Hide "Create Bookmark Link" LinkSummary: Dears we are trying to hide the link highlighted in screenshot attached but we dont understand how. OTBI is available to users within a dashboard, we already ch…
-
Using OTBI to fetch latest ACTIVE assignmentWe would like to use a filter which we can re-use to fetch the latest active assignment for a person. For 99% of our population, it works to do MAX("Worker"."Assignment … -
Physical Inventory Adjustment ReportHello, Has anyone created a Physical Inventory Adjustment report for Oracle Fusion? We're on version 23A. Any guidance on the query would be appreciated. Thank you, Julia -
Total Actual Effort in Learning by DepartmentSummary: I am trying to write an OTBI analysis where we are able to pull in the total headcount of a department, the total actual effort hours of learning for that depar…KatieH 132 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
VRM_CUSTOMER_CONTRACT_AUDIT Table storing information against each contract createdSummary: We are looking for the information on VRM_CUSTOMER_CONTRACT_AUDIT Business team is mainly looking for a Contract Audit report to show clearly what all changes h…
-
User is not able to run Customer report in OTBI report,Summary: Users is not able to run Customer report in OTBI report, could anyone please let me know which Duty Role or Privilege required to run this report, we have assig…Mohit07071990 31 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service
-
OTBI - How to get all workers who are hired, and transferred to the target department in 30 days?Summary: OTBI - How to get all workers who are hired, and transferred to the target department in 30 days? Content (required): Hi experts, Could you point me in the righ…Volodymyr Faranosov 31 views 4 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Hiding Out of The Box Reports - (Human Capital Management)Is it at all possible to hide the folder that contains the out of the box reports (Human Capital Management)? I can see we can remove the 'BI Consumer Role' from our rep…MikeW 53 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
OTBI reports: 1. Users with 2 assignments 2. Positions with 2 incumbentsSummary: OTBI reports: 1. Users with 2 assignments 2. Positions with 2 incumbents Content (required): Hello, I'm building a data quality dashboard and would like to ask … -
Column Data to print inline using Logical sqlSummary: We want to print area manager value in single column if there are multiple of them, currently its printing in two separate lines. Content (required): OTBI repor…Praveen D 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Cannot display data on standard analysisSummary: Generic user cannot see data while admin user can Content (required): Standard Analysis "Recruiter Work Load Details" saved under /shared/Human Capital Manageme…Stefano_Mazzocca 31 views 3 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Automatic parameter binding for contextual reportsSummary How to configure R13 functionality "Application Context Passing to Embedded Reports"Content We are trying to configure the solution "Application Context Passing …Gabrielle Ungaro 69 views 2 comments 1 point Most recent by Satheesh Nesamani Reporting and Analytics for HCM -
Reporting on OTBI and its Subject areas in UseSummary: There is requirement to check if there are any existing OTBIs that uses fields identified as sensitive. Is there a way to achieve this? Content (required): refe…Girish_Kulkarni_123 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Performance Reviews for Inactive employeesHi, I am trying to pull a performance review for a terminated employee.When I go into the performance performance goals screen and search for the employee, he iş appear …Cansel Karasoy 41 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
How to get the monthly details of the Asset depreciation while creating an OTBI report?Summary: Hi All, Thank you in advance for your help. Kindly note the below: While creating an OTBI report for the depreciation of the FA, I selected several subjects in …