Oracle EBS?????(Order->AR)
- by Pan.Tian
????
??:Order Management > Orders,Returns > Sales Orders
???????,??,????,????
???????,????,??...
??Book Order,??Book??,????????Status??????“Booked”,???????"Awaiting Shipping",?????????,???????????????
??:??Book??,????????????,????Shipping Transactions Form,????,?????????Line Status?Ready to Release,Next Step?Pick Release
Pick Release
??:Order Management > Shipping > Release Sales Orders > Release Sales Orders
Pick Release????(?????????).?Order Number??????????
Auto Pick Confirm???No
Auto Allocate???N
Auto Allocate?Auto Pick Confirm??????Yes,???????????,??????No,???Yes??,?????Allocate?Pick Confirm??,???????????
??????????Pick Release,”Concurrent“??Pick Release?????Concurrent
Request???,"Execute Now"????????Pick
Release,??????????????User,??????Concurrent???
Pick Release?????????Pick Release?????Pick Wave??Move Order,??Move
Order????????????????????(Staging),????INV???????????
INV_MOVE_ORDER_PUB.CREATE_MOVE_ORDER_HEADER???Move Order??(??Pick
Release?????????????:Pick Release
Process)
????????,?Pick Release??,?????????????Reservation(??),?????????Soft Reservations,?????????????,????Org??????????
??:????,Shipping Transaction?Line Status?"Released
to Warehouse",Next Step?"Transact Move
Order";????????Booked,?????”Awaiting Shipping“?
Pick Confirm
Pick Confirm(????)????????Transact Move Order????,?Allocate????,?Transact Move Order.
??:Inventory > Move Orders > Transact Move Orders
????,Pick Wave??Tab,?????
??TMO????,??Allocate,Allocate?????????Picking
Rule?????,??????Suggestion????,Suggestion??????
MTL_MATERIAL_TRANSACTIONS_TEMP?(?Pending Transactions)?
????Allocate??,??????Allocation????Single,Multiple??None???,Single??,
??????????Suggestion?Transaction??,Multiple???????;None??????Suggestion?
?(????????????????)
????????Transact??Move Order
?Transact??,Inventory Transaction Manager ???Suggestion
Transactions(MMTT),???????????????,??????Subinventory??????(Staging)???
Transction???Material Transaction?Form?????
????Reservation??,?Transact??,???????,Reservation????????,????Sub,locator????
??:????,Shipping Transaction?Line Status?"Staged/Pick Confirmed",Next Step?"Ship Confirm/Close Trip Stop";????????Booked,??????”Picked“?
Ship Confirm Deliveries
??:Order Management > Shipping > Transactions
???Delivery??,??Ship Confirm(????),????Pick Release???,????Autocreate
Delivery,???????Define Shipping Parameters????????,??shipping
parameters???????,?????????Ship Confirm?????Action->Auto-create
Deliveries.
Delivery????????????????,????????....
Delivery??,??Ship Confirm???,???????,"Defer Interface"?????,?????????Interface Trip Stop SRS,????Defer Interface,?OK?
Delivery was successfully confirmed!!!
Ship Confirm????????????MTL_TRANSACTIONS_INTERFACE??,??MTI??????Sales
Order Issue,??????????Interface Trip Stop???,???MTI??MMT???
??:????,Shipping Transaction?Line Status?"Shipped",Next Step?"Run Interfaces";????????Booked,??????”Shipped“?
Interface Trip Stop - SRS
?????Ship Confirm??????Defer Interface,??????????????Interface Trip Stop - SRS?
??:Order Management > Shipping > Interface > Run > Request:Interface Trip Stop - SRS
Interface Trip Stop????????:Inventory Interface SRS(????????)? Order Management Interface SRS(?????????????AR??)?
Inventory Interface SRS???Shipping Transaction??????MTI,??INV
Manager????MTI????MMT??,??Sales Order
Issue?transaction??????,???????????Reservation????Inventory Interface
SRS?????,???WSH_DELIVERY_DETAILS??INV_INTERFACED_FLAG???Y?
Order Management Interface - SRS??Inventory Interface
SRS?????,??Request?????????????AR??,OM
Interface????????WSH_DELIVERY_DETAILS??OE_INTERFACED_FLAG?Y?
??:????,Shipping Transaction?Line Status?"Interfaced",Next Step?"Not Applicable";????????Booked,??????”Shipped“?
Workflow background Process
??:Inventory > Workflow Background Engine
Item Type:OM Order Line
Process Deferred:Yes
Process Timeout:No
??program????Deffered???workflow,Workflow Background Process???,???????Order????RA Interface???(RA_INTERFACE_LINES_ALL,RA_INTERFACE_SALESCREDITS_ALL,RA_Interface_distribution)
????????SQL???RA Interface??:
1.SELECT * FROM RA_INTERFACE_LINES_ALL WHERE sales_order = '65961';
2.SELECT * FROM RA_INTERFACE_SALESCREDITS_ALL
WHERE INTERFACE_LINE_ID IN (SELECT INTERFACE_LINE_ID FROM RA_INTERFACE_LINES_ALL WHERE sales_order = '65961' );
3.SELECT * FROM RA_INTERFACE_DISTRIBUTIONS_ALL
WHERE INTERFACE_LINE_ID IN (SELECT INTERFACE_LINE_ID FROM RA_INTERFACE_LINES_ALL WHERE sales_order = '65961' );
?????RA
Interface??,??OE_ORDER_LINES_ALL?INVOICE_INTERFACE_STATUS_CODE?????
Yes,INVOICED_QUANTITY?????????????????????????Closed,????????Booked?
AutoInvoice
????AR??
??:Account Receivable > Interface > AutoInvoice
Name:Autoinvoice Master Program
Invoice Source:Order Entry
Default Day:????
???,?request????”Autoinvoice Import Program“????
???,????Auto Invoice
Program????RA?interface?,?????????????,???????AR????
(RA_CUSTOMER_TRX_ALL,RA_CUSTOMER_TRX_LINES,AR_PAYMENT_SCHEDULES).
?????? Order > Action > Additional Information > Invoices/Credit Memos????????,???????SQL?????AR??,
SELECT ooha.order_number , oola.line_number so_line_number , oola.ordered_item ,
oola.ordered_quantity * oola.unit_selling_price so_extended_price ,
rcta.trx_number invoice_number , rcta.trx_date , rctla.line_number inv_line_number ,
rctla.unit_selling_price inv_unit_selling_price
FROM oe_order_headers_all ooha , oe_order_lines_all oola , ra_customer_trx_all rcta , ra_customer_trx_lines_all rctla
WHERE ooha.header_id = oola.header_id
AND rcta.customer_trx_id = rctla.customer_trx_id
AND rctla.interface_line_attribute6 = TO_CHAR (oola.line_id)
AND rctla.interface_line_attribute1 = TO_CHAR (ooha.order_number)
AND order_number = :p_order_number;
??Autoinvoice Import Program???error???,?????RA_INTERFACE_ERRORS_ALL?Message_text??,????????
Closing the Order
?????????,?????????(Close??Cancel)?0.5?,??????Workflow Background Process???????
????????:you can wait until month-end and the “Order Flow – Generic” workflow will close it for you.
Order&Shipping Transactions Status Summary
Step
Order Header Status
Order Line Status
Order Flow Workflow Status (Order Header)
Line Flow Workflow Status (Order Line)
Shipping Transaction Status(RELEASED_STATUS in WDD)
1. Enter an Order
Entered
Entered
Book Order Manual
Enter – Line
N/A
2. Book the Order
Booked
Awaiting Shipping
Close Order
Schedule ->Create Supply ->Ship – Line
Ready to Release(R)
3. Pick the Order
Booked
Picked
Close Order
Ship – Line
1.Released to Warehouse(S)(Pick Release but not pick confirm)
2.Staged/Pick Confirmed(Y)(After pick confirm)
4. Ship the Order
Booked
Shipped
Close Order
Fulfill – Deferred
1.Shipped(After ship confirm)
2.Interfaced(C)(After ITS)
Booked
Closed
Close Order
Fulfill ->Invoice Interface ->Close Line -> End
5. Close the Order
Closed
Closed
End
End
????,shipping txn???,??????????:http://blog.csdn.net/pan_tian/article/details/7696528
======EOF======