PGnC Compliance Rollup Is Failing with Error:"java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000"
Last updated on NOVEMBER 19, 2016
Applies to:Oracle Agile PLM Framework - Version 18.104.22.168 to 22.214.171.124 [Release 126.96.36.199 to 9.3.2]
Information in this document applies to any platform.
When attempting to run Compliance rollup the following error occurs.
Thread-571 <RollupUtil:ERROR> Smart Rollup failed to get items' direct pending and latest parents.
Exception Occurred when performing Compliance Rollup Task : java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000
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