SCM
Discussion List
-
Query to get Inventory valuation quantitiesSummary: I am looking for the query to get the inventory valuation quantities based on inventory organization. When we view the data for a period for a cost organization… -
Deploying the undeployed KFF's resolved the DFF's not appearing in OTBIWe have created a new DFF for POZ_SUPPLIERS. Deployed the DFF and ran the ESS Job : Import Oracle Fusion Data Extensions for Transactional Business Intelligence. The DFF…Yasasree Boosireddy-Oracle 82 views 11 comments 0 points Most recent by Becca Edwards Reporting and Analytics for SCM
-
Standard Cost Details Report (seeded) UI output shows Unit Cost as Zero (rounded down)Summary:Standard Cost Details Report (seeded) UI output shows Unit Cost as Zero but Excel export shows correct value. Analytics > Run Standard Cost Details seeded report…Maria Angelica Mendoza 21 views 1 comment 0 points Most recent by Manikandan S R-Support Oracle-Oracle Reporting and Analytics for SCM -
How to restrict IBLPN TI-HI receiving at certain Volume/weight/QTY.Summary: We are looking for restriction in receiving, on IBLPN at Volume/weight or QTY basis. Content :- Hi, We are looking for restriction in receiving process, on IBLP…
-
need a query to get the unit price of subscription invoiceSummary: we need a query to get the unit price of subscription invoice. Content (please ensure you mask any confidential information): Version (include the version you a…Sai Divya Kolachana 46 views 1 comment 0 points Most recent by Ed Gomez-Support-Oracle Subscription Management
-
Supplier Owned Consigned Items valuationSummary: Does Period Inventory Valluation Report consider the inventory value for consigned items those are owned by supplier? Content (please ensure you mask any confid…Anurag Kumar Pandey 31 views 2 comments 0 points Most recent by Anurag Kumar Pandey Reporting and Analytics for SCM
-
How to check the error message in Manage PO when funds status is failedHi All, Could you please let us know where does the error message of Funds Status gets stored. The ask is to show the Error message of an PO when it's Funds Status is fa…Naresh313 13 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Accessing "EGP_SYSTEM_ITEMS_B_V" table PythonAccessing "EGP_SYSTEM_ITEMS_B_V" table Python Hello Experts, I need access to the EGP_SYSTEM_ITEMS_B_V (Or any back-end table through Python. Is there any method for tha… -
Not able to get any Data from the table INV_MIN_MAX_GTSummary: Not able to get any Data from the table INV_MIN_MAX_GT. Do we need any specific roles or data access for that Content (please ensure you mask any confidential i…Chaitra Kayi-Oracle 41 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Can't found the "objType" deep link for SCM - Confirm Pick Slip pageWe seeking to create a deep link that connects between BI report and the "Confirm pick slip" page from the Inventory management page, also we searched through this docum…Mohammad Hussein 1 view 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
OTBI Report for collaboration messaging historySummary: User requires an OTBI report scheduled on a daily basis for the errored out Purchase Orders and Invoices to keep him notified. Can you please suggest the subjec…Sumiran Maheswari 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Columns from View Billing Extension Event Details page not found in the backend tablesNeed backend tables or reference code for the below listed columns. Navigation: Navigator >> Contract Management >> Revenue >> Task >> Manage events >> query a contract …
-
SCM seeded report including bin location and on order countI'm needing a SCM report that has the bin location, and also the on order count. Does anyone know of a report that includes these two fields or know of what table I can …JWilliamson 11 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Need OTBI subject area to fetch the Channel Revenue ManagementSummary: Need OTBI subject area to fetch the Channel Revenue Management Content (please ensure you mask any confidential information): I am new to SCM modules. Any input…
-
Purchase Orders Number and Requester NameSummary: What subject area to be used to create a report showing PO number and the requester name from the PO line. Content (please ensure you mask any confidential info…Ahmed Maher Kadeh 69 views 2 comments 0 points Most recent by Ahmed Maher Kadeh Reporting and Analytics for SCM -
SCM reportingSummary Custom reports builtContent Our customer is using SCM and is not very pleased with the seeded reports in Oracle. Reports they are looking for are for example the…User_2025-01-28-02-43-26-951 157 views 6 comments 5 points Most recent by Mirza Muhammad Mohsin Baig Reporting and Analytics for SCM -
We need assistance in identifying table(s) that capture shipment errorsSummary: Hi Team, We are building a BI report to fetch errors that occur during the shipment process triggered by HighJump via REST API. Currently, the team identifies e…Sai Sreeram Gundepudi 3 views 1 comment 0 points Most recent by Jagan Nori-Oracle Reporting and Analytics for SCM
-
Task number table to create value set for dffTask number table to create value set for dff in PO line level. I have tried: PJO_XCC_CTRL_BDGT_LOW_RES_V PJO_XCC_CTRL_BDGT_SEGMENTS_V PJO_XCC_CTRL_BDGT_LOW_TASK_V PO_DI…Rajat Pandey 21 views 6 comments 0 points Most recent by Rajat Pandey Reporting and Analytics for SCM -
How to create report for pending Process Requisitions that not assigned yet to Purchase order.Summary: How to create report for pending Process Requisitions that not assigned yet to Purchase order. Content (required): Version (include the version you are using, i…Mohamed Haamdy 31 views 4 comments 0 points Most recent by Goopikrishnan Jayaraman-Oracle Reporting and Analytics for SCM
-
Report on approval workflow conditions and actionsSummary: Requiring to report on requisition and PO approval workflow rules setup (conditions and actions) Content (required): Is there a delivered or would anyone be wil…Bernadette Dorris 42 views 3 comments 0 points Most recent by SanjayC Reporting and Analytics for SCM
-
Behavior in PO_HEADERS_ARCHIVE_ALL recordsSummary: Behavior in PO_HEADERS_ARCHIVE_ALL records Content (please ensure you mask any confidential information): I am looking for an explanation of PO_HEADERS_ARCHIVE_…KDR 22 views 8 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
What is the deep link URL for Procurement receipts?Summary: We want to create an action link on OTBI report - when the user clicks on the receipt number, it should open up in the application ( Procurement - My receipts) …
-
Query to get Change Orders details like changed/updated data like PO amount, Invoice Number and InvContent Hello all, Can someone tell from where I could pick the details for Change Orders details for a Purchase Order which is in "Open" status and if changes are made … -
LAST_UPDATE_DATE incorrect for PO_DISTRIBUTIONS_ALL - Creates issue for BICCC incremental loadsSummary: Has anyone faced th issue where the LAST_UPDATE_DATE is not being updated for PO_DISTRIBUTIONS_ALL/PurchasingDocumentDistributionExtractPVO even when the data i…Jahnavi-Oracle 21 views 2 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for SCM -
Unable to find Oracle R12 Inventory tables in Oracle FusionHi, We are working on Fusion Implementation project. We have developed some custom reports in our Old Oracle R12, we need to develop it in Oracle Fusion. We face difficu…Chaitanya KM 41 views 2 comments 0 points Most recent by Chaitanya KM Reporting and Analytics for SCM
-
need a query to fetch negotiation response details with price break informationSummary: Need a sql query to pull negotiation response details with price break information Content (please ensure you mask any confidential information): Version (inclu…SoumyaMukherjee03 202 views 1 comment 0 points Most recent by SoumyaMukherjee03 Reporting and Analytics for SCM
-
Sales Order EFFs not showing up in OTBISummary Sales Order EFFs not showing up in OTBIContent Hi Experts, We have created few EFF in the Sales Order Header (with BI enabled), those EFF are not showing up in t…Sunil Dabekar 207 views 3 comments 0 points Most recent by Viswanath-Oracle Reporting and Analytics for SCM -
Unable to join Product management OTBI subject areasSummary: Hello Community, I have a requirement where I need to pull the Royalty data from the "Where Used" part of PIM. As part of that we are trying to join below subje…Sai Revanth 2 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Display Item number with and without Part numbers and Manufacturer in Custom Onhand Inventory ReportSummary: The query below displays all inventory item numbers with part numbers and manufacturer information. However, the report does not show items without part numbers…
-
how to fetch historic on hand quantity correctly using new views provided?Summary: Historic On hands quantity Content (please ensure you mask any confidential information): Currently given views are not supporting historic data. Decommissioned…Neha Bhatt 33 views 1 comment 0 points Most recent by Bogdan Barbulescu-Oracle Reporting and Analytics for SCM