Business Intelligence - BI
Discussion List
-
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 111 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 …Sheetal VBCS 25 views 0 comments 0 points Most recent by Sheetal VBCS Reporting and Analytics for ERP
-
Assistance Required for Converting OTBI Query to Oracle Standard TablesSummary: I am reaching out to seek your expertise regarding the conversion of an OTBI query subject area into Oracle standard tables. Specifically, I am looking to under…Guthi Mallikarjun 21 views 8 comments 0 points Most recent by Guthi Mallikarjun Inventory Management
-
SQL Query to extract Item LocatorsSummary: SQL Query to extract Item Locators Content (please ensure you mask any confidential information): Hi - I wondered if anyone might be able to help please, with a…
-
Auto-Printing the Receipt after submittingClient Requirement: after creating the receipt and submitting it, the client wants to auto-print a custom report we have developed for him. is this functionality standar… -
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 71 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 443 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 32 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 53 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
-
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 -
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 699 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.