Transformation: "Multiple Exceptions thrown" Error When Saving A Table From NOT USED To USED (Doc ID 2952439.1)

Last updated on AUGUST 02, 2024

Applies to:

Symptoms

User is trying the map to source table with Union joining type and clicking on save button is throwing 'Multiple exception thrown error'.

User has added few tables newly and tried mapping. In between user tried to Mark as not used and marked as used. They tried to apply the solution from (Doc ID 2882316.1) and (Doc ID 2497760.1) to resolve the issue, but it still persists:

The user tried to Mark as Not Used and then, marked as Used because the needed a transformation logic change. When tables were mapped and click on save, the user hit Multiple exception thrown error. Then user marked the table as not used to verify validation goes successful for the transformation. Validation completed successfully when problematic table is marked as not sure. Again used tried to mark it as used and try mapping but getting same error when click save.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.