Discrete Manufacturing - EBS (MOSC)

MOSC Banner

Unable to perform wip over completion correctly using below script

 INSERT

INTO wip_move_txn_interface

 (

  transaction_id ,

  primary_item_id ,

  organization_id ,

  organization_code ,

  process_phase ,

  process_status ,

  wip_entity_id ,

  wip_entity_name ,

  transaction_date ,

  transaction_quantity ,

  transaction_uom ,

  transaction_type ,

  fm_operation_seq_num ,

  fm_intraoperation_step_type ,

  to_operation_seq_num ,

  to_intraoperation_step_type ,

  created_by ,

  created_by_name ,

  creation_date ,

  last_update_date ,

  last_updated_by ,

  last_update_login ,

  last_updated_by_name,

  OVERCOMPLETION_TRANSACTION_QTY,

   OVERCOMPLETION_PRIMARY_QTY

 )

 VALUES

 (

  lv_transaction_id ,

  i.primary_item_id ,

  i.organization_id ,

  i.organization_code,

  lv_process_phase ,

  lv_process_status ,

  i.wip_entity_id,        -- wip_entity_id

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center