1 Reply Latest reply: Jul 24, 2013 8:04 PM by Leno Sun RSS

    MRP Plan Error

    Leno Sun

      Dears All

       

      I'am testing the MRP to Release a PO as follows:

      1.  Create sourcing rule

      2.  Assign sourcing rule 

      3.  Create quotation or create blanket PO

      4.  Create Apporve Supllier List 

      5.  Set MRP: default Sourcing Assignment Set

      6.  Run MRP and release planned order

       

      The MRP plan is going well.

      But as soon as i set the sourcing rule separately(ex. supplier A:60% rank 1,supplier B:40% rank 1),  the MRP launch concurrent process(Memory-based Snapshot) is performed with errors.

      And when i set the sourcing rule with whole one back(ex. supplier A:100% rank 1, or supplier B:100% rank 1),  the MRP launch concurrent process is performed well again.

      So i am do sure that this error is related with sourcing rule.

      Can someone help to resolve this?

       

      Best Regards

      Leno

        • 1. Re: MRP Plan Error
          Leno Sun

          Error log :

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

          Master Scheduling/MRP: Version : 12.0.0

           

           

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

           

           

          MRCNSP module: Memory-based Snapshot

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

           

           

          Current system time is 24-JUL-2013 18:32:03

           

           

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

           

           

          Page Length = 93, Page Width = 132

           

           

          ===================================================================

          Debug Mode :        Disabled

          Output to Terminal : No

          Argument Method :   Database Fetch

          Trace Mode :        Disabled

           

           

          ===================================================================

          Argument 1 (ORG_ID) = 141

          Argument 2 (COMPILE_DESIG) = THMS_MRP4

          Argument 3 (LAUNCH_CRP_PLANNER) = 2

          Argument 4 (SNAPSHOT_WORKER) = 0

          Argument 5 (MON_PNAME) = 0

          Argument 6 (MON_REQUEST_ID) = 0

           

           

          ===================================================================

          The value of profile option 'MRP_RETAIN_DATES_WTIN_CAL_BOUNDARY' is N

           

           

          SELECT  TO_NUMBER(TO_CHAR(MIN(calendar_date),'j')),

          TO_NUMBER(TO_CHAR(MAX(calendar_date),'j'))

          FROM    bom_calendar_dates

          WHERE   calendar_code = :calendar_code

          AND    seq_num IS NOT NULL

          AND     exception_set_id = :exception_set_id

           

           

          Loading workday calendar. Please wait ..

          SELECT TO_CHAR(calendar_date, 'j')

          FROM   bom_calendar_dates

          WHERE  calendar_code = :calendar_code

          AND    exception_set_id = :exception_set_id

          AND seq_num IS NOT NULL

          ORDER BY calendar_date

          Loading workday calendar. Please wait ...

           

           

          Loading workday calendar. Please wait .                                     0:00

          args->default_demand_class = 

          args->demand_class = 

          args->sched_desig = THMS_MPS4

          args->request_id = 632499

          args->current_date = 2456498

          args->min_date =  = 2456447

          args->max_date = = 2460098

          args->first_date  = 2456447

          args->plan_type = 1

          args->part_include_type = 1

          args->reservation_flag = 1

          args->wip_flag = 1

          args->po_flag = 1

          args->cutoff_date = 2456682

          args->sched_type = 2

          args->demand_tf_type = 2

          args->overwrite_option = 1

          args->operation_schedule_type = 2

          args->plan_safeyt_stock = 1

          args->assignment_group_id = 0

          args->include_mds_days = -23453

          args->category_set_id = 1

          args->user_id       = 1150

          args->snp_worker   = 0

          args->org_id  = 141

          args->in_pipe_name = snp_ORA$PIPE$011611500001

          args->out_pipe_name = mon_ORA$PIPE$011611500001

          args->compile_desig = THMS_MRP4

          args->hour_uom = HR

          args->plan_capacity = 2

          args->unit_eff_enabled = 2

          args->mon_request_id= 

          CONCURRENT MRP MRCMON "ORG_ID=141" "COMPILE_DESIG=THMS_MRP4"             "REQUEST_ID=632499" "IN_PIPE=mon_ORA$PIPE$011611500001" "OUT_PIPE=snp_ORA$PIPE$011611500001"

          APP-FND-01406: Cannot find a printer driver for printer type HPLJ4SI and print style 1099RPORTRAIT

           

           

          Cause: A printer driver for printer type HPLJ4SI and print style 1099RPORTRAIT does not exist

           

           

          Action: Check that print style 1099RPORTRAIT is supported on printer type HPLJ4SI and a record exists in FND_PRINTER_INFORMATION

          APP-FND-01406: Cannot find a printer driver for printer type HPLJ4SI and print style LANDWIDE57

           

           

          Cause: A printer driver for printer type HPLJ4SI and print style LANDWIDE57 does not exist

           

           

          Action: Check that print style LANDWIDE57 is supported on printer type HPLJ4SI and a record exists in FND_PRINTER_INFORMATION

          APP-FND-01406: Cannot find a printer driver for printer type HPLJ4SI and print style ERW2Potrait(2001orlater)

           

           

          Cause: A printer driver for printer type HPLJ4SI and print style ERW2Potrait(2001orlater) does not exist

           

           

          Action: Check that print style ERW2Potrait(2001orlater) is supported on printer type HPLJ4SI and a record exists in FND_PRINTER_INFORMATION

          APP-FND-01406: Cannot find a printer driver for printer type HPLJ4SI and print style W2PAPER(2001orlater)

           

           

          Cause: A printer driver for printer type HPLJ4SI and print style W2PAPER(2001orlater) does not exist

           

           

          Action: Check that print style W2PAPER(2001orlater) is supported on printer type HPLJ4SI and a record exists in FND_PRINTER_INFORMATION

          APP-FND-01406: Cannot find a printer driver for printer type HPLJ4SI and print style ERW2Paper2001orlater

           

           

          Cause: A printer driver for printer type HPLJ4SI and print style ERW2Paper2001orlater does not exist

           

           

          Action: Check that print style ERW2Paper2001orlater is supported on printer type HPLJ4SI and a record exists in FND_PRINTER_INFORMATION

          APP-FND-01406: Cannot find a printer driver for printer type HPLJ4SI and print style RL1PAPER

           

           

          Cause: A printer driver for printer type HPLJ4SI and print style RL1PAPER does not exist

           

           

          Action: Check that print style RL1PAPER is supported on printer type HPLJ4SI and a record exists in FND_PRINTER_INFORMATION

          Launched concurrent request 632501 for workers

          Selecting Items                                                        9    0:00

          Flushed all buffers into MRP_SYSTEM_ITEMS                              9    0:00

          Selecting Discrete Job Info                                            7    0:00

          Selecting repetitive schedules info                                    0    0:00

          Selecting line capacity info                                           0    0:00

          Selecting BOM                                                          4    0:00

          APP-FND-01564: ORACLE error 1426 in mrllis_load_item_sourcing

           

           

          Cause: mrllis_load_item_sourcing failed due to ORA-01426: numeric overflow

          .

           

           

          The SQL statement being executed at the time of the error was: begin :l_sourcing_history := MRP_SOURCING_API_PK . mrp_get_sourcing_hi and was executed from the file 6676358/mrp/lib/mrlnex.pc.

          APP-MRP-22075: An internal error has occurred (mrnspxt, 14, 10005,  )

          @ERRORTEXT            Cause:        The current routine encountered the specified@ERRORTEXT  x        Action:        Contact your customer supportrepresentative.

          APP-MRP-22075: An internal error has occurred (mrnspgpt, 14, 202 , 10005,  )

          @ERRORTEXT            Cause:        The current routine encountered the specified@ERRORTEXT  x        Action:        Contact your customer supportrepresentative.

          APP-MRP-22075: An internal error has occurred (main, 13,  ,  )

          @ERRORTEXT            Cause:        The current routine encountered the specified@ERRORTEXT  x        Action:        Contact your customer supportrepresentative.

          gthsk1=10

          gthsk2=2

          gthsk3=1

          gthsk4=1

           

           

          Statement with the error:

          begin :l_sourcing_history := MRP_SOURCING_API_PK . mrp_get_sourcing_hi

          6676358/mrp/lib/mrlnex.pc

           

           

           

           

          SQL Error Code: -1426

           

           

          ***** End Of Program - Memory-based Snapshot *****

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

          Start of log messages from FND_FILE

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

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

          End of log messages from FND_FILE

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

           

           

           

           

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

          Executing request completion options...

           

           

          Output file size:

          0

           

           

           

           

          Output is not being printed because:

          The print option has been disabled for this report.

           

           

           

           

          Finished executing request completion options.

          Concurrent program returned no reason for failure.

           

           

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

          Exceptions posted by this request:

          Concurrent Request for "Memory-based Snapshot" has completed with error.

           

           

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

          Concurrent request completed

          Current system time is 24-JUL-2013 18:32:57

           

           

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