What are the possible reasons for Interface Trip Stop to complete with Error in Oracle APPS?

Below are the few possible reasons for Interface Trip Stop completes with Error:

• Order is on Hold
• Tax is not applied properly
• On-Hand quantity is not available in the Inventory
• Inventory Period is not open
• Make sure Schedule Ship Date or Requested Date is within the range of order Date

What is Interface Trip Stop in Order Management in Oracle APPS?

Interface Trip Stop is triggered at the time of shipping if the option ‘Defer Interface’ is not checked. When this report is run, it performs two main things:

• Update the order management (OE_ORDER_LINES_ALL)
• Trigger the inventory interface (TO UPDATE Inventory tables)

What is Bill of Lading in Order Management in Oracle APPS?

• Bill of Lading is a legal document between the shipper of a particular item and the carrier detailing the type, quantity and destination of the good being carried. 
• The bill of lading also serves as a receipt of shipment when the good is delivered to the predetermined destination. 
• This document must accompany the shipped goods, no matter the form of transportation, and must be signed by an authorized representative from the carrier, shipper and receiver.

What is Pick Slip and Packing Slip in Order Management in Oracle APPS?

Pick Slip: It is a shipping document that the pickers use to locate items in the warehouse/inventory to ship for an order.

Packing Slip: It is a shipping document that is sent along with the shipment which details the contents that are sent in that shipment.

What are Defaulting Rules in Order Management in Oracle APPS?

When creating the sales order, you can define defaulting rules so that the default values of the fields populate automatically instead of typing all information manually.

What is Shipping Exceptions Report in Oracle APPS?

Shipping Exceptions report prints the Exception Messages during Ship Confirmation.

What are Picking Rules in Order Management in Oracle APPS?

• A user-defined set of criteria to define the priorities, Oracle Order Management uses when picking items out of finished goods from inventory to ship to a customer. 
• Picking rules are defined in Oracle Inventory.

At what stage an Order cannot be cancelled?

Sales Order cannot be cancelled once it is Pick Confirmed.

Describe the Order Line Status during the Sales Order Process in Oracle APPS?

What are the different RMA Order Types in Oracle APPS?

• RMA with Credit is used when the customer returns the physical product and also receives credit as a result of the return.
• RMA no Credit is used when the customer will return the product but will not be receiving a credit as a result of the return.
• RMA Credit only is used when the customer will receive a credit, but the physical return of the product is not required.

Describe the Header Status during the Sales Order Process in oracle apps

What are the Different Types of Sales Orders available in Oracle APPS?

• Standard
• Mixed
• Return

Describe the Order Flow in Order to Cash life cycle in Oracle APPS

• Enter the Sales Order 
• Book the Sales Order
• Pick Release
• Ship Confirm
• Auto Invoice Generation
• Creating Receipt
• Transfer to GL

What are the various Order Management Processes in Oracle APPS Order Management

• Standard Orders: This method supports Make to Stock business model where the products are made and kept in stock. The products are then shipped to the customer based on his order.
• Configure to Orders: This method supports Assemble to Order business model. The product configuration is chosen at the time of sales order entry. WIP job is created based on the requirement of the sales order.
• Drop Ship Orders: In Drop Ship Method, your supplier will ship the goods to your customer on your behalf.
• Internal Sales Orders: Internal Sales Orders are created across two different organizations of the same Business group. Internal requisition is raised first and it is converted to an internal sales order where the items are shipped based on the quantity specified in the internal sales order.

OE_ORDER_LINES_ALL.source_document_type_id in Oracle APPS

SELECT order_source_id, name, description 

FROM oe_order_sources

Here order_source_id will be source_document_type_id  in OE_ORDER_LINES_ALL table.

Query to get all Internal Requisitions that do not have an associated Internal Sales Order

  SELECT rqh.segment1 req_num,

         rql.line_num,

         rql.requisition_header_id,

         rql.requisition_line_id,

         rql.item_id,

         rql.unit_meas_lookup_code,

         rql.unit_price,

         rql.quantity,

         rql.quantity_cancelled,

         rql.quantity_delivered,

         rql.cancel_flag,

         rql.source_type_code,

         rql.source_organization_id,

         rql.destination_organization_id,

         rqh.transferred_to_oe_flag

    FROM po_requisition_lines_all rql

    ,po_requisition_headers_all rqh

   WHERE rql.requisition_header_id = rqh.requisition_header_id

     AND rql.source_type_code = 'INVENTORY'

     AND rql.source_organization_id IS NOT NULL

     AND NOT EXISTS

(SELECT 'Y'--Existing Internal Order

   FROM oe_order_lines_all lin

       ,oe_order_sources order_source

  WHERE lin.source_document_line_id = rql.requisition_line_id

     AND lin.source_document_type_id = order_source.order_source_id

AND order_source.name = 'Internal'

)

ORDER BY rqh.requisition_header_id

        ,rql.line_num;