Business Intelligence - BI
Discussion List
-
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 405 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 31 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 51 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 12 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… -
Views created for the inv_material_txns table?Hi Experts, I was looking to tune my BI Report Query. I have used inv_material_txns table frequently in the query, I wanted to understand if there is any view created fo…Divyam Sachan 11 views 1 comment 0 points Most recent by Arun Yadav - Support-Oracle Inventory Management
-
DFF Value is not available in the BI Subject Areas - INV_LOT_ATTRIBUTESSummary: Do not see new DFF created in 'Inventory - Inventory Balance Real Time'. Please see attached. Content: Name Lot Attributes Flexfield Code INV_LOT_ATTRIBUTES App… -
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 171 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…
-
Stock on hand based on a past date or time intervalSummary See on hand stock based on a past date or time interval filterContent Hi. There is any report or way to get in the stock on hand based on a past date or time int…
-
On-hand quantity on a historical dateContent We have a requirement where we need to get the inventory on-hand quantities of items by day @ 11:59:59pm since Jan 1, 2021. Is there a standard report that can b…User_2025-02-11-12-16-08-273 667 views 3 comments 2 points Most recent by Becca Edwards Inventory Management -
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
-
Is there an SQL statement or Analytic in OTBI for Interorg Transfer reportingSummary: Our business users are printing out Interorg Transfers, but once the Transfer is saved the Shipment Number field is "Grayed Out" and this make reading it on the…
-
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…
-
Table Column not available in BICC PVO FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.InventoryLocatorThe column LOCATOR_NAME from table INV_ITEM_LOCATIONS is not available in the BICC PVO FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.InventoryLocatorExtractPVO.
-
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…