Memory-based Snapshot Worker Completing With Error - APP-FND-01564: ORACLE error 3149 in mrllis_load_item_sourcing (Doc ID 2030649.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Materials Requirement Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

12.1.3 in Production

PROBLEM
-------------
MRP fails in Snapshot phase with error.
Was running fine previously.

In file Request_log_files.zip --- In log . l2311552.req

MRCNSP module: Memory-based Snapshot
....
APP-FND-01564: ORACLE error 3149 in mrllis_load_item_sourcing

Cause: mrllis_load_item_sourcing failed due to ORA-03149: Invalid Oracle error code
.

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=914
gthsk2=3
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: -3149

***** End Of Program - Memory-based Snapshot *****
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Date falls outside the boundaries of the workday calendar

Cause: The current date is outside the range of valid workdays. The date is either before the start of the workday calendar or after the end of the workday calendar.

Action: Extend the boundaries of your workday calendar.


STEPS
--------
Run normal plan

EXPECTED BEHAVIOR
----------------------------
will complete successfully

BUSINESS IMPACT
----------------------
Plant cannot work

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms