ORA-40617
Cannot create JSON Relational Duality View 'string': using ABSENT ON NULL or NULL ON NULL clauses in JSON_ARRAYAGG() is not permitted.
Cause
ABSENT ON NULL or NULL ON NULL clause was used as part of the JSON_ARRAYAGG() function.
Action
Remove the ABSENT ON NULL or NULL ON NULL clause from the Duality View declaration, or use EMPTY ON NO ROWS instead.