Business Intelligence - BI
Discussion List
-
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 4.3K views 60 comments 43 points Most recent by Prabhat_118811 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 11 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…
-
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…Ashley Davis 161 views 10 comments 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement
-
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 11 views 2 comments 0 points Most recent by Mustafa Abu Dayeh Self Service Procurement
-
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 10 comments 0 points Most recent by Alex Tuteur-Oracle 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 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…Abdur Rehman 401 views 7 comments 0 points Most recent by Alex Tuteur-Oracle Self Service Procurement -
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…
-
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 -
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…Andres Cuestas 21 views 1 comment 0 points Most recent by Kavita Yetakuri-Oracle Inventory Management
-
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
-
Purchasing Documents Pending ApprovalSummary A Report showing purchasing documents which are currently pending approval and the person they are currently assigned to.Content My colleague had provided this a…Ashok Sriniva-Oracle 1K views 19 comments 12 points Most recent by Shankar Naidu-Oracle Self Service Procurement -
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…
-
Find related field in frenchHi, Could you please advise in which database table can I find the Purchase order status in french or the requisition status in french. (Procurement → Purchase Order → M…Elyse Meouchi 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
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…
-
Restrict the access of Procurement OTBI Dashboards with respect to Inventory OrganizationsDear Team, I have developed an OTBI report with purchasing real time subject area however when I assign that otbi to the user I would like to restrict the data only with…
-
pvo to link between catalog and categoryIs there any PVO to link between Purchase Catalog and Purchase Category
-
query to get negotion award approval historyHello I want sql query or fusion tables to get sourcing/negotion award approval history person name action date Below is the screen shor of form from where i want when w…
-
Only actual buyer should appear in dropdown in Manage Purchase Order screenSummary: Hi Folks We have a requirement as below - In Manage Purchase Order screen, there is filter parameter of buyer. In these LOVs the requirement is that only person…
-
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 -
Error message while defaulting the value for DFF: FND-FND_VS_VALUE_INVALID, cannot be accessedSummary: Hi, While setting the default value of a DFF, facing an error: FND-FND_VS_VALUE_INVALID, can not be accessed. Attaching screenshot for the same. Content (please…Deepali Singal 151 views 3 comments 0 points Most recent by MariCostache-Oracle Reporting and Analytics for ERP
-
How to change Subject Line in Buyer FYI Notification Email?Summary: An email notification is sent to Buyer when a Purchase Order is Created or Changed. The client requirement is to modify it to Add Revision number in the subject…