OTBI
Discussion List
-
Subject Area to get details related to Maintenance Work definitionSummary: We try to create an analysis in Maintenance module to capture the Maintenance program with Work definition and operations and materials required for the Work or… -
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…VDM_IM 14 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM -
Apex to run bi reports and store files in DB tableSummary: We need Apex to call a SaaS BI Report and store the file report in a DB table. Content (please ensure you mask any confidential information): We need Apex to sc…
-
"Add to Favorites" is not working as expected for OTBI reportsSummary: Hi When I add a OTBI report(having input parameters) to Favorites, the output resulting from favorite displays the output without asking for input parameters. I…Naga Varma 111 views 6 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for SCM
-
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 &…
-
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…
-
How to Join 'Inventory - Inventory Transactions Real Time' & 'Shipping Real Time' subject areaSummary: Hi Gurus, We are trying to build a report which show the Inventory Transcations with the 'Waybill Number' & 'Tracking Number' field. So is there a way to join t…Amrish_Amradkar 1 view 0 comments 0 points Started by Amrish_Amradkar Reporting and Analytics for SCM
-
while creating the custom roles, getting unwanted subject areas in analysisSummary: Hello Experts, Our client has a requirement to create a custom role for restricted access to business users. While doing so, we could see in reports and analyti…Balaji Midhun Kumar Sanagapalli 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
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 11 views 2 comments 0 points Most recent by Harish Vashist Reporting and Analytics for SCM
-
Create OTBI analysis for Procurement Contracts based on Logged In userSummary Want to Create OTBI analysis for Procurement Contracts based on Logged In user Content (please ensure you mask any confidential information): We need to create a…
-
Restrict "Edit" function on OTBISummary: Restrict "Edit" function on OTBI Content (please ensure you mask any confidential information): Hi Experts, I got this question that I am not able to restrict e…
-
Receiving - Purchase Receipts Real Time - Returns no results when adding Amount columnsSummary: In OTBI, when adding in any purchase receipt line columns returns No Results. This has only happened after 24D, any suggestions? We have the correct Warehouse M…Steve Stovell 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
The supply plan tables could be printed in BI report?Summary: Hello, I have a custom table for supply planning, I need a BI report to print data generated into the table for the 3 measures per period while is filtering by …DIEGXDNXP 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM -
How can I add suggested start date of a maintenance program generated work order to an OTBI report.?Summary: I am trying to add the suggested start data of a work order to an OTBI report. Work orders that are created by maintenance programs have a suggested start date.…Phillip_Shearer 1 view 1 comment 0 points Most recent by Ezra Anderson Reporting and Analytics for SCM
-
Configure Prompt acting like a nested query?Summary: How to configure Prompt acting like a nested query? Content (please ensure you mask any confidential information): Hi Experts, Would like to reach out to you to…Liwen Chiu 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to keep search panel available when search result shows?Summary: How to keep search panel available when search result shows? Content (please ensure you mask any confidential information): Hi Experts, May I ask how to have th…
-
Field in OTBI subject area to differentiate Purchase Order schedules which are FirmedWe are creating an Analysis and need an Identifier in Purchase Order Schedule to get the schedules which are Firmed ( Purchase Order schedule → Details → Actions → Firm)…Jith 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
User Should access all Inv Org for the OTBI reports If user is having access for 1 Inventory OrgSummary: Hello We have created an on-hand report for the business, but we need that few user with access with only 1 or few inventory org should also be able to view the…User_T1DN7 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Requisition Unprocessed daysSummary: Difference between OTBI Requisition- Unprocessed days in Line detail and Unprocessed days in the Line folder Content (please ensure you mask any confidential in…Rajesh7d 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
I need sql query for Consumed Allocation in GOP Review Supply AllocationSummary: I need sql query for Consumed Allocation in GOP Review Supply Allocation to create a BIP report Content (required): Business requirement to prepare a report tha…
-
Usage of Prompt's "contains any" for both upper case and lower caseSummary: Usage of Prompt's "contains any" for both upper case and lower case Content (please ensure you mask any confidential information): Hi Experts, I am using subjec…
-
Prompt LOV restriction in OTBI according to user Business unit data accessSummary: We are trying to restrict the prompt LOV which returns BU names that currency configured in the system. But we want that when a particular user will try to run …Baishakhi 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Tables/View for Item and Asset Category to PO categoriesSummary: Tables/View for Item and Asset Category to PO categories Content (please ensure you mask any confidential information): Hi Experts, Would like to reach out to y…
-
Supplier Address Level Tax Classification CodeSummary: We are trying to determine the Tax classification code field at Supplier Address level in OTBI analysis Content (please ensure you mask any confidential informa…Jithendra_MG 11 views 2 comments 0 points Most recent by Jithendra_MG Reporting and Analytics for SCM -
No data displayed in Goods Received not Invoiced ReportSummary: Hi, I am using seeded OTBI Report 'Goods Received not Invoiced Report' and made a custom report with the same subject area i.e. Costing- Receipt Accounting Real…Vijayalakshmi Matcha - Oracle-Oracle 421 views 3 comments 0 points Most recent by Duygu Coskun Reporting and Analytics for SCM
-
How to develop a BIP / OTBI report to fetch details from VBCS pageSummary: Hi Team, We have a customized VBCS page for Inventory transactions. Our requirement is to develop a BIP / OTBI report to fetch details from the VBCS page. Is it…Dhilip Kumar P. 21 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Can you please help me to find parent reports for the below OTBI child reports?Can you please help me to find parent reports for the below OTBI child reports? Past Due Fulfillment Lines Report Sales Order E-mail Sales Order Line Status Update Sales…User_SIV20 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to get original or first requisition approved dateHi! I need to get the first or original requisition approval date for a report. How do I get it? The field Requisition Approval Date shows the latest/recent approval dat…Jose Renato Salvador 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Query to get payment method field in Order Management in Oracle FusionContent Hi all, Can someone tell me from where I could pick the payment method field mentioned at the front end of the Order management page? I have checked for the tabl…Sushan Peiris 993 views 2 comments 4 points Most recent by Shishir Dhone Reporting and Analytics for SCM -
How to remove the restriction preventing a user from accessing data within an OTBI report.Summary: I have a dashboard containing multiple reports. While the user can access some of these reports, others display errors such as "view error" or "error getting dr…Omran Zeaiter 41 views 4 comments 0 points Most recent by RyanPasca1 Reporting and Analytics for SCM