Category 166
Discussion List
-
pre transformation rule based on customer dffSummary: Hi, we have this situation: we have the pre transformation rules based on order type to derive the billing transaction type for public sector customers, the bil… -
Data is updated in the oracle base table and the older data version is not maintained.Summary: To retrieve the Order header Freight terms code, we are utilizing the msc_xref_mapping table. Please refer to the query below: SELECT flvv.meaning freight_terms…Anmisha Sakala 52 views 3 comments 1 point Most recent by Shyam Patel Supply Chain Planning and Collaboration
-
How to set actual shipment date or return date in JST to AR transaction date?Summary: When customer ships SO or receives RMA on March 13 at 8 am in JST(UTC+9), the AR transaction date is set to one day before the actual shipment date or return da…Yuki Kobayashi-Oracle 163 views 14 comments 0 points Most recent by Yuki Kobayashi-Oracle Order Management
-
How to change orchestration of internal material transfer documentHow to change orchestration of internal material transfer document?
-
Error to transfer Sales Order information to Pick SlipWe have filled in the fields like Shipping Instructions and packing instructions while creating sales order in UI. However, we cannot find such fields in Pick slips, wav…
-
Sales order stuck in processing statusHi We have a sales order for which all lines have been cancelled. The header of the order is still stuck in processing status. How can we get this order cancelled/closed…
-
Automating Date Parameter for "Update or Close Sales Orders" ESS JobSummary: Looking for guidance on setting the “Update or Close Sales Orders” ESS Job to automatically adjust its date parameter daily. The goal is for the job to close sa…
-
Incorporating Extensible Flexfields in Order Management's Main Search and Export FunctionsDear Oracle Community, I am seeking assistance regarding the integration of Extensible Flexfields (EFFs) at the sales order header level within Oracle Cloud Fusion's Ord…
-
OM EFF to AR Global DFF for Orders created after a certain dateSummary: Hi Experts, @Shrikant Nene-Oracle , My customer wants to create based on the shipment and order number. Sales order contains both shippable and non-shippable li…
-
Getting Error in SO after creating service Mapping for OM header EFF to AR header DFFSummary: Getting Error in SO after creating service Mapping for OM header EFF to AR header DFF Content (please ensure you mask any confidential information): We are gett…
-
Modify AR_INVOICE_SPECIALST_JOB_ROLE to include Access to the Manage AutoInvoice spreadsheetSummary: We'd like to make a modification to the AR_INVOICE_SPECIALST_JOB_ROLE to include Access to the Manage AutoInvoice spreadsheet that can be accessed through the I…
-
How to map Customer po line number in OM to Note to supplier filed in POSummary: We have a requirement to cascade the customer po line number from Sales order line level to the field 'Note to supplier' in Purchase order that is created via D…
-
How to update EFF - Freight-Outbound - Freight Charge per Unit (Actuals) of Sales Order LineUsed the below API: https://:443/fscmRestApi/resources/11.13.18.05/salesOrdersForOrderHub/OPS%3A300000083395366/child/lines/00020000000EACED00057708000110D93667432800000…
-
Is there way to check whether Hold is released or not for Pause task to get releaseSummary: Pause task needs to be released after 30 minutes once Hold is released on the order line. I have used below logic , but pause task not validate the condition. P…
-
Is it possible to add Ship-to-site as a parameter for Override order line ?We have questions regarding the Override order line function, Basically, user would like to update Ship-to-site and Ship-to address. We understand that user will need to…
-
How to update order eff and line eff fields using fbdi?Summary: How to update order eff and line eff fields using fbdi? Do we have to give all the 6 files, or only the eff files. Content (please ensure you mask any confident…
-
SalesOrder Notification Business Event in OIC is not capturing AwaitShip and Backorder OM updatesWe're trying to catch Sales Order Notification Business Event from OM in OIC , when line status is gets updated to AwaitShipping or Backorder. In Fusion we've configured…
-
Prevent the scheduled job "Recover Errors" from running on s.orders that have any revisions in draftSummary: The "Recover Errors" ESS Job has been scheduled to run every 30 minutes. For a certain scenario, we want the ESS job to not pick up & work on orders that have a…
-
Current client who has implemented Demand classes to try to reserve supply for customers/DemandSummary: Hi Current client who has implemented Demand classes to try to reserve supply for customers/Demand is asking for the below: What Verticals or types of companies…Tim Clinton 33 views 2 comments 0 points Most recent by Tim Clinton Supply Chain Planning and Collaboration
-
Is it possible to show LOV values in Header EFF Field only related to the customer entered in OM?In order header EFF Field Letter of Credit needs to show only LOV values related to particular Customer Entered in order header Customer field .Is it possible through OM…
-
Need API to cancel picks post pick wave and pick slip has been createdSummary: We need API to cancel picks post pick wave and pick slip has been created. This process can be done manually from the screen shared below . But Customer wants t…Anudeepa Swain 15 views 1 comment 0 points Most recent by Shatagopam Raghavender-Oracle Inventory Management
-
sales order approval timestampWhich table stores the sales order approval timestamp, and what column should I query to retrive it ?keerthi Prasanna-Oracle 34 views 4 comments 0 points Most recent by Anuradha - User352 -Oracle Order Management -
Unable to see Project attributes on Sales Order UISummary: We have opt-in feature for Project already enabled but still we are unable to see it in OM UI. Manufacturing and Supply Chain Materials Management > Project-Dri…
-
Query to fetch Discount lists rule name and rule typeHi Everyone, We have a requirement to fetch Discount Lists "Rule Name" and "Rule Type" columns but unable to find joining conditions for the same. Please refer the scree…
-
Create Custom Infolet on Order Management DashboardSummary: Requirement to create Custom Infolet in OM dashboard Content (please ensure you mask any confidential information): Hi , I have a business requirement to create…
-
Is it possible to Auto Fill business units when a memo line is selected to create an InvoiceSummary: I need to make business unit fill automatically when memo line is inputted to reduce human error while selecting business unit, at the time of Invoice creation …
-
Price List Create CSV Ends in Debug ErrorSummary: Downloaded current copy of Price List FBDI. Input data. Click to create CSV and the process hits a debug error - Run-tie error '5'. Invalid procedure call or ar…
-
how to use user based currency conversion rate in oracle fusion in sales order.Summary: In my project, client wants to give the currency conversion rate and based on that input sales order price should get calculated. We are creating these orders v…
-
Line selection criteria not applied for FBDI ordersSummary: We have a line selection criteria setup for the GTM task based on order header EFF. This is working as expected for orders created from UI. However, for order i… -
Getting invalid subinventory error while placing sales order with warehouse and subinventory detailsSummary: Getting below error when passing warehouse and subinventory on sales order page under Supply details Tab. The request couldn't be completed because either it do…