OTBI
Discussion List
-
Custom lookups in OTBISummary: We have created a custom look up as common lookups and we want to use it in OTBI reports. Please let me know if it is possible or not. If yes, then please guide…Richa Arora-Oracle 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Specific user cant extract data from xla_transaction_entities .Need to Know role for this XLA tableSummary: Specific user can't extract data from xla_transaction_entities .Need to Know role for this XLA table We have made one report where we are using this table but a…
-
How to retrieve Manage Receipts page's "Receipt Date" from subject area?Summary: How to retrieve Manage Receipts page's "Receipt Date" from subject area? Content (please ensure you mask any confidential information): Hi Experts, Would like t…
-
How to keep search panel available when search result shows?Summary: How to keep search panel available when search result shows? Content (please ensure you mask any confidential information): Hi Experts, May I ask how to have th…
-
Calculating Days in Calendar Year on a Suspended StatusSummary: Part of our annual incentive program, we prorate any worker who has been in a Suspended Assignment Status for greater than 90 days in the Calendar Year. Looking…Kayla Malecki 21 views 4 comments 0 points Most recent by Kayla Malecki Reporting and Analytics for HCM
-
Field in OTBI subject area to differentiate Purchase Order schedules which are FirmedWe are creating an Analysis and need an Identifier in Purchase Order Schedule to get the schedules which are Firmed ( Purchase Order schedule → Details → Actions → Firm)…Jith 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
User Should access all Inv Org for the OTBI reports If user is having access for 1 Inventory OrgSummary: Hello We have created an on-hand report for the business, but we need that few user with access with only 1 or few inventory org should also be able to view the…Parth11 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Can anyone help with a report to find potential duplicate employeesSummary: We have Contingent Workers who instead of being re hired as Permanent employees against the CWK record, these are being rehired as new employees creating duplic…Laura_Stewart_Sita 11 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Help in query to retrieve Relationship Criteria on Eligibility Profile for BenefitsSummary: Hello! I am currently biulding an query to get all the Eligibility profiles and their criterias. Currently, I am in need to find the table to give me the relati…Matheus Roberto 34 views 1 comment 0 points Most recent by Thiru-Oracle Benefits-Oracle Reporting and Analytics for HCM -
Which table contains the information from Manage Legal Reporting Unit HCM Information ?Summary: Content (please ensure you mask any confidential information): Which table contains the information from Manage Legal Reporting Unit HCM Information? Version (i…OliveiraRR 41 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How do I do a simple SQL to bring the Name, Legal Entity and registration number of the Legal ReportSummary: Content (please ensure you mask any confidential information): How do I do a simple SQL to bring the Name, Legal Entity and registration number of the Legal Rep…OliveiraRR 201 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Performance Document - Current ApproverSummary Need report for who is the current approver of a perfomance documentContent I have the report which shows the Next Performance task status. Which is great, but i…
-
Issues in creating hyperlink and passing dynamic input parameter from BI Publisher RTF templateDear Team, Pls provide me the list of steps to pass dynamic input parameter in BIP report, We are trying to achieve hyper link as a drill down report, hence we need your…Sabyasachi Mishra 71 views 2 comments 0 points Most recent by Sabyasachi Mishra Reporting & Analytics for Fusion Service
-
help to get SQL query to get the data from tax conditions to Value set valuesSummary: One of our tax determination factors is line account (one of the segments in CoA). We are looking for a report to get CoA values with tax rule name and tax rate…
-
OTBI Agent - Error Generating DocumentI have an OTBI report that I'd like to schedule to run and send the report via email. I've created an Agent to run the report, but when I receive the results via email, …Steven Woods 81 views 3 comments 0 points Most recent by Sridhar_Rejeti_1423 Reporting and Analytics for ERP
-
Historic Grade Steps in OTBISummary: I can see a previous grade step and current grade step using the screens, I wish to see the same information using OTBI. Content (required): When I create an An…ScottHillier 101 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Subject areas lacks in Actual quantity usage for resources an componentsSummary: Hello, I need obtain the input work order cost as report using analysis For example, into operation 10, I used the item E010281 with a total cost of 2,768.379 p…Diego Zegarra 21 views 2 comments 6 points Most recent by Manikandan S R-Support Oracle-Oracle Costing -
Analysis report to exclude the individual on extended leave from recertificationSummary: Hi All, Has anyone created an analysis report to exclude the individuals on extended leave from recertification. Thanks, Jyothi Content (please ensure you mask …
-
How to add lead notes to a reportSummary: We need to add in a report through of subject areas the notes that are recorded on the leads Content (required): How can we add the notes that are related to th…SERGIO BARRETO 51 views 4 comments 2 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales -
GL_FRC_REPORTS_B and Custom Folder and Report ListSummary GL_FRC_REPORTS_B is not listing all the reports that are created or modified; Should we run a process to populate the table or does the data in the table gets po…
-
Create Deep Link for receipt attachment in the Oracle Fusin OTBI Expense ReportSummary: One of our customers is expecting us to add Receipt attachment Deep link to the Oracle Fusin OTBI Expense Report Content (please ensure you mask any confidentia…Shashikanth Kumar P-Oracle 131 views 3 comments 0 points Most recent by Baskar.Chakravarthi Payables, Payments & Cash Management
-
Unable to view the Export option while accessing the OTBI report via infoletsSummary Unable to view the Export option while accessing the OTBI report via infoletsContent Hi Guys, I had created the independent OTBI Report with the report links and…SandeepPaspunuri 268 views 6 comments 0 points Most recent by Thiakeswaraa Reporting and Analytics for ERP -
How to keep searching panel available on the screen?Summary: How to keep searching panel available on the screen? Content (please ensure you mask any confidential information): Hi Experts, Would like to reach out to you o…
-
How is the Assignment manager List Unsecured populated in OTBI?Summary: I am executing the standard OTBI analysis "Headcount KPI - Female Managers" and I am getting a wrong number of female managers. How is it working? We have 13 fe…B Casla 101 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Projected start date field in OTBI showing incorrect valueThe Projected Start Date in the OTBI Recruiting Real Time subject area doesn't appear to be pulling accurate data. We tried changing time zones but at the end of the day…Vaishnavi Katiyar 71 views 5 comments 0 points Most recent by Chantel Berger Reporting and Analytics for HCM