Looping Through a JSON Array in PL/SQL 12.1: Alternatives to JSON_TABLE Function

Using Common Table Expressions (CTEs) in Oracle: Simplifying Updates with Derived Tables and MERGE Statement

I can help with some of the issues you're facing.