INV Safety Stock Upload

➜ Back to Library
Description

INV Safety Stock Upload allows the user to:

  • Upload New Safety Stock Entries.
  • Update Existing Safety Stock Entries.
  • Delete Existing Safety Stock Entries (Delete by setting the ‘Delete This Entry’ = Yes).

Upload Modes:

Create Opens an empty spreadsheet where the user can enter new Safety Stock Quantities
Create or Update Create new Safety Stock entries and/or modify existing Safety Stock entries.

Allows the user to:

  • download existing Safety Stock entries based on the selection criteria specified in the report parameters.
  • modify (update/delete) the downloaded Safety Stock entries
  • create new Safety Stock entries

Download Parameters:

Organization Code The Organization(s) to which the safety stock belongs
Planner The Planner(s) to which the items with safety stock are assigned
Item Item(s)
Project Project(s) to which the safety stock is assigned
Task Task(s) to which the safety stock is assigned
Effective Date From Can be used to restrict based on the safety stock effective date
Effective Date To Can be used to restrict based on the safety stock effective date
INV Safety Stock Upload

Excel Upload Template:

INV Safety Stock Upload

In the Excel Upload Template, you can:

  • Update any existing entries that have been downloaded. You can modify the Project Number, Task Number (for project enabled organizations), the effective date (Effective date must be greater or equal to current date), quantity.
  • If you wish to delete an existing entry, set the ‘Delete This Entry’ column to Yes.
  • Create new safety stock entries

The columns with headings highlighted in Yellow are required columns and must be entered.

The columns shaded grey are read only for existing (downloaded) rows in the excel. They will be refreshed either by the excel or by the upload process.

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select
x.*
from
(
select
null action_,
null status_,
null message_,
null request_id_,
rowidtochar(mss.rowid) row_id,
mp.organization_code,
msiv.concatenated_segments item,
msiv.description item_description,
ppov.project_number,
ppov.project_name,
ptv.task_number,
ptv.task_name,
mss.effectivity_date effective_date,
msiv.primary_uom_code uom,
mss.safety_stock_quantity quantity,
null delete_this_entry,
xxen_util.meaning(mss.safety_stock_code,'MTL_SAFETY_STOCK',700) safety_stock_method,
mss.forecast_designator forecast,
mss.safety_stock_percent,
mss.service_level service_level_percent,
msiv.planner_code planner
from
mtl_safety_stocks mss,
mtl_parameters mp,
mtl_system_items_vl msiv,
pjm_projects_org_v ppov,
pjm_tasks_v ptv
where
:p_upload_mode like '%' || xxen_upload.action_update and
1=1 and
mss.organization_id = mp.organization_id and
mss.organization_id = msiv.organization_id and
mss.inventory_item_id = msiv.inventory_item_id and
mss.organization_id = ppov.inventory_organization_id (+) and
mss.project_id = ppov.project_id (+) and
mss.project_id = ptv.project_id (+) and
mss.task_id = ptv.task_id (+)
&not_use_first_block
&report_table_select &report_table_name &report_table_where_clause &success_records
&processed_run
) x
order by
x.organization_code,
x.item,
x.effective_date,
x.project_number,
x.task_number
Parameter Name SQL text Validation
Upload Mode 
 
 LOV
Organization Code 
mp.organization_code=:p_organization_code
 LOV
Planner 
msiv.planner_code=:p_planner_code
 LOV
Item 
msiv.concatenated_segments = :p_item
 LOV
Project 
mss.project_id in
(
select
ppov.project_id
from
pjm_projects_org_v ppov
where
ppov.inventory_organization_id = mss.organization_id and
ppov.project_number = :p_project_number
)
 LOV
Task 
mss.task_id in
(
select
ptv.task_id
from
pjm_tasks_v ptv
where
ptv.project_id = mss.project_id and
ptv.task_number = :p_task_number
)
 LOV
Effective Date From 
mss.effectivity_date>=trunc(:p_effective_date_from)
 Date
Effective Date To 
mss.effectivity_date<trunc(:p_effective_date_to)+1
 Date
Download
 
Related Blitz Reports
INV Onhand Quantities INV Safety Stocks PPF_WP3_OM_DETAILS ONT Orders and Lines MRP Item Forecast Upload Item_Forecast MRP Item Forecast ECC Discrete Completions, Assembly Completion Transactions ECC Discrete Manufacturing, Work Orders
Blitz Report™

Blitz Report™ provides multiple benefits: