14 Replies Latest reply on Jul 9, 2019 8:11 PM by JessicaWilson

    Min-Max Planning 'Unable to Generate Requisitions'

    Greybeard_1901

      This should be an easy fix, but it has me stumped.

       

      Running min-max at org level. Item defined in source and destination orgs.

       

      Item is inventory, asset, costed,  min-max planned, with make/Buy set to BUY. Source is Inventory, with source org and subinventory defined. List price set. Internal order item set.

       

      Shipping network between both orgs defined

       

      Price list defined

       

      Location defined and associated with Ship-To of internal Customer

       

      Sourcing Rule defined, with type of Transfer From, assigned to group and group declared as default assignment in profile options

       

      When min-max report run, error message is output for each item. Log file looks like this:

       

      +---------------------------------------------------------------------------+

      Inventory: Version : 12.0.0

      Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

      INVISMMX module: Min-max planning report

      +---------------------------------------------------------------------------+

      Current system time is 09-JUL-2019 07:37:44

      +---------------------------------------------------------------------------+

      +-----------------------------

      | Starting concurrent program execution...

      +-----------------------------

      Arguments

      ------------

      P_ORG_ID='642'

      P_LEVEL='1'

      P_SELECTION='3'

      P_CAT_SET_ID='1'

      P_CATG_STRUCT_ID='101'

      P_ITEM_LO='400-01-S03'

      P_ITEM_HI='400-01-S03'

      P_SORT='1'

      P_D_CUTOFF='2019/07/09 00:00:00'

      P_D_CUTOFF_REL='0'

      P_S_CUTOFF='2019/07/09 00:00:00'

      P_S_CUTOFF_REL='0'

      P_USER_ID='16981'

      P_RESTOCK='1'

      P_DD_LOC_ID='164727'

      P_NET_UNRSV='1'

      P_NET_RSV='1'

      P_NET_WIP='1'

      P_INCLUDE_PO='1'

      P_INCLUDE_MO='1'

      P_INCLUDE_WIP='1'

      P_INCLUDE_IF='1'

      P_INCLUDE_NONNET='2'

      P_LOT_CTL='3'

      P_DISPLAY_MODE='1'

      P_SHOW_DESC='2'

      P_PUR_REVISION='2'

      P_EXCLUDE_CYC='2'

      ------------

      Execution options

      TRACEOPTS=TRACE_ALL TRACEFILE=$APPLTMP/dbg2002.log

      APPLLCSP Environment Variable set to :

      Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

      AMERICAN_UNITED KINGDOM.UTF8

      '.,'

      Enter Password:

      REP-0719: Cannot write to trace file '$APPLTMP/dbg2002.log'.

      MSG-00069: Calling INV_MMX_WRAPPER_PVT.exec_min_max from Before Report Trigger

      Report Builder: Release 10.1.2.3.0 - Production on Tue Jul 9 07:37:45 2019

      Copyright (c) 1982, 2005, Oracle. All rights reserved.

       

      I've tried to get a trace, but as you can see, I'm getting REP-0719 error. I understand Patch 19627916. is out for this, but I'm DBA poor, so having to do without at the moment.

       

      Output looks like this:

       

      So suggestions as to what to look for next would be really appreciated.

       

      TIA