Intercompany Invoicing for Drop ships Sales Order (Across the OU)

There was question about why we created 3 invoice for "Drop ship sales order  across OU"  in reference to my post http://eoracleapps.blogspot.com/2010/11/how-to-create-drop-ship-sales-order.html

For More details about Drop Ship across OU , please refer the POST


Please Note that ,as per Inter-company Setup , System will generate 3 invoices.
1.AR Invoice from US Operating Unit  to Customer..

2. Intercompany AR invoice in Singapore OU(Shipping OU) to US OU(Selling OU).
3.And now US has to pay Singapore OU, so an Intercompany AP invoice will be created in US OU .

US OU - Selling Operating Unit
Singapore OU - Shipping OU
Hope that will helps


Regards
eoracleapps

Query to get the Receiving Transaction where data not yet created in MMT and MMTT

select rt.transaction_id, rsl.transfer_percentage, msi.revision_qty_control_code,
rsl.item_revision, rsl.item_id,
rsl.from_organization_id, rsl.shipment_unit_price, rsh.shipment_num,
rsh.freight_carrier_code, rsh.num_of_containers, rsh.waybill_airbill_num,
rsh.ussgl_transaction_code, rp.receiving_account_id
from rcv_transactions rt, mtl_system_items msi,
rcv_shipment_headers rsh, rcv_shipment_lines rsl, rcv_parameters rp
where
rt.transaction_id = &your_transaction_id
and rt.TRANSACTION_TYPE = 'DELIVER'
and rt.DESTINATION_TYPE_CODE = 'INVENTORY'
and rt.shipment_header_id = rsh.shipment_header_id
and rsl.shipment_header_id = rsh.shipment_header_id
and rt.shipment_line_id = rsl.shipment_line_id

Can we cancel Drop Ship Sales Order line with OE_ORDER_PUB

Yes, With Process Order API , we can cancel a Drop Ship Sales order line and it will also cancel requisition and PO (if allowed) that are associated with the drop ship line. Well that is old feature , but I explored it recently.
Source Code for OE_ORDER_PUB 

declare
p_header_id number := &p_header_id;
p_line_id NUMBER := &p_line_id;
l_api_version_number NUMBER := 1;
l_return_status VARCHAR2(2000);
l_msg_count NUMBER;
l_msg_data VARCHAR2(2000);
l_xxstatus VARCHAR2(1000);

what is Indivisible Items

In Oracle Inventory we have feature to define items that can only be ordered in integers and not in decimal quantities.We call these items as "Indivisible Items"

For example, you can order pencils in integers (e.g. 1, 2, 3) rather than in decimals (1.1, 1.2, 1.3).

Navigation path >

Navigate to the Physical Attributes tabbed region in the Master Items window to set upthe item attribute, OM Indivisible, to enter items using decimal quantities.

For example,

Archive and Purging Strategy for Oracle Advance Pricing

In my last post I talk about Oracle Advance Pricing I have pointed out that we should always have Purge Strategy in place to purge the Unnecessary data (data from past promotions/discounts /campagins etc).

Best of Oracle is they already have Archive/Purge Strategy process in Place as part of Standard process.

1. Archive process will delete data from QP table and insert them into Archive table.
2. Purge process will delete data from Archive tables.

 Archive /Purge Process – Please note that Archive Process willdelete data from Modifier list lines and Price list lines, though it archive the Modifier and Price list header, but it still keep the Price list and Modifier header data.
Archive /Purge for Price List /Modifier will archive/purge their respective qualifiers too.

Strategies to Improve Oracle Advance Pricing Performance.

In this post I will talk about a general and simple approach about the Strategies to Improve the Performance of Pricing Engine.

There are tones of material available in metalink about how to improve the performance of the Pricing engine, so I am not going into details, I will just high light some of those approaches.

• As all of us knows that Volume of data always Impact the performance, but that doesn’t mean we stop adding the data in the system, but when ever we define the Rules/Qualifiers/Attribute in the system, just take the long team approach and not short team, point that I want to make here is don’t define Qualifiers based based on the Individual records like  Item/Customer/Address if possible define in terms of Category/Class/type etc.But many a time business need is to define in terms if Individual records , so that’s fine.

Drop Ship processing in Oracle Order Management

For a drop ship sales Order ,any attempt to do the partial receipt against the corresponding PO (created for drop ship sales order line) will result in drop ship order line split.

After the drop ship sales order line got split , PO shipment will point to the newly created open line (created after the split ) and shipped qty  set to NULL , their will be no relation ship between  PO Shipment and the Original sales order line.

Internal Sales Order and Split

A internal sales order is sales order in the Order Management system that is generated from an internal requisition in the Purchasing system and loaded into OM through Order Import.

Internal order lines are never split, either manually or by the system.Any attempt to manual split internal Sales Order lines will results in error message "You are not allowed to split Order Line because: Cannot split an Internal Sales Order Line"


Also , Order Management does not support item substitutions for Internal Orders. 

Cancellation of IR if ISO is still open

If Internal Sales Order (ISO) created  from  Internal Requisition (IR) is open , then system will not allow user to Cancel the IR.
Any attempt to cancel IR  by means of tools > Control  will  raise message "says"no control actions found for this document".

But if ISO is shipped /closed system will let you cancel the IR

Scheduling and Reservation with Process Order API.....

Process order API can be used to perform scheduling actions on order lines. Scheduling
actions include:

1. schedule
2. unschedule,
3. reserve and 
4. unreserve.

The schedule_action_code field provided on the order line record (line_rec_type) can be used to provide the action which needs to be performed on the order line.

Reservations can also be performed by passing the reserved_quantity on the order line record. You do not need to send in the schedule action if reserved_quantity is passed.

Process Order API will also automatically schedule or re-schedule the lines if the schedule_ship_date or schedule_arrival_date field is passed or updated respectively.