Business Intelligence
Discussion List
-
How to set up Page number in the rtf file to start at page 3 for Contract Terms layout templateSummary: We need to have the page number in the Contract PDF file to start at Page 3. Tried editing the rtf file and set up the Page number to start at 3 but upon checki…Darita Dayaganon 11 views 2 comments 0 points Most recent by Andreea Gel-Support-Oracle Enterprise Contracts -
subscription product pricing- query final price after adjustmentsHow, How do I query (via SQL) the final product price after adjustments? As it is not displayed on the Pricing Tab. I need to create a BIP Report which will show for eac… -
Equivalent reports in fusion for the following EBS reportsSummary: Hi All, Could you please help to find the equivalent reports in fusion for the following EBS reports. 1.All Inventory Value Report 2.Material Account Distributi…
-
Not able to Print Contract Term Clauses in the Custom Report as it's a CLOB and HTML embedded.Here ARTICLE_TEXT is having CLOB select ch.contract_number, cab.label||''||caa.article_title article,fl.meaning,cab.document_id,cv.ARTICLE_TEXT from okc_k_headers_vl ch,…Snehashis_Santra 1 view 1 comment 0 points Most recent by Andrei Ursachel-Support-Oracle Enterprise Contracts
-
Setup problem Can't see the catalog contentIt is not possible to view the category name, nor create it, and we are also unable to extract this information via query. When trying to create the Category name within… -
Supplier Profile Attachments Listing ReportSummary Custom BIP Report displaying supplier profile attachments for recently created suppliersContent This BIP report will show supplier profile attachments added to t…Aishwarya Pawar-Oracle 191 views 7 comments 12 points Most recent by Vinod Yerrabaddi Supplier Management
-
Supplier Lot to Internal Lot Report in Business IntelligenceSummary: Need to view Supplier Lots with our Internal Lots for Inventory On Hand Balance. We work with Contract Manufacturing, so keeping track of their Lot with our own… -
PO email for multiple reportSummary: We are having business use case as: As per customer requirement we have created 3 reports for PO based on different category. All 3 reports are having different…
-
PO PDF in Language of SupplierSummary PO PDF in Language of SupplierContent Hi, I'm looking for the functionality to have the PO PDF print depending on the Supplier (address) language. Currently I've… -
How to access Contract Number variable under different tabsSummary: Hi Team, My use case is to download rtf template created in BIP by clicking a link under Documents Tab, this report takes contract number as a input parameter. …Devashish Saun 21 views 1 comment 0 points Most recent by Mariano Rodriguez-Oracle Enterprise Contracts -
Combine columns of PO catalog, category, Accounting Code into 1 reportSummary: Combine columns of PO catalog, category, Accounting Code into 1 report Content (please ensure you mask any confidential information): Hi Experts, Would like to …
-
Procurement CategorySummary: How to bring the browsing categories into OTBI analysis reports? Content (please ensure you mask any confidential information): Hi Experts, Would like to know h…
-
Supplier Qualification ReportsSummary: What are some useful reports we can have in Suppliers Qualification Management? Any examples with sample report structure much appreciated. Content (please ensu…JANKUR 2 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Supplier Qualification Management -
Disable Supplier PDF creationContent Hi all, When inviting a Supplier with their Site, by default a Supplier PDF will be generated based on your Layout (BI) and the language of the Supplier Address.…
-
Why we are able to create contract with Prospective Supplier also in Contract management?Summary: The contract with a Prospective supplier is allowed by the system. What can be the reason for it and what is the use of it? Content (please ensure you mask any …
-
Move Dashboard Page to a subpageSummary: Hi, I have created a dashboard with multiple Subpages under one Dashboard page. When i rename the Subpage names (In Dashboard Properties), somehow its convertin…Sudheer YN 203 views 8 comments 0 points Most recent by Dianne Barnhouse Reporting and Analytics for SCM
-
Unable to delete draft supplier registrations using REST APISummary: Unable to delete draft supplier registrations using REST API Content (please ensure you mask any confidential information): We have a requirement to delete exte…
-
How to extend BI Publisher report to xlsxContent (please ensure you mask any confidential information): I am running a report that exceeds 65531 rows, I read in the documentation that we can extend this format …
-
How to Modify Signature clause column titlesSummary: Need to modify Signature Clause Column Titles Content (required): Hi, We have a requirement to modify the signature clause signature title. Currently it is show…
-
How to create value set with fixed table base data and some fixed values hard coded given?Summary: I want to create value set for purachasing in which i want to pick requsition number and with that i want to also add one fixed data "Not Applicable " which als… -
How to obtain xml for Supplier Negotiation PDF ReportSummary How to obtain xml for Supplier Negotiation PDF ReportContent Hi All When I look at the bip template layout for Supplier Negotation PDF Report it is not linked to…User_2025-01-31-15-11-25-562 259 views 2 comments 0 points Most recent by Melissa Carrick - Oracle-Oracle Reporting and Analytics for SCM -
Where is the Organization Name on the SCM BICC Extracts?Summary: In the BICC Extracts for Sales Orders Transfer Orders Purchase Orders Shipments On Hand Installed Base We need to Find the Organisation Name but can only find a…Martin Hutchison 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Upload excel for search criteria to find on hand dataSummary: One of my customer has huge number of SKUs (6 million SKUs). The user would like to query the on-hand quantity for SKU's by uploading an excel. The excel file h…Vishnuvarth Subramanian-Oracle 12 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Enable Context Sensitive Contract Header DFFs in OTBISummary: We have setup and deployed both Global and Context Sensitive DFFs on Contract Header. The Global Segments appear in OTBI (e.g. for selection in an Analysis obje…
-
Locate an EL Expression Value for inputComboboxListOfValuesSummary: Locate an EL Expression Value for inputComboboxListOfValues Content (please ensure you mask any confidential information): Hi , We have a requirement to write E…Hitha Harikumar 21 views 1 comment 1 point Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Item attribute values by revisionsHello, we are trying to extract an attribute value from ego_item_eff_b in all revisions of a specific item. This means that we want to extract data with the following st…