SCM
Discussion List
-
Backend tables for Receipt Accounting DistributionsSummary: I need backend tables for the screen Receipt Accounting Distributions (Supply Chain Execution>Receipt Accounting> Receipt Accounting Distributions). I found tha…Akankshya Jena 4 views 1 comment 0 points Most recent by nothingname Reporting and Analytics for SCM
-
I am trying to connect this table cst_layer_costs unit_cost with this table INV_MATERIAL_TXNSSummary: I am doing transaction stock movement report I am struggle with unit_cost column which I am taking the column from this table cst_layer_costs try to connect it …Khalid Aldosari-Oracle 18 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Can we change the PO PDF Report Output name?Summary: Hi All, The requirement is to change the PO PDF report output name. Content (please ensure you mask any confidential information): Version (include the version …Dhilip Kumar P. 16 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Need a SQL query to get the Total Quantity of Pending Transactions of a item in oracle fusionHi Experts, I need a SQL query to get the Total Quantity of Pending Transactions for a item. My requirement is to get "Available to Transact" Quantity of a item. ( = 200…Krishan_Palihakkara 70 views 0 comments 0 points Started by Krishan_Palihakkara Reporting and Analytics for SCM
-
can I make a warning massage in report parametersHello community, Can I make the same warning message in the screenshot in the report for parameters? No specific field is required but must enter at least one thanksAhmed Abdelaziz 23 views 0 comments 0 points Started by Ahmed Abdelaziz Reporting and Analytics for ERP
-
how to get data for destination location in Transfer order?I need destination location for transfer order. how to get that? which table i used to join with to get location name?
-
Is there any specific way in which we can get all the Supplies and Demand related SP data in one BIPSummary Is there any specific way in which we can get all the Supplies and Demand related SP data in one BIP Report?Content I want to know if there any specific way in w…Renuka Soneja-154959 40 views 3 comments 2 points Most recent by User_KMKTM Reporting and Analytics for SCM
-
Access the standard BIP report extracts via APISummary: Hi Team, We have a requirement to fetch and place the standard BIP extracts from UCM to some file server. example, once the ap invoices import process is comple…
-
Can you please help me to find parent reports for the below OTBI child reports?Can you please help me to find parent reports for the below OTBI child reports? Past Due Fulfillment Lines Report Sales Order E-mail Sales Order Line Status Update Sales…User_SIV20 2 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Query to get payment method field in Order Management in Oracle FusionContent Hi all, Can someone tell me from where I could pick the payment method field mentioned at the front end of the Order management page? I have checked for the tabl…Sushan Peiris 921 views 2 comments 4 points Most recent by Shishir Dhone Reporting and Analytics for SCM
-
Need a SQL query to get all the transactions involving a specific serial number in Oracle FusionI need a SQL query to trace all the transactions for a specific item serial number involved in Oracle Fusion.Krishan_Palihakkara 134 views 7 comments 0 points Most recent by Krishan_Palihakkara Reporting and Analytics for SCM
-
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheet Content This spreadsheet is published by Oracle OTBI Development. Release: 24D…Ramamurthy Shankarachetty-Oracle 14.4K views 53 comments 40 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
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 61 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 22 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 11 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 32 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 11 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 1 view 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 16 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…Mhees Mhees 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 1 view 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