Modifying Staged Data

If you find problems in the data you’ve staged in the RAP database (specific to RI/AIF input interfaces) you have the option to directly update those tables from APEX, thus allowing you to reprocess the records without uploading new files through FTS. You have the privileges to insert, delete, or update records in tables where data is staged before being loaded into the core data model, such as W_RTL_INV_IT_LC_DY_FTS for inventory data.

Directly updating the staging table data can be useful for quickly debugging load failures and correcting minor issues. For example, you are attempting to load PRODUCT.csv for the first time and you discover some required fields are missing data for some rows. You may directly update the W_PRODUCT_DTS table to put values in those fields and rerun the POM job, allowing you to progress with your dataload and find any additional issues before generating a new file. Similarly, you may have loaded an inventory receipts file, but discovered after staging the file that data was written to the wrong column (INVRC_QTY contains the AMT values and vice versa). You can update the fields and continue to load it to the target tables to verify it, and then correct your source data from the next run forwards only.

These privileges extend only to staging tables, such as table names ending in FTS, DTS, FS, or DS. You cannot modify internal tables holding the final fact or dimension data. You cannot modify configuration tables as they must be updated from the Control & Tactical Center. The privileges do not apply to objects in the RDX or PDS database schemas.