SCM
Discussion List
-
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 42 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 26 views 1 comment 0 points Most recent by SoumyaMukherjee03 Reporting and Analytics for SCM
-
Which table in Oracle fusion stores the error messages while Importing sales Order using FBDIIn which table, can I find the error messages for any error occured during the Import Sales Order using FBDIRishabh33Maithani 286 views 2 comments 0 points Most recent by Rishabh33Maithani 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 169 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 4 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Query/Table to find the below highlighted fields for Configure Negotiation Award Outbound Service?Can you help me in finding the above highlighted fields?Varalakshmi 11 views 1 comment 0 points Most recent by Ramesh Jooturu-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 34 views 1 comment 0 points Most recent by Bogdan Barbulescu-Oracle Reporting and Analytics for SCM
-
Sourcing Negotiation PDF - Tag which contains value for Allow Alternate Lines FieldSummary: Please help in Identifying if any tag pertains to "Allow Alternate Lines" field in Sourcing Negotiation PDF report. We have checked the below note but not able …Kumar Nandan-Oracle 12 views 1 comment 0 points Most recent by Himabindu B-Oracle Reporting and Analytics for SCM -
Average Unit & FIFO Unit Costs for the Physical Inventory Adjustment ReportHello, I am hoping that you Inventory Cloud gurus can help me. I have created a custom report that shows the Physical Inventory Adjustments. Now I have to add the follow…Julia Looi 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
movement request auto approval table in oracle fusionSummary: movement request auto approval table in oracle fusion Content (please ensure you mask any confidential information): Version (include the version you are using,…KOTTHURI ASHOKBABU 12 views 2 comments 0 points Most recent by KrishnaV Reporting and Analytics for SCM
-
display logo in excel format in Oracle Fusion BI reportI want to diplay the logo in Orcale Fusion RTF template in excel output When fetching output in pdf its showing the logo but not in excel fromat What is the sloution to …Abdur Rehman 35 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Need to call "Print Movement Request Pick Slip Report" from Movement Request pageSummary:Need to call "Print Movement Request Pick Slip Report" from Movement Request page Content (required):Need to call "Print Movement Request Pick Slip Report" from …MANISH KUMAR-145787 11 views 1 comment 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
How to filter out duplicate rows with same values in BI report.Summary: I need to create one BI report where I need columns like Item_Number, Item_Description, Prc_BU_Name, Order_Num (PO_num), PO_Quantity, Invoice_quantity, Invoice_…Rishabh702 12 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Fusion warehouse calendar querySummary: Need warehouse calendar query. I built a query that needs to have year, month, month start information using msc_calendar_months but msc_calendars table does no…kalyan gade 44 views 1 comment 0 points Most recent by Geno Hawkins- Support -Oracle Warehouse Management
-
How do I find the Submit Request Window to run a Buyer ListingI need to submit a Buyer Listing but I do not know how to get to the Submit Request Window?John Montgomery 4 views 2 comments 0 points Most recent by John Montgomery Reporting and Analytics for SCM
-
How to sum (group by) more than one column on OTBII need to create a custom column that aggregates WIP balance by both WO and Cost element. I can create sum(wip balance by wo) and sum(wip balance by cost element) but th…G.Engelmann 14 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Query/Table to find the below highlighted fields Configure Supplier Outbound Synchronization ServiceCould you please in finding the above columns?Varalakshmi 11 views 1 comment 0 points Most recent by Hong Gao-Oracle Reporting and Analytics for SCM
-
Query to get the Serial Number of Shipment number for PO in CloudNeed to find the serial number used in shipment for purchase order when we pass shipment number. select rsl.line_num, rsh.shipment_num, poh.segment1 as po_number, pol.it…User_K040A 341 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Not able to successfully send rest api post request to generate BI publisher report in Fusion CloudSummary: I'm trying to make a post-call to generate a BI publisher report. The fusion cloud rest api is returning RequestId -1 despite the request was fulfilled with 201…mayank_tripathi 12 views 2 comments 0 points Most recent by mayank_tripathi Reporting and Analytics for SCM
-
where can i find posting_type columns in scm tablesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…B V LAVAN Salivahan 21 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
what are the extraction limits of the finder field in online reports?Summary: I need to know the character limit that can be sent to Bi Publisher Content (please ensure you mask any confidential information): I'm trying to extract the inf…Mari 31 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
How to restrict the Subject areas against specific Module with a roleSummary: Hi Team, We have a requirement to restrict the subject areas against each area, like inventory, procurement, and order management, using a specific role, as the…Support 12 views 4 comments 0 points Most recent by Vijay Bhaskar Koti Reporting and Analytics for SCM
-
How to add attachment column in bank account creation page of register supplier pageSummary: How to add attachment column in bank account creation page of register supplier page Content (please ensure you mask any confidential information): How to add a…Venkatesan 31 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
MSC_BOMs_VSummary: When queried it results no data and when the code is viewed it says "undefine" Content (please ensure you mask any confidential information): Is this a bug that…Mike.Myers.CDIPRODUCTS.COM 11 views 2 comments 0 points Most recent by Mike.Myers.CDIPRODUCTS.COM Reporting and Analytics for SCM
-
Unable to print pick splip to a printerSummary: Print Pick Slip report is ending in error while running with Printer as an output. Below are the details of error message from ESS jobs: Document delivery faile… -
do you know which table store the records of attached Contracts page Details in fusion?Summary: do you know which table store the records of attached Screen Details in fusion. Content (please ensure you mask any confidential information): Version (include …B.Anil 11 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
How do I stop my OTBI screen from going Null when the user leaves and comes backSummary: We need to keep the values in the dashboard when the user moves from tab to tab. Content (please ensure you mask any confidential information): Version (include…Larry Sherrod 1 view 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM