EBS first project learning summary, ebs first project summary

EBS first project learning summary, ebs first project summary

EBS organizational structure:

(1) Business Group (BG)

(2) Legal Entity (LE)

(3) Business Entity (OU)

(4) Inventory Organization (INV)

(5) Cost Center (Cost Center)

(6) HR Organization

(7) multi-organization Access Control

Ship Confirm shipping function module of Sale Order:

 

When changing the status, remember to modify the status of the WHO field.

 

Required table information:

Oe_order_headers_all order header information table

Oe_order_lines_all

-- Header_id = oe_order_headers_all.header_id
-- Order Line Info table

 

There is a concept:

For example

ORDER_NUMBER: 101852

There are two order headers.

HEADER_ID: A HEADER_ID: B

The concept of LINE_NUMBER is that the two orders belong to the same row as follows:

HEADER_ID: A B

LINE_NUMBER: 1 LINE_ID: A1 LINE_ID: B1

LINE_NUMBER: 2 LINE_ID: A2 LINE_ID: B2

LINE_NUMBER: 3 LINE_ID: A3 LINE_ID: B3

The sales order is a logical relationship.

Important Fields in oe_order_headers_all:

HEADER_ID order header id

Id of the REQUEST_ID concurrent request
ORG_ID: id of the business entity
SHIP_TO_ORG_ID the recipient's organization id
SHIP_FROM_ORG_ID the Organization id of the sender

Important Field in oe_order_lines_all
HEADER_ID order header id
Id of the REQUEST_ID concurrent request
ORG_ID organization id
LINE_ID order line id
LINE_NUMBER order line number
SHIP_TO_ORG_ID the recipient's organization id
SHIP_FROM_ORG_ID the Organization id of the sender

Wsh_delivery_details
-- Source_header_id = oe_order_headers_all.header_id
-- Source_line_id = oe_order_lines_all.line_id
Material shipment details table
DELIVERY_DETAIL_ID id of the ticket
SOURCE_HEADER_ID order header id
SOURCE_LINE_ID: Order line id
CUSTOMER_ID customer id
INVENTORY_ITEM_ID: id of the item corresponding to the item table
ORGANAZATION_ID id of the inventory Organization
Number of REQUESTED_QUANTITY requests
SHIPPED_QUANTITY quantity
SUBINVENTORY sub-inventory name
RELEASED_STATUS status of the current item
ORG_ID: id of the business entity
Id of the REQUEST_ID concurrent request
LOCATOR_ID goods inventory No.

LOT_NUMBER: batch number of the item

Wsh_delivery_assignments
-- Delivery_detail_id = wsh_delivery_details.delivery_detail_id
-- Connect the information table of wsh_delivery_details and wsh_new_deliveries.
-- Connect wsh_delivery_details in this phase

DELIVERY_ID producer
DELIVERY_DETAIL_ID Material id



Mtl_serial_numbers
Information table that records the current status of the item serial number
INVENTORY_ITEM_ID Material id
SERIAL_NUMBER serial number


Mtl_serial_numbers_temp
Table of serial number and bill of materials
Associated by transaction_temp_id





The shipping module can be understood as taking out the materials in the retained warehouse for shipment. The completion of the shipping confirmation indicates the transfer of this property right. There are many delays in delivery. For example, if the quantity of items you want to ship is insufficient to meet the buyer's quantity, you can delay delivery and wait until the quantity meets the same delivery conditions.

The shipping module obtains a pile of material orders after the material picking is completed, and generates a material number for each material order. The material number is used to let the shipping know, the materials to be shipped and the generation of item numbers may vary.

Shipping Module Interface operation:
Log on and find an owner with the responsibility of order management. Go to transaction processing.

You can query the order number based on the order number.

Each item corresponds to a bill of materials.
Detail is the item number.
Item Name is the Name of the Item.
Delivery is the sender of a material.
Line Status indicates the current Status of the item, and the Status is Staged/Pick Confirm.
Next Step is the Next state of the material.
Order is the Order number.

Requested Qty is the required quantity
Shipped Qty is the quantity to be Shipped
BackOrdered Qty indicates the quantity to be postponed

Serial Number is a Serial Number. If the Serial Number control is enabled for the item, Org Code is the current inventory organization, and subinventory sub-Inventory
If you want to ship, you must assign the item number,

Select the operation here. The only thing you know is:
Split Line branch. When the serial number is started, the branch rule is unknown for the moment, but the serial number is automatically assigned to the Split row.
Lauch Pick Release automatically picks up the database. This operation can be used to Pick up the Backordered or Ready to Release. In this case, it will automatically Pick up the database for this material order and assign a token.
Picking a database can be understood as distributing the materials in your inventory to the retained database. The materials in the retained database cannot be passive in the future, so that they are all allocated and waiting for shipment. Materials in stock can also be allocated.
Auto-create Deliveries

For the Blue Line in the figure, you can ship it at this time and enter the Delivery interface,

Click Ship Confirm to Ship.

Here are some instructions,

ShipConfirm Rule contains the shipping rules defined by the current system,

Click Ship Entered Quantities, and select the shipping method for the unknown quantity of materials on the right,
For example, if Requested Qty = 10 shipped qty = 5 backordered qty = 3, the unknown quantity is 2.
If ship is selected, the unknown quantity 2 will be shipped, that is, 7 will be shipped and 3 will be postponed
If Backorder is selected, the unknown quantity 2 is postponed, that is, 5 is postponed to 5
If Stage is selected, the unknown quantity is returned to the Staged/Pick Confirm status. This works with the following

If this option is selected, a producer is automatically assigned to the Staged/Pick Confirm status.
If Cyclecount is selected, the unknown number of items is returned to the Staged/Pick Confirm state, and the quantity of shipped Qty is empty.

Ship All means to Ship All materials. The same is true for others.
Note that a Trip Stop operation must be performed on the shipping ticket to determine whether the shipping is successful.

Code implementation is far more complex than interface implementation. First, we need to introduce several APIs used.

wsh_deliveries_pub.delivery_action(p_api_version_number => 1.0,                                       p_init_msg_list      => fnd_api.g_true,                                       x_return_status      => lv_return_status,                                       x_msg_count          => ln_msg_count,                                       x_msg_data           => lv_msg_data,                                       p_action_code        => 'CONFIRM',                                       p_delivery_id        => 104483,                                        p_delivery_name      => 104483,                                       p_sc_action_flag     => 'C',                                       p_sc_close_trip_flag => 'Y',                                       x_trip_id            => ln_trip_id,                                       x_trip_name          => lv_trip_name);

The input parameters here can be:

P_action_code has many values:

'PLAN','UNPLAN','PACK','CONFIRM','RE-OPEN','IN-TRANSIT','CLOSE', 'ASSIGN-TRIP','UNASSIGN-TRIP','AUTOCREATE-TRIP', 'WT-VOL', 'PICK-RELEASE', 'DELETE'

All I know is,

-- RE-OPEN: make the status reopen
-- DELETE: DELETE a part number.
-- CONFIRM: The Ship Confirm operation corresponds to the Ship confirm operation, and the operations in Actions:

p_sc_action_flag  ： ship confirm option - 'S', 'B', 'T', 'A', 'C'

This is equivalent

S is Ship B is backorder T is stag C is CycleCount A is Ship All

Other parameters include:

P_ SC _intransit_flag: Check whether Set Delivery In-transit is selected on the graph, and whether Y is N no

P_ SC _close_trip_flag: Check whether the Close Trip on the graph is checked, and Y is N no

P_ SC _stage_del_flag: Create Delivery for Staged Quan .. check box, Y is N no

P_ SC _trip_ship_method: varchar2 type input by Ship Method on the graph. It can be null.

P_ SC _actual_dep_date: indicates the Actual Departure Date on the graph. If it is null, the value is automatically assigned to the current time.

P_ SC _defer_interface_flag: Check whether the Defer Interface is selected on the graph, and Y is N no

Other APIs will be explained in a single article. If there is something wrong, I hope you can give comments and suggestions. Thank you.

How can a newbie officially start learning oracle ebs or ERP?

The fastest and best way to do this is to go to Party B for implementation. The experts will be on three different types of projects.
Otherwise, you can only learn one-sided learning or talk about it on paper.
 
Oracle ebs learning path

Make it clear, so no one will answer you.
Are you learning functions? Or technology?
If you want to learn functions, do you want to learn finance? Or learning about the supply chain?