OTBI
Discussion List
-
OTBI - SUBTOTALSummary: Is there a way to show only the subtotal in OTBI? Content (please ensure you mask any confidential information): Version (include the version you are using, if … -
What subject area or field to display the corrected amount for Service POs in OTBISummary: We are using the subject area Receiving - Purchase Receipts Real Time to display PO Receipt information. We are using the field Receipt Amount to display the am… -
LOV not displaying any values in OTBI promptSummary: Hi, I am creating prompts in OTBI for AP module and while creating prompts for 'Invoice created by username', 'Approver', 'Invoice Source' columns, the list of …
-
Restricting Person Type LOV on Line Manager Dashboard Without CustomizationWe are currently exploring options to restrict certain values from the Person Type LOV that appears on the Line Manager Dashboard. Since the Person Type Lookup is a syst…Shubham Kadam 11 views 3 comments 0 points Most recent by Shubham Kadam Reporting and Analytics for ERP
-
Can an OTBI report have a sub-total lines?Summary: I have created an LD Schedule OTBI report where I need to insert a sub-total by Employee the percentage of effort. Can someone share how I can add that in the A…Cris_Yee_Allenite 143 views 2 comments 0 points Most recent by Regie Mercado Reporting and Analytics for ERP -
Combine multiple Ethnicities in OTBI "Two or more races"Summary: Per the below - we have some Team Members that classify with more than one Ethnicity and the "Two or more race" option is no longer available in Oracle. This is…THawkins_LGI 221 views 16 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Change to absence start or end date - event level reportingSummary: We have a requirement to report on changes to absence start and end dates i.e. when someone edits an existing absence. The OTBI Subject Areas are all Real Time …Amanda Hope 21 views 3 comments 0 points Most recent by Shivam Trivedi-Oracle Reporting and Analytics for HCM
-
Renamed position reportSummary: Hi, We have a requirement to report on changes to employees positions, which is fine but we have an issue when the Position name itself has been updated and the… -
While running an Analysis, we dont see any results for Expense Manger/Employee Supervisor name ?Summary:While running an Analysis, we dont see any results for Expense Manger/Employee Supervisor name which i impacting the Manager field dropdwon values of our Expense… -
Need SQL Query to find Baselined Project Budget VersionSummary: Hi Please help us to query baselined project budget version by sql query. I want to find the Project Number, Version, Revenue Budget, and Cost Budget. Our expec…
-
How to eliminate duplicate measure after joining 2 OTBI subject areaSummary: Hi all, I have a report with 2 subject areas (HCM and Projects) Is there a way to show for highlighted values 8, instead on 40 reported hours? Basically is the …Raluca Balan-Oracle 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
custom email - how to add a link to access the systemSummary: Hi all, I would like to create a custom email. in the text of this email I would like to insert a link to access the system. in particular, I would like to inse…Alessandro Nesi 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Subject Area: Payroll - Personal Payment Details Real TimeHello, Could anyone help or confirm if the Subject Area: Payroll - Personal payment details real time can extract the Account Suffix for our Personal Payment Method? Cou…
-
Learner’s Score for Assessment Second AttemptHello Experts, I would like to ask where I can view a learner’s score for a second attempt at a learning assessment. Is this information stored in the database, and if s…
-
Looking for PO Receipt Number and related data in OTBISummary Cannot find PO Receipt Number, Receipt Date and related date in OTBI Subject Area: Procurement: Procure to Pay Real TimeContent Cannot find PO Receipt Number, Re…Rona Jeongco 728 views 14 comments 0 points Most recent by Scott at Denovo Reporting and Analytics for ERP
-
Error on opening View PDF`Summary: Error on opening View PDF for a change order in Pending Approval status Content (please ensure you mask any confidential information): Error on opening View PDF…
-
Seeded Process/Report/Data Model customizationSummary: Once we did customization of seeded Process/Report/Data Model, after applied any patch/upgrade then the customization changes will override. Content (please ens…
-
SQL for all roles and it's inherited roles for BIP.Summary: Hi, I have a requirement to create a BIP report to fetch the details of all Roles and its inherited roles. I have seen that it can be achieved by OTBI but can't…Sameer Khan 29 12 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
OTBI 条件分岐Summary: I want to implement conditional branching in OTBI. What operations are required to achieve this? Content (please ensure you mask any confidential information): …
-
Seeking clarification on the required user context for running the Process Learning Records job.Summary: Previously, a terminated employee was used as the “Run As” user for several learning initiatives, and assignments were no longer processed after their terminati…
-
BIP Vs OTBI What is the practicality of moving BIP reports to OTBI?Summary: I am recommending that my client investigates the possibility of using OTBI in preference to BIP for their reports (including whether this is just for new repor… -
Does any OTBI subject area have these payroll schedule related columns?Do we have any OTBI subject area where we can fetch these columns? Period Schedule Name, Period Schedule ID, Usage, Frequency, Period Start Date, Period End Date, Paymen…MeghnaDe 11 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Can we filter data using values from two columns?Summary: To obtain the data using values from two different columns. Content (please ensure you mask any confidential information): I am working with Workforce Managemen…Pranav Waichal 21 views 5 comments 0 points Most recent by Pranav Waichal Reporting and Analytics for HCM -
Completed Quantity in One columnSummary: Completed Quantity in One column Content (please ensure you mask any confidential information): Hi, We have a requirement to add an completed quantity of work o…
-
Why is "Compensation - Salary Details Real Time" so slowSummary: We have an employee roster/list that uses "Compensation - Salary Details Real Time" If we use 3 columns from that subject area (pairing with Person Seniority an…Monique 42 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Which subject area can I use for procurement contract agreement deliverablesSummary: Which subject area can I use for procurement contract agreement deliverables? Content (please ensure you mask any confidential information): Version (include th…Cindi Jacobsen 31 views 4 comments 0 points Most recent by Yahya Khan Reporting and Analytics for ERP
-
Request SQL to Extract All Agent Configuration DetailsHi Team, We would like assistance in building a SQL query that retrieves complete Agent configuration details from the backend tables in Oracle Fusion. Currently, we can…Gulab_Ansari 56 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
Workforce Goals - Goal Tasks Real Time 'Development Goal.description same as 'Task Name.description'Creating a simple analysis to report each development goal along with it's associated task(s) by using the Workforce Goals - Goal Tasks Real Time subject area. The 'Deve…
-
How can we convert CLOB datatype to string in OTBI Reports?Hello, We are trying to remove HTML tags from a CLOB datatype column in OTBI report by using Substring and Replace function in the analysis. This is resulting us to get …Vaishnavi Katiyar 41 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Unable to see goals under approval/in draft in OTBI ReportsSummary We are not able to get the data for goals awaiting approval or in draft state using Workforce Management - Goal status overview real time Subject Area.Content Hi…Mohit Gupta-45440 223 views 18 comments 1 point Most recent by andywuwuwuwu Reporting and Analytics for HCM