OTBI
Discussion List
-
Latest data changes are not reflecting in the OTBI report immediatelySummary: Hello All, We have an AOR drill-down OTBI report, but the latest changes to data are not reflecting immediately. For example, when we assign an AOR to an employ…Nusrat Shaheen 91 views 8 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Blank Specialization Sections and Activities from Workforce Learning - Learning Records Real Time.Summary: When using the Workforce Learning - Learning Records Real Time Subject Area we are getting Blank values for the Specialization Sections and Activities. We are u…David Bean - BW 91 views 7 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Workforce Learning - Learning records Real time returns no dataSummary: Workforce Learning - Learning records Real time returns no data Content (please ensure you mask any confidential information): Hello I am trying to build a repo…
-
OTBI Data access for userHi, We have a few queries regarding OTBI data access behavior. We have a user who is associated as an employee to one Business Unit (BU) under Manage Users. When accessi…
-
issue with the link between gl_code_combinations and ZX_ACCOUNTSSummary: I am creating a report to gather the taxes and all invoices related to this tax. Content (please ensure you mask any confidential information): I used the below…
-
How to get current timezone as of date in server variable CURRENT_DATE_REP_OTBISummary: How to get current time zone as of date in server variable CURRENT_DATE_REP_OTBI. I am trying to get the correct metrics on the headcount dashboard and what i o…Revanth.Rondla 22 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Highlight Duplicate String ValuesSummary: Content (please ensure you mask any confidential information): In an OTBI analysis, I would like to highlight duplicate string values. Is this possible? We're u…
-
BI Publisher Workflow Notification – Show/Hide Fields Based on Logged-In User for NotificationsSummary: Hi, I’d like to know if it’s possible to configure a BI Publisher Workflow Notification to dynamically display or hide certain fields based on conditions relate…Matheus Roberto 31 views 0 comments 0 points Started by Matheus Roberto Reporting and Analytics for HCM -
OTBI - How to link Learning Management & Learning Records Real TimeHello everyone, I am currently working on an OTBI analysis for specific Learning Items. Most of the required data is available in the Workforce Learning – Learning Manag…
-
Table with sales orders in errorSummary: Looking for the tables where it is whether a sales order is in error. And what that error is. Content (please ensure you mask any confidential information): I w…
-
Unable to find the Notes and attachments field in OTBI report - Maintenance Subject AreaSummary: As per the customer requirement, need to get the detailed report for to find the "Notes and Attachments" field (Comments) when adding the Work Order Completion …
-
Request: OTBI Report to Identify Self-Enrollment Courses and OfferingsWe are looking to create an OTBI report that helps to identify self-enrollment courses or offerings within our Oracle Learning system. Currently, the process for self-en…
-
Can't add column prompt in OTBISummary: Hi, I have an analysis with 3 subject areas. For some reason I'm not being able to add a column prompt to my analysis, the only option is to add a Currency prom…
-
Request for Source Tables of Task-Level Cost Columns in Project Financial PlanHello Community, I would like to request clarification regarding the source tables for the following task-level cost columns in the Project Financial Plan (navigation: P…Andika Kurniawan 32 views 4 comments 0 points Most recent by Andy May-Coates-Oracle Project Management
-
Reporting on Payment ApprovalsSummary BI Publisher or OTBI Report to extract Payment ApprovalsContent Hi Community Are there are any BI Publisher or OTBI Reports available to report on Payment Approv…Kunal Daya-175386 200 views 5 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP
-
Deeplink for Review cost accounting distributions drilldownSummary: Hi, we are working to define an OTBI, from Subledger Accounting Real Time are that enables drilldown to Cost Management - Review Cost Accounting Distributions. …Roberto de Santos 11 views 1 comment 0 points Most recent by Manikandan S R-Support Oracle-Oracle Costing -
Can someone please provide underlying sql query for Available To ReserveSummary: Looking for underlying sql query to get "Available to Reserve" and "Available to Transact" qtys on onhand UI. I tried with joining multiple tables and condition…
-
How to add Year to date activity in financial reportSummary: We are creating a financial report where we want to include current period activity and year to date (accumulated activity). How do you suggest that we include …
-
OTBI How to filter column YTDI have a formula-based column that is based on other columns, and a table prompt using Accounting Period Name. I am trying to make this column to show values in Year-To-…
-
Report Data is incorrect because Time zoneHello, we just recently faced an issue related to BI report on absence related data. It will give last one hour updated records of employees absences. (submitted/awaitin…Dara Nagasai 11 views 4 comments 0 points Most recent by Vanitha Kundaram Reporting and Analytics for HCM -
How to change the Currency in Total Price column in "Print Transfer Order Status Report"Hello Experts, We have a client requirement to change the $ to euro symbol in "Total Price" column in "Print Transfer Order Status Report" (Requisition View) Currently w…Balaji Midhun Kumar Sanagapalli 14 views 1 comment 0 points Most recent by Graeme Gerber Inventory Management
-
List of UI Labels effected with User Interface Text tool - renaming of labelsCustomer needs a list of effected UI labels (on pages/modules) when using the User Interface Text tool for renaming labels in Fusion environment. Is there SQL for me to …Sharne Thysse 22 views 4 comments 3 points Most recent by Shaik Azeez Reporting and Analytics for ERP
-
Is the 75000 row limit for OTBI reports just a limit on the output?For an OTBI report, the SQL automatically adds "FETCH FIRST 75001 ROWS ONLY." Is this only referring to the output of the report? Or is it also referring to the total po…
-
Absence Calendar Details Real Time - Reporting on employee absences by daySummary This is a white paper to enable the customers to generate and render worker absences breakdown by day using the absence calendar details real time subject area.C…Raghavendra Raghunath-Oracle 2.1K views 47 comments 13 points Most recent by Visvanath-Oracle Reporting and Analytics for HCM -
Not able to retrieve data from Security - Roles and Privileges Real Time subject area.We are not able to retrieve data from Security - Roles and Privileges Real Time subject area. We are trying to fetch columns from the folder Function Security Policy, Da… -
Guidance Needed: BI Report with After Data Event Trigger in Oracle Fusion HCMSummary: BI Report with After Data Event Trigger in Oracle Fusion HCM Content (please ensure you mask any confidential information): Hello All, We have a requirement to …Vasanthakumar Ravi 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
REST API to get sales Order line tax amountI am looking for Sales order tax amount for each line. In front end i am able to see tax amount for each line. but when I check it through API, I am getting only total t…
-
How increase limit of rows in otbi analysisSummary: How increase limit of rows in otbi analysis Content (required): Customer have some Analysis created and he want to know if there are some possibility to export …Adriana Martins 1.5K views 8 comments 1 point Most recent by SureshRamanujam Receivables & Collections
-
HCM OTBI Filter by Legal Employer of current userSummary: Hi Oracle community, i am fairly new to OTBI specifically in HCM OTBI and would like to check how to achieve in adding analysis filter to get records where lega…JSalarza 163 views 7 comments 0 points Most recent by Challa Ramya-Oracle Reporting and Analytics for HCM