My Oracle Support Banner

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

Last updated on AUGUST 19, 2019

Applies to:

Oracle Demantra Demand Management - Version 7.0.1 to 7.3.1 [Release 7 to 7.3.0]
Oracle Advanced Supply Chain Planning - Version 12.1.1 and later
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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.