We encountered an error with the following query:

AND ((items.inventory_item_id is not null

AND items.inventory_item_id = sod.inventory_item_id(+))

OR items.inventory_item_id is null)

As Oracle Database 19.25 now adheres to the ANSI standard, which prohibits the use of partial outer joins with the ORand IN operators, we updated the query as follows:

AND ((items.inventory_item_id is not null

AND items.inventory_item_id = sod.inventory_item_id(+))

OR items.inventory_item_id(+) is null)

The change is as per example shared to us

However, we are still getting the same error. Can someone please help.

Thanks!