Publications - ERROR: ORA-01795: maximum number of expressions in a list is 1000

Issue

• When trying to publish a publication with more than 1000 changes using Oracle Database, an error occurs and the process fails:
  

  2023-04-04 14:59:53.645 ERROR [liferay/background_task-10][BackgroundTaskMessageListener:167] Unable to execute background task
  com.liferay.portal.kernel.log.LogSanitizerException: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000_ [Sanitized]
   at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) ~[ojdbc8.jar:12.2.0.1.0]
   at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) ~[ojdbc8.jar:12.2.0.1.0]
   at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) ~[ojdbc8.jar:12.2.0.1.0]

Environment

• DXP 7.4

Resolution

• This issue is fixed by LPS-176611. A hotfix must be built containing this LPS.