ORA-39166: Object was not found.

impdp  done through DBMS_DATAPUMP API .

It performs  import from one schema to  other schema . Fileterd on selected tables  and if  table exist then append option is used .

.

Below is part of the script

tables is the input variable conataining table names.

DBMS_DATAPUMP.set_parameter(h1, 'TABLE_EXISTS_ACTION', tExist);

    DBMS_DATAPUMP.metadata_filter(h1, 'SCHEMA_LIST', '''CBEX_GM_SM'''); --''''||from_schema||'''');
    DBMS_DATAPUMP.metadata_remap(h1,'REMAP_SCHEMA','CBEX_GM_SM','CBRIDGESM'); --from_schema, to_schema);
    DBMS_DATAPUMP.metadata_filter(h1, 'NAME_LIST', tables, 'TABLE');

Log shows

ORA-39166: Object CBEX_GM_SM.PSV_DOCUMENT was not found.