Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Load Definitions: Error Handling - Log Error into Collection

MPkgJul 17 2023 — edited Jul 17 2023

Hello,

Is there an instruction how to setup Error Handling - Log Error into Collection in Data Load Definitions?

It seems that I cannot find any article about this. Maybe there is an example as well?

I would use Log into Error Log but the problem is that it functions “only if the Append method is used without a primary key”. This is why I guess I need an Collection.

While setting Log Error into Collection, there is field to write a name of the collection where the error is stored. Do I need to create this collection? Do I create it in Shared components or in a query?

I am using a process of type Data Loading for my XLSX upload;

In setting I have my Load definition declared. Here I have specified Error Handling - Log Error into Collection. Loading method is Merge, I have Primary Key and I have provided loading sample to the Definition;

all other settings are standard.

How do I import error rows from this XLSX upload process inside Collection, so I can show them in e.g. Interactive report?

I am really sorry if the is an obvious instruction but I have searched through internet for a whole day, so I guess it is a good time to ask here in this forum.

Tnx!

Comments
Post Details
Added on Jul 17 2023
2 comments
864 views