Exclude tables from script-based extraction

By default, data from all tables is extracted. To exclude d certain tables from extraction, you need to edit the respective SQL script file and comment the table that should not be extracted.

The example below explains how to exclude the table AP_AWT_GROUPS from the Financial Close Insight. The steps are same for all Insights:

Depending on the Oracle version you are using, edit the ExtractORAFCL.SQL or ExtractORAFCL_12-1.SQL file.
Comment the SELECT query for the objects to be excluded from extraction. To comment the query, place /* before the SELECT statement and place */ as the end of the SELECT statement. Refer to the example given below.

SET TERMOUT ON PROMPT Extracting AP_AWT_GROUPS SET TERMOUT OFF SPOOL

&1\AP_AWT_GROUPS.txt

SELECT NULL||'$$$$!@**'||'@B$R@C!I#D#'||'$$$$!@**'||GROUP_ID||'$$$$!@**'||END)||'$$ $

$$!@**'||DESCRIPTION||'$$$$!@**'||(CASE WHEN TO_CHAR(INACTIVE_DATE, 'YYYY-MM-DD

$HH24:MI:SS') < '1900-01-01 00:00:00' THEN '1900-01-01 00:00:00' ELSE TO_CHAR

NAME||'$(INACTIVE_DATE, 'YYYY-MM-DD HH24:MI:SS') END)||'$$$$!@**'||(CASE WHEN

(LAST_UPDATE_DATE, 'YYYY-MM-DD HH24:MI:SS') < '1900-01-01 00:00:00' THEN '1900-01-01

TO_CHAR00:00:00' ELSE TO_CHAR(LAST_UPDATE_DATE, 'YYYY-MM-DD HH24:MI:SS')

$!@**'||LAST_UPDATED_BY||'$$$$!@**'||LAST_UPDATE_LOGIN||'$$$$!@**'||(CASE WHEN

$TO_CHAR(CREATION_DATE, 'YYYY-MM-DD HH24:MI:SS') < '1900-01-01 00:00:00' THEN

'1900-01-01 00:00:00' ELSE TO_CHAR(CREATION_DATE, 'YYYY-MM-DD HH24:MI:SS') END)||'$

$$!@**'||CREATED_BY||'$$$$!@**###' FROM AP_AWT_GROUPS

SPOOL OFF