Hi Team, Any idea, why generic path expression based renaming of JSON fields does not work? A sample- 1. Below function transform top layer, but leaves nested layer. Select JSON_TRANSFORM('{"field_a": 2, "field_b": 3 , "nested" : {"nested1":{"field_a":2, "field_b":3 }}}', RENAME '$..field_a'='field_c') from DUAL; Output: {"field_b":3,"nested":{"nested1":{"field_a":2,"field_b":3}},"field_c":2} 2. While below can be alternate, but practically impossible with complex documents.