This discussion is archived
1 Reply Latest reply: Jul 24, 2013 6:04 PM by Leno Sun RSS

MRP Plan Error

Leno Sun Newbie
Currently Being Moderated

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 Newbie
    Currently Being Moderated

    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

     

     

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points