OTBI
Discussion List
-
Operation Status columnSummary: Operation Status column Content (please ensure you mask any confidential information): Hi, On which Manufacturing subject area I can find operation status (Read…
-
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…
-
Context PO DFF does not appear in OTBI - PO real time subject areaSummary: We have a context DFF at the PO Header, and I am unable to see those DFF's in the OTBI Report (Procurement- PO Real Time). Is there any way to allow the OTBI so…diego m schenquerman 5 views 0 comments 0 points Started by diego m schenquerman Reporting and Analytics for SCM
-
Issue with Tax Amount Display in OTBI Line ItemsSummary: Merge Tax line of receipt Content (please ensure you mask any confidential information): Hi, We need to include the tax amount on a single line. Currently, in O…
-
Query to Derive Budget information for a purchase orderSummary: Looking for a query to derive Budget information(below highlighted columns) for a purchase order from the below screen,i.e Budget Account ,Budget Period and con…Ripendra Kumar-Oracle 561 views 3 comments 0 points Most recent by Mirza_Adeel Reporting and Analytics for SCM
-
LSQL print first valueSummary: Moved to SCM Reporting and analyticsVDM_IM 12 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to print all lines returned in dashboard from analysis in a PDF print format or PDF export?Summary: I created an analysis, embeded in a Dashboard. I also created a Report under Print & export options in the section Custom Print & Export Layouts. I added date &…VDM_IM 14 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Custom dashboard -How to provide link/details to export based on graph/chartSummary: Custom dashboard -How to provide link/details to export based on graph/chart Content (please ensure you mask any confidential information): we created custom da…
-
Approval Hierarchy and Position Tree ReportHi everyone, I'm looking to build a report that includes approval hierarchies based on position trees defined in the Manage Position Trees setup, along with the related …
-
Can we fetch tax classification code using subject areas under supplier address levelHi , We are trying to add tax classification field in otbi report using subject area Supplier - Supplier Real Time, we can get the details of tax classification code und…
-
Not able fetch data from Catalog Category Hierarchy using OTBISummary: Not able fetch data from Catalog Category Hierarchy using OTBI Content (please ensure you mask any confidential information): We are not able to fetch the data …Harish Vashist 23 views 7 comments 0 points Most recent by Swathikamburath Reporting and Analytics for SCM
-
Work Order DFF not visible in OTBI Subject AreaSummary: Work Order DFFs are not visible in OTBI Subject Area We have run the process "Import Oracle Fusion Data Extensions for Transactional Business Intelligence" also…
-
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheet Content This spreadsheet is published by Oracle OTBI Development. Release: 25B…Ramamurthy Shankarachetty-Oracle 16.9K views 54 comments 44 points Most recent by Kirk Li Reporting and Analytics for SCM
-
Column for reject/return reason for PO/ Requisition in OTBI Subject AreasSummary: Column for reject/return reason for PO/ Requisition in OTBI Subject Areas Content (please ensure you mask any confidential information): Hi Team, We are searchi…Nidhi Chhajed 3 views 1 comment 0 points Most recent by Nidhi Chhajed Reporting and Analytics for SCM
-
How to access smart form name in OTBI?Hello Oracle gurus, Our business uses a DFF in procurement at requisition line level. We have now upgraded to Redwood applications and are using smart forms and the DFF …
-
How to find the path for OTBI behind seeded infolets in Oracle?Hello, There is a seeded inventory dashboard in Oracle fusion, On-Hand value. I am trying to understand how to get to the actual OTBI it is invoking to get this data. I …
-
Maintenance Work Order Cost OTBI Subject AreaWhere can i find Subject Area for Maintenance Work Order Cost, I am using Costing Subject area but it only shows Manufacturing Work orders. Please help
-
Print Page Number of Total PagesSummary: Case 1: In an analysis, how to print Page # of total pages? Case 2: Same analysis embedded in a Dashboard, how to print all lines from the analysis in PDF forma…
-
Is there a function accepted in OTBI to print FIRST ROW of values?Summary: Summary: I would like to Print all Invited Suppliers and selected Sites with site adress and site email but if Contact is blank in Negociation, only print first…
-
Deep Link to view the Purcahse Order details from OTBI report is not workingSummary: Deep Link to view the Purcahse Order details from OTBI report is opening a PO Web page but the page is blank Content (please ensure you mask any confidential in…
-
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 57 views 5 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for SCM
-
Need to have Inventory Location details in the OTBi reportSummary: Hello, We have a requirement where we need to have all the Location Name, Code and ID in one of the report. But I am umable to find it in the Inventory subject …Krupesh Joshi 16 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
we need to modify the "reply to" on the dashboards and analysis that we send via emailSummary: We have different dashboards or emails that are sent via email to different users. However we want the users to be able to "reply" to any of those emails and th…
-
Cannot select attributes from 2 different folders in same Subject AreaSummary: I select "- Negotiation Header Detail"."Negotiation Number" and "- Supplier List Detail"."Trading Partner Id", 2 columns from same Subject Area and 2 different …VDM_IM 22 views 3 comments 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
What is the OTBI item for "Organization" (under PO schedules)?We are trying to create a report that pulls the Ship-to location, PO number, and receiving organization (see above) to see where we have mismatching values (Ex: NATHW sh…
-
Presentation variable based on another presentation variableSummary: I would like to print the Negotiation Title of the selected Negotiation Number in the Header. I have the Negotiation number in a presentation variable (pb_negot…VDM_IM 2 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Custom Subject Area Primary Objects for ERP and SCM CloudSummary: What are the Primary Objects that we are supposed to have access to? I am looking at creating a Custom SA for Sourcing Responses. I only see the following: Cont…
-
Error: SQL query time exceeds the limit(500 sec). Stopped processingSummary Error: SQL query time exceeds the limit(500 sec). Stopped processingContent Hi All, Error: SQL query time exceeds the limit(500 sec). Stopped processing. I am un…Devendra Thota-220620 1.7K views 8 comments 4 points Most recent by Shyam Patel Reporting and Analytics for SCM
-
How to insert Linefeed or carriage return between two Attributes?Summary: I would like to concatenate 2 attributes and have the second attribute print on the next line. This formula doesn't achieve that: "- Negotiation Header Detail".…
-
How to get Node name and description from Manage Account Hierarchies: Specify NodesSummary: I need to get this value for a report, someone knows in which table this information is? Content (please ensure you mask any confidential information): Version …Diego Zegarra 24 views 1 comment 7 points Most recent by veerendranath pulivarthi-Oracle General Ledger & Intercompany