OTBI
Discussion List
-
Key Flexfield Segments Not Appearing in OTBI Subject Area "Budgetary Control - Balances Real TimeDear all, I am writing to request assistance with Key Flexfield structures and their visibility in Oracle Transactional Business Intelligence (OTBI). Issue: I have creat… -
Journey Template reportSummary: Does anyone have a sample of a report that pulls all the configuration details related to a journey template? Content (please ensure you mask any confidential i…Shanna Oppenheim 1 view 0 comments 0 points Started by Shanna Oppenheim Reporting and Analytics for HCM -
In OTBI Multiple home email address to show in Single columnSummary: In OTBI, there is a requirement to display multiple home email addresses in a single column. In my case, two home email addresses need to appear in separate col…Shubham Kadam 31 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
How to Refresh this analytics view MSC_ANALYTIC_FACT_ORD_V in Oracle fusion cloudSummary: Hi, We have created a custom report based on the analytics view MSC_ANALYTIC_FACT_ORD_V, however not all the plan records are retunred in this view. What proces…Gurujothi D 11 views 1 comment 0 points Most recent by Sebastian Thomas Supply Chain Planning and Collaboration
-
Changes to expense approval template does not reflect after 24hoursHi all, We have a requirement to modify expense approval template to add the account number to show up on the email notifications. To achieve this, I have modified the '…
-
Tools for generating the Income Statements and Balance Sheet “out of the box"Is there any tool provided by Oracle for generating the Income Statements and Balance Sheet “out of the box”. If FRS is going to be sunset ->is there a tool already in t…twinkle talreja 11 views 0 comments 0 points Started by twinkle talreja Reporting and Analytics for ERP
-
OTBI Analysis Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversionHello, I'm getting the error in my OTBI Analysis: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion when I add a column Called "Requirement Text" fr…JessSantos 21 views 7 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
How to display different email address types in separate columnsSummary: We have a requirement to display separate columns for work email address and home email address, one row of data per employee. Content (required): From reading …User_2025-01-29-23-50-34-285 61 views 10 comments 1 point Most recent by Shubham Kadam Reporting and Analytics for HCM -
In OTBI-Whr to find the Approval Pending with /submitted by/submitted date info in job RequisitionSummary: I am trying to create a pending Job requisition OTBI report, in the subject area Recruiting - Recruiting real time with the requirement in adding information re…Sankaran Lakshminarayanan 1 view 2 comments 1 point Most recent by Venkat Vatikuti Reporting and Analytics for HCM
-
Query for Approval DelegationContent Hello, I am looking to build a BIP Report which displays whenever someone has delegated approvals to someone of a lower job level - does anyone know where this i…Elliot Hall-Walker 323 views 4 comments 1 point Most recent by SR_1234 Reporting and Analytics for ERP
-
line manager DashboardSummary: In Line manager dashboard, we are getting head count from "Workforce Management - Worker Assignment Real Time" subject area. I am able to see all records in thi…Niharika123 231 views 17 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Check format using oraMICR fontSummary: Check format using oraMICR font Content (please ensure you mask any confidential information): Hello, I am implementing a check format for JP Morgan's payables …MARIANA25 221 views 8 comments 0 points Most recent by User_MK9VL Payables, Payments & Cash Management -
User is unable to see distribution details for more than 30 lines in this sandbox through UIA sandbox is created to fetch and display Invoice distribution Lines. This distribution tab is created on the invoice inquiry screen on UI by calling a OTBI. OTBI is abl…Sifat Shaikh 11 views 0 comments 0 points Started by Sifat Shaikh Payables, Payments & Cash Management
-
OTBI Analysis filter by max date valuesSummary I want to filter a subject area, where I get only the max date, as the record is duplicated for different datesContent How to do below in OTBI Analysis, Data Set…
-
Need Report to show Change Details of a BPA Change OrderSummary: Looking for a report to see what details were changed in a BPA or PO Change order. Please advise if there is any OTBI report or table to create BIP report. we c…
-
Poor Query Performance of CMP_ASG_SALARY_VSummary: A simple query on this view runs 40+ minutes. We are experiencing poor performance with the CMP_ASG_SALARY_V HCM view. When doing a simple SELECT statement with…
-
Participant Feedback Report including feedback from 360 performance - need helpSummary: Hi there, hoping someone could help me out: This report using Subject Area: Workforce Performance - Requested Feedback Real Time does not include the participan…
-
OTBI agent More Details - success?Some OTBI Agents More Details read: "Last Run 09/12/2025 8:00 AM GMT+00:00 | Agent Successful | Next Run 10/12/2025 8:00 AM GMT+00:00". Other agent More Details read "La…
-
Asset end date OTBISummary: Which subject area can tell me which maintenance asset is end-dated or not? I'm troubleshooting for PMs that don't generate forecast and realize some were becau…
-
How to get the USER_NAME or USERID into default value of a data model parameterSummary: How to get the USER_NAME or USERID (or exquivalent) into default value of a data model free form string parameter Content (required): In a data model I would li…Jbgood 2K views 5 comments 3 points Most recent by Humberto Martín-Oracle Reporting and Analytics for HCM
-
How to create report that show item's list price update historyI can check list price update history of each item by doing the following step: Navigator: Product management > manage items 1. Search item number 2. Click on item numbe…
-
OTBI - Customer Credit - Last Review Date / Next Review Date Missing?Hello, We are looking to pull the Last Review Date and Next Review Date areas of the customer account profile history to an OTBI report. I cannot locate these fields to …
-
How to create a report/Analysis to show Receipts pending for Put AwaySummary: How to create a report/Analysis to show Receipts pending for Put Away Content (required): Version (include the version you are using, if applicable): 23A Code S…
-
Infolets Receipt line: need to extract the querySummary: I need to extract the query under the infolets "Receipt Lines". Is it possible? Otherwise, how can I extract the lines in awaiting receipt, awaiting inspection …Giuseppe Galluzzo 151 views 8 comments 0 points Most recent by Kunal Verma Reporting and Analytics for SCM
-
Project Class Category Causes Duplicate Rows for Project Financial Information in OTBI and BI PUBSummary: When we want to report on the Project Classifications class categories for a project number there is no clean way to do it. The current solution we are doing re…
-
Lease Accounting SetupSummary Lease Accounting SetupContent I was following the steps to enable "Create Property and Equipment Lease" below, however when I go to Setup>Financials . I am not s…
-
HCM alerts real time Subject Area - data not returningSummary: HCM alerts real time Subject Area - data not returning Content (please ensure you mask any confidential information): Hello I am trying to write an Analysis usi…
-
what is the equivalent table in Oracle fusion for wf_notification table in EBSSummary: We are looking to build a report to get approval details of delegated approvals . E.g: Workflow type, original approver , approved by , Approval Date Etc. Conte…