My Oracle Support Banner

Alert Log Showing the Warning Messages Related to Parse of Pick Slip Request (Doc ID 2810557.1)

Last updated on OCTOBER 04, 2021

Applies to:

Oracle Shipping Execution - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.8 version, Pick Release

ACTUAL BEHAVIOR
---------------
Database alert logs are continuously showing the below messages related to Pick Selection List Generation - SRS. It exhausted the shared pool memory.

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
TMR(3):WARNING: too many parse errors, count=67400 SQL hash=0x69435dc7
TMR(3):PARSE ERROR: ospid=217521, error=6550 for statement:
2021-06-09T13:49:59.138368+03:00
TMR(3):BEGIN WSH_PICK_LIST.RELEASE_BATCH_SRS(:errbuf,:rc,:A0,:A1,:A2); END;
TMR(3):Additional information: hd=0xcab6c6fc8 phd=0xcac0e4c70 flg=0x180436 cisid=236 sid=236 ciuid=236 uid=236 sqlid=gj77r65nn6rf7
TMR(3):...Current username=APPS
TMR(3):...Application: e:ONT:cp:wsh/WSHPSRS Action: ONT/CONSUMER ORDER MNGT. SUPER USE

In the corresponding pick release log, below error is shown

24-JUN-2021 00:04:56]: **Starts**
[24-JUN-2021 00:04:56]: **SQL error and free**
[24-JUN-2021 00:04:56]: ORACLE error 6550 in FDPSTP

Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'RELEASE_BATCH_SRS'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


EXPECTED BEHAVIOR
-----------------------
Expect no error in the alert log.


STEPS
-----------------------
The issue cannot be reproduced at will.
Database alert logs are continuously showing too many parse errors related to Pick Selection List Generation - SRS. It exhausted the shared pool memory.

Changes

 

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
Changes
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.