OTBI
Discussion List
-
Does User Interface Text affect OTBI/Notification labels?Summary: I'd like to confirm the range of impact when using the User Interface Text. Does it also affect the field names of OTBI or workflow notifications?Kana Kutsukake-Oracle 6 views 2 comments 0 points Most recent by Kana Kutsukake-Oracle Self Service Procurement -
How to invoke Purchase Order Email Body layout during Communicate Purchasing Document Process runsSummary: How to invoke Purchase Order Email Body layout during Communicate Purchasing Document Process runs, if you have custom layout. I am unable to upload PurchaseOrd… -
Where are the attribute fields in the "POZ_Supplier" table in OTBI?Summary: Hi Oracle community, I have created two global segments in the POZ_SUPPLIERS DFF "attribute 6" and "attribute 7". I can select them in BIP reports. However, in …
-
How to get Award Approval Date in OTBI?The item in OTBI has Award Date and Award Completion Date, but the item in Award Approval Date does not exist. Where can I get it?
-
Requisition PDF Report With Data Model,Custom translation file does not workSummary: 1-We want to customize the layout for the new (Requistion PDF report with data model) 2-After create a new template with locale (English) Language 3-We extract …Mustafa Abu Dayeh 16 views 2 comments 0 points Most recent by Mustafa Abu Dayeh Self Service Procurement
-
Is there a way to review users' usage of self service procurement?Summary: Is there a report which we can run to review when users last used their access to self service procurement, in order to manage which users require access? Conte…
-
RSSP - Source Application information to be available in subject area?Summary: RSSP - Source Application information to be available in subject area? Content (please ensure you mask any confidential information): Hi Experts, I got it from …
-
Currency field of a Requisition that is in "Procurement - Requisitions Real Time" subject area?Hi Experts, We are trying to come up with a report from the subject area of "Procurement - Requisitions Real Time", while I cannot find the correct currency code that is…
-
How to use Special Handling attributes in OTBI analysis?Summary: As of the 24D update, there is the new feature to use special handling type attributes within the "Procurement - Purchasing Real Time" subject area (https://doc…
-
Work Order(WO): Requisition is approved without approval.Summary Work Order(WO): Requisition is approved without approval.Content Hi all, Work Order(WO): Requisition is approved without approval. Thanks, Dev Thota. Version 19B -
How can we obtain XML to build our reportSummary: We are trying to create a custom report that pulls data from an approval flow. In the previous SR it was recommended that the information is stored in XML. We a…
-
Our requirement is to create an OTBI report for local catalogsSummary: We want to find out the below:- Which BPA lines are not assigned to a local catalog? Which CPA/BPA are not assigned to a local catalog? Can we achieve this requ…
-
Error in OTBI report while using 2 Procuement subject areasSummary: I am trying to create a OTBI report to understand Non catalog Requisitions which are not created from Smart forms. For this i am combining 2 subject areas namel…Shameek 2 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to extract requisition approval rules created in BPM as a report or CSV file.Summary: Requirement is to extract approval rules along with details/settings of the various stages, participants and the rulesets. Content (required): I have referred a…Ananda Bhargav Potluri 1.1K views 6 comments 2 points Most recent by B Sekhar Self Service Procurement
-
Dynamic PO PDF bodySummary: one of my customer wants the PO PDF Body message that goes to the supplier to be customized dynamically and it needs to be editable for each email that is sent …
-
Requisition PDFSummary: Is there an ESS process to run the requisition PDF? We see the BIP report and would like to be able to run it without the View PDF button from the requisition s…MBradley1910 12 views 1 comment 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement
-
Requisition Line DFF segments not populating in the Purchase Requisition PDF reportRequisition Line (DFF) not populating in the Purchase Requisition PDF Report layout (without datamodel report) We are using investment segment number under attribute19 a…
-
On Hand at Requisition CreationSummary On Hand at Requisition CreationContent Hi All, There is a requirement to show On hand availability to buyer before creation of requisition order. Buyer should be…Mayank Pande 40 views 11 comments 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement -
Is it possible to find the Purchase Requisition (PR) based on projects in the approvers User accountSummary: The business wants to see the requisition and the status (Approved, rejected) based on the project filter and approver person further to see the relevant requis…
-
Cost Center details in Purchasing- Requisitions Real Time Subject AreaSummary: Cost Center details such as Cost Center code and Cost Center description in 'Purchasing- Requisitions Real Time' Subject Area Content (please ensure you mask an…Srinivas Reddy 11 views 4 comments 1 point Most recent by Srinivas Reddy Reporting and Analytics for ERP -
Bare minimum roles required to view infotile dashboards for Procurement?what are the bare minimum roles required for the user to access an infotile dashboard in "Procurement Area" (Purchase Requisitions and Purchase Orders) I created a intof…mayankthakur 14 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Requirement: Receipt report that gives the end user the ability to download a PO or PR attachmentSummary: Customers have provided us with the requirement to develop a receipt BI or OTBI report that gives the end user the ability to download a PO or PR attachment if …Shashikanth Kumar P-Oracle 32 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Existing report to check the details about number of users logged into Supplier portal for SupplierSummary: Is there any existing/seeded report to check the details about number of users logged into Supplier portal for a Supplier. Content (please ensure you mask any c…Sreekanth Kuduvande 32 views 3 comments 0 points Most recent by Ravi Kumar-Oracle Supplier Management
-
How to restrict items (Inventory) in requisition / PO Lines?Summary How to restrict items (Inventory) in requisition / PO Lines?Content Hi all, In Requisition / PO line-entry all inventory items are coming, We need to restrict so…
-
Can we add GBPA number as a link in a BI report?Summary: We have a BI report to extract details related to Purchase Agreements. Can we have the Purchase Agreement number as a link in th report , clicking on which woul…
-
OTBI report for Subject Area Procurement - Purchasing real time giving no dataSummary: We have a custom Buyer role with BI Author and Purchase Order Transaction Analysis Duty role and the required grants on Purchase document header tables. The rol…Asutosh Mishra 127 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How can we generate an OTBI report with receipt Number with received Quantity/AmountSummary: We have a requirement to create an OTBI report with Receipt Number and the corresponding Received Quantity or Amount. We tried using Purchasing Real Time data b…Asutosh Mishra 109 views 1 comment 1 point Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Receipt Creation Date coumn in OTBISummary: Which column in OTBI area can we leverage to get the receipt date information in Self Service receiving. Content (please ensure you mask any confidential inform…Asutosh Mishra 1 view 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Enable Procurement Dashboard under Procurement tab in Oracle Fusion Cloud instanceSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Integration between OTBI and FAWSummary: Integration or Linking possible between OTBI and FAW. Content (required): There is currently an ask to integrate OTBI and Fusion Analytics Warehouse (FAW). Is t…Annika Wan Yee 61 views 5 comments 1 point Most recent by Clare Murtagh Reporting and Analytics for SCM