Alert Log Showing the Warning Messages Related to Parse of Pick Slip Request
(Doc ID 2810557.1)
Last updated on MARCH 20, 2023
Applies to:
Oracle Shipping Execution - Version 12.2.8 and laterInformation 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]: **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 |