Sunday, January 17, 2021

Order Managerment Status flow

 

Order&Shipping Transactions Status Summary

StepOrder Header StatusOrder Line StatusOrder Flow Workflow Status (Order Header)Line Flow Workflow Status (Order Line)Shipping Transaction  Status(RELEASED_STATUS in WDD)
1. Enter an OrderEnteredEnteredBook Order ManualEnter – Line                             N/A
2. Book the OrderBookedAwaiting ShippingClose OrderSchedule ->Create Supply ->Ship – Line                      Ready to Release(R)
3. Pick the OrderBookedPickedClose OrderShip – Line1.Released to Warehouse(S)(Pick Release but not pick confirm)  2.Staged/Pick Confirmed(Y)(After pick confirm)
4. Ship the OrderBookedShippedClose OrderFulfill – Deferred1.Shipped(After ship confirm)  2.Interfaced(C)(After ITS)
BookedClosedClose OrderFulfill ->Invoice Interface ->Close Line -> End
5. Close the OrderClosedClosedEndEnd

Thursday, January 7, 2021

Declare Array in PL/SQL

 


-- declare NUMBER of Array TYPE and Parameter
TYPE t_number_array IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
number_array          t_number_array;


-- declare VARCHAR2 的 Array TYPE and Parameter
TYPE t_varchar2_array IS TABLE OF VARCHAR2(3) INDEX BY BINARY_INTEGER;
string_array          t_varchar2_array;

-- 塞值進 Number Array 
number_array(1) := 123;
number_array(2) := 456;
number_array(3) := 789;

Tuesday, January 5, 2021

Re-open Inventory accounting period

Re-open Inventory accounting period


2. SELECT acct_period_id period, open_flag, period_name name,
period_start_date, schedule_close_date, period_close_date
FROM org_acct_periods
WHERE organization_id = &org_id
order by 1,2;

3. UPDATE org_acct_periods
SET open_flag = 'Y',
period_close_date = NULL,
summarized_flag = 'N'
WHERE organization_id = &&org_id
AND acct_period_id >= &&acct_period_id;



DELETE mtl_period_summary
WHERE organization_id = &org_id
AND acct_period_id >= &acct_period_id;



DELETE mtl_period_cg_summary
WHERE organization_id = &org_id
AND acct_period_id >= &acct_period_id;



DELETE mtl_per_close_dtls
WHERE organization_id = &org_id
AND acct_period_id >= &acct_period_id;



DELETE cst_period_close_summary
WHERE organization_id = &org_id
AND acct_period_id >= &acct_period_id;