OTBI
Discussion List
-
Has anyone been able to edit seeded data model that uses XML file as a dataset instead of sql query?Summary: I need to edit the Electronic Record for Ship Confirm Report to include custom data. The data model for this report uses an XML file as a dataset instead of an …ajudge 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
How to export three reports output into a single pageHi Team, I have merged three reports into a single page. Out of the three, two are OTBI reports & one is a BIP report. When I am trying to export data, only two OTBI rep…
-
Fixed asset YTD deprecation Value IssueIn Fixed Assets, the depreciation data displayed in the application is different from the data stored in the Oracle database tables (FA_DEPRN_SUMMARY and FA_DEPRN_DETAIL…
-
Account Analysis Drill down -Subledger-Real TimeSummary: The requirement is to have all the transactions (Invoices/Credit Memo's) listed in tabular form once we click on particular balance sheet account for the period…Kinjal Patel-Oracle 30 views 2 comments 4 points Most recent by Kinjal Patel-Oracle Reporting & Analytics for Fusion Service
-
Print Receivables Transactions but don't emailSummary: Hello, We want to be able to run the aforementioned request but rather than have email the documents out, simply generate a PDF document. I know that we can rec… -
Looking for the PVO that exposes the ATTRIBUTE_CHAR12 column from the DOO_HEADERS_EFF_B tableLooking for the PVO that exposes the ATTRIBUTE_CHAR12 column from the DOO_HEADERS_EFF_B table in Oracle fusion. We need this for DA in FDI.
-
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 Most recent 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
-
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 Most recent 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 23 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 334 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 251 views 17 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
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…Fahad Cader 745 views 10 comments 0 points Most recent by Yandini Mootoosamy Reporting and Analytics for ERP
-
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…
-
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…Stephen Jones 13 views 0 comments 0 points Most recent by Stephen Jones Reporting and Analytics for HCM
-
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 2.3K 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 163 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…
-
Visualization Configurator isn't displaying the correct dataHello, I’m experiencing an issue with the Visualization Configurator not displaying the correct data. I created a visualization using source data from OTBI, but the sele…