OTBI
Discussion List
-
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… -
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 11 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 13 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 22 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 41 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 55 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 43 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 232 views 18 comments 1 point Most recent by andywuwuwuwu Reporting and Analytics for HCM -
OTBI British Summer Time effecting dates in Payroll - Element Entries History Real TimeSummary: British Summer Time (GMT +1) is producing incorrect results from the date Prompt using Effective Start annd End Dates Content (please ensure you mask any confid…Kevin Robertson 1 view 0 comments 0 points Started by Kevin Robertson Reporting and Analytics for HCM
-
Organization tree OTBISummary: We have an Organization Tree in Fusion HCM where: LE = Top Parent Node Division = Child Node under LE Departments = Child Nodes under that Division LE-->Divisio…charan_Gudla 53 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Missing project and data when reporting from Project- Performance Reporting Real TimeSummary: I am reporting from Project- Performance Reporting Real Time, but some projects (not closed yet) is missing from this data set compeletely.. We have run the Upd…
-
Issue is when we add termination date in two subject areas OTBI reportSummary: Hi Team, when we add the two subject areas it showing correctly but when i adding termination date it showing two rows as below ? one is with termination record…AjayKumar Maddipati 41 views 10 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Add Additional Columns in Review Customer Account Details ScreenSummary: We are looking to create an analysis based on customer account details. This includes information available in the seeded solution for customer accounts, such a…
-
Which Database table stores values entered from custom Editable measure?Summary: We have defined a custom editable measure for use in Supply Planning plans, but not getting the database table which stores the values of that measure entered b…Aishwarya Srivastava 11 views 1 comment 0 points Most recent by Arun K A-Oracle Supply Chain Planning and Collaboration
-
Populating the manager hierarchies for OTBI reportingSummary Provides the steps the populate the various manager hierarchies available in HCM OTBI Content This document provides details on the process that allows the custo…Raghavendra Raghunath-Oracle 1.4K views 14 comments 11 points Most recent by Ruvina Khan Reporting and Analytics for HCM -
Issue Using Two Subject Areas in a Single OTBI Analysis to Bring Budget and End Of The Day Balance.We are trying to build an OTBI analysis that contains Ending balances and End Of The Balance(EOD) related transactions within a period. To achieve this, we are using two…Sri Sai Kiran Tekumudi 21 views 0 comments 0 points Started by Sri Sai Kiran Tekumudi General Ledger & Intercompany
-
OTBI Report with SQL query filterSummary: Hi Team, We have a custom reporting requirement that involves applying complex, SQL-based filters. We are planning to implement this logic within an OTBI report…
-
Why cant we change the credit card charges notification templateSummary: When out visa upload takes place we have activated the automatic notification to be triggered and sent to the credit card holder to tell them they have new tran…
-
I am looking for the tables which stores IExpense item dispute date and dispute commentsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Volume of email notifications by typeSummary: I have a stakeholder who has requested the volume of emails by template sent by HCM to workers by Month. We have BI Burst, Alert Composer, and Seeded Notificati…SusanJ 11 views 2 comments 0 points Most recent by Andre Brown-Support-Oracle Reporting and Analytics for HCM
-
Getting errors UPDATING an Item in a Price List in Bulk using Import Price Lists Batch FBDIWhile trying to UPDATE an existing Price Lists' Items and Charges, getting the following errors: primary_pricing_uom_flag - Only one price list item record can be the pr…
-
Impact of import oracle fusion data extensions for transactional business intelligenceSummary: Hi, Please help us to understand if the program - Import oracle fusion data extensions for transactional business intelligence will impact in any of the current…SwapnilSurange1 42 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Is there an API in Oracle that can extract the OTBI Analysis Criteria XMLSummary: We have lot of OTBI analysis which are being used for Learning initiatives/recommendations. These reports have filters on Organizational levels/Names. Whenever …
-
OTBI Analysis Report – Duplicate Rows Issue Even After Enabling DISTINCTSummary: I am working on an OTBI analysis where I am seeing duplicate rows in the output. For example, the same Person Number and Person Name (e.g., "101 – Ben") is repe…Manoj Muddineni 75 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM