OTBI
Discussion List
-
User Account Details (Email Address) in Security ConsoleSummary Need table names to be able to pull email address kept in Security ConsoleContent Hi All, I am struggling to find and link tables to pull User Account Email Addr…User_2025-01-28-05-11-13-165 859 views 11 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Fixed Assets ReportSummary: We need a report in Fixed Assets Module which shows the beginning balances for the selected company and year in the parameter and then multiple columns showing … -
Maximum report data size for offline (scheduled) reports value changeSummary: Maximum report data size for offline (scheduled) reports value change Content (please ensure you mask any confidential information): Hi Team, Greetings! How do …Parag Hiremath 21 views 3 comments 0 points Most recent by MitG-Oracle Reporting and Analytics for HCM -
We need to display the Tax Rate value of the Purchase Order line in OTBI.Summary: We need to display the Tax Rate value of the Purchase Order line in OTBI. So, we need to find out the subject area that we can create OTBI and display the value…
-
Transportation intelligent Global Currency not working as per expectationFor Shipments without Rate offering id, global currencies are not converting the cost to the assigned currency, and feeding the data to Transportation Intelligent. But t…ZeenathMafitha 21 views 3 comments 0 points Most recent by Narayana Rangollu Transportation Management
-
I need to create an analytic in OTBI To identify what work schedule is assigned to employeesI am trying to create a simple analytic in OTBI to show all employee names, their assignment numbers and the names of the assigned Work Schedule for each assignment. It …Peter Downer 15 views 4 comments 0 points Most recent by Peter Downer Reporting and Analytics for HCM
-
Need a SQL query to find the names of the procurement & requisitioning business units on a PO.Hi Team, I need a SQL query to find the names of the procurement & requisitioning business units on a PO. The output of the query will have the following columns, someth…
-
Procurement Dashboard not showing amounts in ledger currency USDHi, We are using the standard procurement dashboards "Procure to Pay." Our ledger functional currency is USD; however, we have observed that the values displayed in the … -
PRJ: How to enable the Manage Project Cost DashboardDear Team, Can you please advise how to enable below dashboard. Regards Prashant
-
How to confirm PGP enabled report output is delivered with encryption on SFTP without checkingSummary: Is a way to confirm PGP enabled report output is delivered with encryption on SFTP without checking SFTP server Content (please ensure you mask any confidential… -
Need SQL QUERY for PPR details along with terminated status with no installments and stageNeed SQL query for PAYMENT PROCESS REQUEST details in oracle fusion cloud along with terminated batches where status='no available installments'Renuka Chougule 341 views 3 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Which table can I use to extract the Award Approved Date for each RFQ?Which table can I use to extract the Award Approved Date for each RFQ?
-
BI Report: multiple filters return no results but when filters used individually returns recordsSummary: I have a BI report relating to Opportunities. I'm using 3 subject areas and one is a custom subject area, a group initiative that allows us to group opportuniti…Tonya H 42 views 3 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
BIP Report to list all Custom ReportsSummary BIP Report to list all Custom Reports.Content Ho to fetch list of all custom reports from cloud instance (Oracle Cloud SaaS). I know how to fetch them from BIP A…Amarnath 2.4K views 9 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
What OTBI subject area provides PO receipt data when Inventory Management module isn't used at all?Summary: We use Procurement Cloud and create receipts for our purchase orders. However, we don't use the Inventory Management module at all. Our receipts are specific to…
-
organization seniority date on multiple contractsSummary: How can I report on the Org Seniority Date when person has more than 1 contract Content (please ensure you mask any confidential information): Hello Has anyone … -
Can i get a list of reports from Catalog in OTBI?Summary A client has requested a report showing names and location of all reports available in OTBI (including custom reports). How can i get such a report? Content (ple…
-
Beginning Balances for a few Entities (Segment1 from GL) is not there in FA_BALANCES_EXTRACT TableBeginning Balances for a few Entities (Segment1 from GL_CODE_COMBINATIONS) is not there in FA_BALANCES_EXTRACT Table when we filter on basis on those entities we aren't …
-
Procure-to-Pay RT subject area - approver nameSummary Procure-to-Pay RT subject area - approver nameContent I am attempting to update my existing P-to-P reports to leverage the P-to-P RT subject area; this subject a… -
Is there an ability of showing on the UI the date of the last time an account combination was used ?Hi Team, I was informed that on prem Oracle used to have the ability of showing on the UI the date of the last time an account combination was used, similarly is this po…Baskara Sateesh-Oracle 11 views 2 comments 0 points Most recent by Vsugandh14 General Ledger & Intercompany
-
Making Role-Specific Custom InfoletsWe’re working on implementing custom infolets in Oracle Fusion and are particularly interested in making them role-specific—so that only users with relevant roles see th…
-
Report for Work Order VariancesSummary: Content (required): Client is looking for a report where they can see the split up of total variance cost. At distribution level system sums up variance cost (E…
-
Instruction: Add a (DFF) to a specific Value Set for additional COA attributesSummary Add a context sensitive DFF to a value set (COA)Content One of the requirements for my organization was to add DFF's to the value sets of our chart of accounts, …Bobby Choate 359 views 4 comments 3 points Most recent by Jakee_Agarwal-Oracle General Ledger & Intercompany -
Add custom font to OTBI reportsSummary Can we add custom fonts to OTBI reports?Content I did upload a ttf file and created font mapping in Administration page but the font is not reflected in the OTBI… -
Subledger Accounting-Journals Real Time Subject area in OTBI not showing Supporting Reference DataSummary: From the "Subledger Accounting - Journals Real Time" subject area in OTBI, we are not able to pull actual data in any of the Supporting Reference 31 to 60 colum…Jay Chandran 84 views 5 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for SCM
-
How can I display user chosen from and to dates in OTBI?Is there way to show the dates a user has selected in the output of the report? Date run can be shown in the title, but I want the user to enter a from and to date and t… -
Pivot table is not working in OTBI report with 2 subject areas, columns are not working properlySummary: Pivot table is not working in OTBI report with 2 subject areas, columns are not working properly as per the pivot table layout. Created a report with subject ar…Elavarasan S 11 views 5 comments 0 points Most recent by Elavarasan S Reporting and Analytics for HCM -
Where can I find HCM Extract user entity to database lineage mapping?Where can I find HCM Extract user entity to database lineage mapping?
-
Overdue Task Report in Journey ChecklistsSummary: Overdue Task Report in Journey Checklists Content (required): Hi All, Greetings! we are trying to check the exact data for the terminated employees with checkli…Parag Hiremath 123 views 13 comments 0 points Most recent by Ashraya_SN-Oracle Reporting and Analytics for HCM