MSCNSP - Memory-Based Snapshot Error APP-FND-01564 ORA-00979 MRSNPO_SNP_SUP_CAP_INFO (Doc ID 1234816.1)

Last updated on APRIL 27, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.1 and later
Oracle Demantra Demand Management - Version 7.0.1 to 7.3.1 [Release 7 to 7.3.0]
Information in this document applies to any platform.

Symptoms

When attempting to run an ASCP plan the following error occurs in MSCNSP - Memory-based Snapshot:

Error:

APP-FND-01564: ORACLE error 979 in mrsnpo_snp_sup_cap_info

Cause: mrsnpo_snp_sup_cap_info failed due to ORA-00979: not a GROUP BY expression

The SQL statement being executed at the time of the error was: select max(po.transaction_id) ,po.inventory_item_id ,po.organization_i and was executed from the file .
APP-MRP-22075: An internal error has occurred (mrnspxt, 27, 10015, )
@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 , 10015, )
@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.
freeing calendar
Freeing calendar memory
kill_hsktree
mrepgrm_end_program
Error string=
Statement with the error:
select max(po.transaction_id) ,po.inventory_item_id ,po.organization_i


STEPS:
1. Advanced Supply Chain Planner Responsibility
2. Nav: Supply chain plan
3. Launch the plan
4. Plan fails in snapshot concurrent request

This happens on an instance with a Demantra Installation with the database initialization parameter cursor_sharing set to FORCE. If the database initialization parameter cursor_sharing is set to EXACT, then there is no problem. The ASCP plan will run without errors.

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