Delete record from Custom Table — Oracle Analytics

Oracle Fusion ERP Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion ERP Analytics

Categories

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

Delete record from Custom Table

Accepted answer
17
Views
1
Comments
Chetan007
Chetan007 Rank 1 - Community Starter
in Oracle Fusion ERP Analytics

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

Tagged:

Best Answer

  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics Coach
    edited Jan 2, 2025 2:13PM 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