GETENV ('DELTASTATS','TABLE'...) Returning Zero In CDR Exception When Mapping From PDB To PDB (Doc ID 2918736.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

GETENV ('DELTASTATS','TABLE'...) returning zero in cdr exception when mapping from pdb to pdb

cnt_cdr_conflicts = @GETENV ('DELTASTATS','TABLE', @GETENV ('GGHEADER','TABLENAME'),'CDR_CONFLICTS'),
cnt_cdr_resolutions = @GETENV ('DELTASTATS','TABLE', @GETENV ('GGHEADER','TABLENAME'),'CDR_RESOLUTIONS_SUCCEEDED'),
cnt_cdr_failed = @GETENV('DELTASTATS','TABLE', @GETENV ('GGHEADER','TABLENAME'),'CDR_RESOLUTIONS_FAILED')

All return zero if mapping from a cdb to a cdb (with different names) during exception mapping

Checking the exception table shows that the getenv stats or deltastats return 0,

Select TABLE_NAME, CNT_CDR_CONFLICTS, count(*) cnt from <schema>.exceptions group by TABLE_NAME, CNT_CDR_CONFLICTS;

TABLE_NAME CNT_CDR_CONFLICTS CNT
-------------------------------- ----------------- ----------
CDB1_PDB1.<schema>.<Tablename> 0 4999

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.