[ANNOUNCEMENT] Business Trip to Hong Kong for 1 week

[OM] Auto Allocation in Transact Move Order for a Sales Order

If the SO shipment status is now "Released to Warehouse", we need to perform Transact Move Orders.

For the Move Order, which setup trigger auto allocation?

Ans: In the Release Rules form, Inventory tab, Auto Allocate selection (Yes/No)

Related Topic:
http://oraclea2z.blogspot.com/2009/06/om-pick-release-released-to-warehouse.html

[OM] Setting Up Internal Customer for IR-ISO

How does customer get recognized during Internal Sales Order (ISO) creation?

Ans: Location. In IR, there is a Ship-to-Location, and this internal location must tie to the same location defined in Customer Address (Customers->Addresses->Location->Internal Location). Each unique location can only assigned to only 1 customer and 1 address.

Table for customer address and location: RA_SITE_USES_ALL

[OM] 1 Delivery Has Many Delivery Lines, How to Backorder Only 1 Delivery Line

At Shipping Transactions form, query the delivery line by order number and item code (assuming this item has only 1 delivery line), enter the Shipped Qty as 0, Backordered Qty as the total quantity at the delivery line.

Click Delivery tab, select "Ship Entered Quantities", press OK. If a delivery has multiple lines, only the selected line will be backordered.

[OM] Ship Confirm and Interface - Fields Change

Some useful info on the field value change for Ship Confirm action:

wsh_delivery_details (WDD)
shipped_quantity updated
released_status = C (from Y)

wsh_new_deliveries (WND)
status_code = CL (from OP)
confirmed_by updated (Shipped-by Person Oracle id)
confirmed_date updated
itinerary_complete = Y (from blank)

wsh_delivery_assignments (WDA)
No-change

After Interface Trip Stop:
WDD
oe_interfaced_flag = Y (from N)
inv_interfaced_flag = Y (from N)

WND
No-change

[SYS] Default Value for Organization Code

To set default value for Organization Code in the concurrent program parameter, use this

select organization_code from org_organization_definitions where organization_id=:$PROFILES$.mfg_organization_id

[INV] Where did the Onhand Quantity Gone?

Onhand shows 12400, Available is 9400, no reservation for this item, where did the 3000 qty gone?

Ans: Pending Transactions

[OM] Backorder Action will Unreserve Quantity Reserved?

Ans: Yes

[SYS] Good Design

Value Set in Oracle stores set of values, so that it can be used in elsewhere, in Descriptive Flexfield Segments, Key Flexfield Segments and even Concurrent Program Parameters.

How do we know the where-used?

Ans: Navigate to Application->Validation->Set, open the form, query the value set, click "Usages" button.

[OM] Missing Link in OM and INV

After Ship Confirm process, Interface Trip Stop program will be triggered to perform inventory transaciton "Sales order issue", which is actually issuing out stock from staging subinventory (reducing onhand).

To complete this, Interface Trip Stop needs to insert records into
apps.mtl_transactions_interface table, material manager will process it accordingly.

A missing link, what if records in apps.mtl_transactions_interface table failed to get processed, Sales Order line status will still become "Shipped" and "Closed", which is misleading and inconsistant.

[WIP] Performed Receiving for OSP Item, No Move Transactions

I performed a OSP receiving (delivery to Shop Floor), expect to see Move Transactions performed automatically in WIP, for the particular Job. But it didn't, why?

When I check the Move Transactions->Pending Move Transactions, it was there, but in Pending status.

Checked the Inventory Interface Manager, Setup->Transactions->Interface Managers. Select "Move transaction", Tools->Launch Managers. You will see a request form pops up, the concurrent program name is "WIP Move Transaction Manager". Submit it and the pending transacitons will be cleared.

[OM] Pick Release, Released to Warehouse

An extension from my previous post on the "Released to Warehouse" status, now we are performing Pick Release at the "Release Sales Orders" form, go to "Release Criteria", Shipping tab, if your "Auto Pick Confirm" has the value of "No", the shipping line status will show "Released to Warehouse" after picked.

Transact Move Order needs to be performed after that.

[OM] "Awaiting Shipping" and "Staged/Picked" status in Order Line

When order line is picked, the Line Status suppose to show "Staged/Picked". But what if it shows "Awaiting Shipping" but at Line Status in Shipping Transactions form shows "Released to Warehouse"?

This means Move Order been created, but Picking was not completed successful. You need to manual transact the Pick Wave move order.

[SYS] Best Practise - To Update a Record Value in Setup Form

Read a documentation, it mentions the best practise to update a record value during Oracle setup (at form level).

Instead of bulk query and update 1 record, query the specific record, update it.

You know why? This is to prevent potential bug on the form that will update all records even you update 1 (what a "valid" reason).

[OM] Picked Quantity Auto Transferred Back Atter Backordered?

Picked quantity (Pick Release process) will NOT be transferred back automatically to original locator/subinventory after Backordered transaction.

[OM] Shipping Method

I guess i need to further clarify on my previous tip, regarding the setup of sales order Shipping Method.

To look at the complete list of Shipping Method, you need to go to Setup->Organizations->Shipping Methods in Inventory responsibility. It is a System Lookups, type: SHIP_METHOD.

You can add/modify/remove Shipping Method there.

[OM] Query Manager for Shipping Transactions Form

Org Code is not defaulted to the OU's inventory organization, but it is defaulted to another inventory organization which has no relationship with current OU. Somemore, Org Code field is disabled. Why?

Ans: Setup->Shipping->Grants and Role Definitions->Grants. Grant to your Oracle user id, the Org Code will be enabled with blank.

[SYS] FND: Default Request Days

"FND: Default Request Days" profile decides the default value shown in "Select the Number of Days to View" field after you choose View->Requests

[OM] Intercompany Setup for OM

I have setup an environment to enable Order Entry (Selling) and Shipping from different OU in same Sales Order. This is the summary of Intercompany Setup for OM:

OM Process
Setup New Sales Order Type in Selling Organization
Assign Document Sequence
Setup AR Transaction Type

AR Process
Setup New Credit Memo Transaction Type for Shipping Organization
Setup SMP Invoice Transaction Type for Shipping Organization
Create and Assign Document Sequence for Shipping Organization
Grouping Rule for Shipping Organization
Setup Transaction Source for Shipping Organization
Setup Intercompany Transaction Flow between Selling and Shipping Organization

[OM] Order Import - Basic Minimal SQL Statement

INSERT INTO oe_headers_iface_all
(order_source_id, orig_sys_document_ref, operation_code,
order_type_id, sold_to_org_id, created_by, creation_date,
last_updated_by, last_update_date
)
VALUES (0, 'STANLEYK-01', 'INSERT',
1111, 15555, 17777, SYSDATE,
17777, SYSDATE
);

INSERT INTO oe_lines_iface_all
(order_source_id, orig_sys_document_ref, orig_sys_line_ref,
operation_code, inventory_item_id, ordered_quantity, created_by,
creation_date, last_updated_by, last_update_date
)
VALUES (0, 'STANLEYK-01', 'SK-01',
'INSERT', 11111, 2, 17777,
SYSDATE, 17777, SYSDATE
);

Thanks Dennis for his help.

Run Order Import concurrent program after insert, child program "Order Import Child Req1 (Order Import)" will be submitted at the same time. Note that order_source_id value is a MUST, if not given, the child program will not be launched.

To check error, go Order, Returns->Import Orders->Corrections