Business Intelligence - BI
Discussion List
-
Use Requisition Header DFF for ApprovalWe want to use Requisition header attribute to capture approver detail to whom the Requisition will be routed to approval. I tried using Requisition Header.Descriptive F…NamrataKumar 115 views 6 comments 0 points Most recent by Saravanan Subbaiya Self Service Procurement -
How to extract a Report on Purchase Requisition and Purchasing Approval RulesSummary The steps needed to produce a report of the approval rules that have been created in the system for Purchase Requisition and Purchasing related Approvals Content…Sumana-Oracle 5.3K views 68 comments 45 points Most recent by Susheel K Raina-Oracle Self Service Procurement -
The SQL to export the list of BPA & PO having Master Contract which doesn't have Contract TermsSummary: Anyone please provide the SQL to export the list of BPA and PO number which have the master contract attachments and those contracts doesn't have any contract t…
-
Requisition View PDF not showing the custom templateHi, We received an email from Oracle stating that action is required for customers using a custom template for the "View Requisition PDF". Since we are currently using a… -
Table(s) that populate when users return/ correct using Procurement > My Receipts > Manage ReceiptsSummary: We need to identify the Oracle fusion tables that are populated when users return/ correct procurement receipts using the Procurement > My Receipts > Manage Rec…
-
Multiple Entity data visible in Spend ClassificationSummary: An entity user who was given buyer access and data access to a particular Business unit is able to view or create data such as Purchase Requisition, Purchase Or…
-
Purchase Order Customized Layout is not visible on View PDF ButtonSummary: Purchase Order Customized Layout is not visible on View PDF, Steps 1 : Customized the Standard Report (Purchase Order PDF Report) 2 : Modified the Custom Report…
-
Expiring 24B or 25A: Configure REQ PDF Using the Extensible Oracle Analytics Publisher Data Model?Summary: Is the Configure the Purchase Requisition PDF Using the Extensible Oracle Analytics Publisher Data Model opt-in feature expiring 24B or 25A? Content (please ens…
-
AMOUNT_ORDERED column in PO_DISTRIBUTIONS_ALL table is showing NULL valueHi, I've encountered an issue where some Ordered Amount values on the distribution level are showing up as null when querying the PO_DISTRIBUTIONS_ALL table. This field …
-
¿How to identify the origin of the fields in the RTF template of the “Purchase Request PDF Report"?Summary: Difficulty identifying the source of fields in the RTF template of the standard report “Purchase Request PDF” Content (please ensure you mask any confidential i…Lynda Ramos 101 views 9 comments 0 points Most recent by Alex Tuteur-Oracle Self Service Procurement
-
Need to fetch Allow_International_Payments_Flag for Supplier data in BIP Report.Need to fetch Allow_International_Payments_Flag column for migrating supplier data from fusion to new fusion environment. This column is in AP_SUPPLIER_SITES_ALL table s…Chaitanyadev_Functional Consultant 1 view 1 comment 0 points Most recent by Subhashini Supplier Management
-
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 …
-
Requisition PDF Report With Data Model not translating to English languageSummary: Requisition PDF Report With Data Model not translating to English language Content (please ensure you mask any confidential information): Hi Before enabling the…Jazmin Saldierna 51 views 11 comments 0 points Most recent by Lucero Espinoza Self Service Procurement -
How to replace the seeded template by custom template for Requisition Approval Email NotificationSummary: Content (required):We would like to know how to replace the seeded template with the custom template for Requisition Approval Email Notification in the applicat…Dilip.Murugan-Oracle 314 views 3 comments 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement
-
how we can fetch cancel or reject reason for procurement requisition in oracle sql ?If there is 1 requisition having 3 lines with header status rejected but line 1 is canceled and line 2 and 3 are rejected. Then how can we find the reason behind it and …Puspita 21 views 1 comment 0 points Most recent by Elena-Cristina Staniloiu-Oracle Self Service Procurement
-
Unable to find a way to get actions on receiptsDear Oracle Support, I have set up a job notification to be sent to the approver when a new receipt is received. The approver then sends this job for further processing.…
-
Not able to see data in table MSC_AGGRPLANNING_BORSummary: I need to extract Aggregated Bill Of Resources form the BIP repot. But not able to see any data for the table. Can you please guide me here Content (please ensu…
-
How to stop the following mailer notification- The task has been completed and no longer required...Summary: Hello Oracle Experts! When the PO/ PR is approved from Email, once the PO/PR is approved, the approver is getting a automatic notification from the Oracle maile…
-
Requisition Approval tree not generated the error message where it stored in BI tablesSummary: The customer requirement is when requisition is created but approval rule is not generated , in that case need to send notification for that particular PR. The …SivaRamaKrishna-Oracle 21 views 3 comments 0 points Most recent by Alex Tuteur-Oracle Self Service Procurement
-
Requisition PDF Report With Data Model, does not reflect new fieldsSummary: I tried to add (Created date) to data model , save sample data, export the xml data , add it to new customized RTF but it does not reflect at all. Content (plea…Mustafa Abu Dayeh 31 views 9 comments 0 points Most recent by Alex Tuteur-Oracle Self Service Procurement
-
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 13 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… -
Requisition View PDF in RSSP and New Requisition reportSummary: The new Requisition report "Requisition PDF Report With Data Model" is going to be mandatary from 25A onwards , We would like to know more about this , Please p…Tapan K Nath 150 views 2 comments 0 points Most recent by Catherine Rosales Self Service Procurement -
Requisition PDF Report With Data Model XML fileHi Experts, In the upcoming 25A update, the Requisition PDF XML Publisher template will no longer be available and we will need to customize the new extensible Oracle An…
-
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 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
What is the table name for price break information at negotiation response line levelSummary: What is the table name which holds information related to the price break information at negotiation response line level. We need this information to fetch data…