ORA-00604 and ORA-04031 Error When Running SDK Program to Fetch BOM Table
(Doc ID 2331194.1)
Last updated on NOVEMBER 22, 2017
Applies to:Oracle Agile PLM Framework - Version 188.8.131.52 and later
Oracle Agile Product Collaboration - Version 184.108.40.206 and later
Information in this document applies to any platform.
When trying to fetch BOM data from agile using SDK program, below error is generated
ORA-00604: error occurred at recursive SQL level 3
ORA-04031: unable to allocate 104 bytes of shared memory ("shared pool","select /*+ rule */ bucket, e...","SQLA^956ebc38","opn: qkexrInitOpn")
Steps to Reproduce
The issue can be reproduced at will with the following steps:
- Run SDK program to fetch BOM table of the item
- Gets error
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!