Safety Stock:
Safety stock is a quantity of stock you plan to remain in inventory to protect against fluctuations in
demand or supply. Safety stock is sometimes referred to as over planning, forecast, or a market hedge.
In the context of master scheduling,safety stock refers to additional inventory planned as protection
against forecast errors or short term changes in the backlog. You can specify safety stock days
together with safety stock percent as item attributes in Oracle Inventory.
Navigation:
Go to Inventory ->Planning -> Safty stock
and enter the item and safty stock
base tables:MTL_SAFETY_STOCKS
Validations:
.item validation
.organization validation
Mandatory Columns: item name,organization code,effectivity_date,safety_stock_quantity
Conversion Steps:
1)we should create temparory table with following columns item name,organization code,effectivity_date,safety_stock_quantity
2)we should create stage table with all the temporory table columns and also add who columns and ADD errro code,error message columns
to know the status of the record whether it is failed or successed
3)from item name we get inventory item id(l_item_id)
4)from organization code we get oraganization id(l_org_id)
5)pass this values in to API(MTL_SAFETY_STOCKS_PKG.INSERT_SAFETY_STOCKS).
how to pass values to API and also what are the values need to be passed is below:
BEGIN
MTL_SAFETY_STOCKS_PKG.INSERT_SAFETY_STOCKS( l_org_id--org_id NUMBER,
,l_item_id--item_id NUMBER,
,null--ss_code NUMBER,
,null--forc_name VARCHAR2,
,null--ss_percent NUMBER,
,null--srv_level NUMBER,
,effectivity_date--ss_date DATE,
,Safety_Stock_Quantity--ss_qty NUMBER,
,null--login_id NUMBER,
,fnd_global.user_id --user_id NUMBER)
);
dbms_output.put_line('l_item_id');
dbms_output.put_line('l_org_id');
END;
6)once API run,it will directly hit the base table,u can check it in base table
7) to see in front end,go to inventory resposibility-->planning-->Safty stock,now form will open,in which give the item name and press find option.
we can able to see record we inseted into base table
Safety stock is a quantity of stock you plan to remain in inventory to protect against fluctuations in
demand or supply. Safety stock is sometimes referred to as over planning, forecast, or a market hedge.
In the context of master scheduling,safety stock refers to additional inventory planned as protection
against forecast errors or short term changes in the backlog. You can specify safety stock days
together with safety stock percent as item attributes in Oracle Inventory.
Navigation:
Go to Inventory ->Planning -> Safty stock
and enter the item and safty stock
base tables:MTL_SAFETY_STOCKS
Validations:
.item validation
.organization validation
Mandatory Columns: item name,organization code,effectivity_date,safety_stock_quantity
Conversion Steps:
1)we should create temparory table with following columns item name,organization code,effectivity_date,safety_stock_quantity
2)we should create stage table with all the temporory table columns and also add who columns and ADD errro code,error message columns
to know the status of the record whether it is failed or successed
3)from item name we get inventory item id(l_item_id)
4)from organization code we get oraganization id(l_org_id)
5)pass this values in to API(MTL_SAFETY_STOCKS_PKG.INSERT_SAFETY_STOCKS).
how to pass values to API and also what are the values need to be passed is below:
BEGIN
MTL_SAFETY_STOCKS_PKG.INSERT_SAFETY_STOCKS( l_org_id--org_id NUMBER,
,l_item_id--item_id NUMBER,
,null--ss_code NUMBER,
,null--forc_name VARCHAR2,
,null--ss_percent NUMBER,
,null--srv_level NUMBER,
,effectivity_date--ss_date DATE,
,Safety_Stock_Quantity--ss_qty NUMBER,
,null--login_id NUMBER,
,fnd_global.user_id --user_id NUMBER)
);
dbms_output.put_line('l_item_id');
dbms_output.put_line('l_org_id');
END;
6)once API run,it will directly hit the base table,u can check it in base table
7) to see in front end,go to inventory resposibility-->planning-->Safty stock,now form will open,in which give the item name and press find option.
we can able to see record we inseted into base table