Oracle Fusion ERP Analytics

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Delete record from Custom Table

Accepted answer
11
Views
1
Comments
Rank 1 - Community Starter

Hi All,

we are using a custom table "MKT_REF_ENTITIES" to store data as a part of journal import and we have came across a occurrence where we need to delete few records from the above table can you suggest us the possible way to achieve that?

Thanks

Best Answer

  • Rank 6 - Analytics Lead
    edited January 2 Answer ✓

    Hi @User_EBVBI,

    It depends on the specifics and circumstances of the scenario but since this is a custom table, its in a custom schema so you have control over it and you can manually delete the records.

    If you also need to delete it from the data source, you may just want to delete it there first and allow your Pipeline to reconcile the difference.

    Regards,

    John

Welcome!

It looks like you're new here. Sign in or register to get started.