E-ORA PSDDLMODEL Changes Are Not Being Picked Up (Doc ID 1909941.1)

Last updated on FEBRUARY 01, 2023

Applies to:

Symptoms

On : 8.52.21 version, Database-Oracle 11.2.0.3.8 64 bit


ACTUAL BEHAVIOR
---------------
When attempting to change Oracle DDL models statement 4 and 5, the changes are not being used when running processes.


EXPECTED BEHAVIOR
-----------------------
The changes made to the DDL models should be in effect while running process

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. navigate Peopletools > Utilities > administration > DDL Model Defaults
2. Select Oracle

3. got to statement 4
DBMS_STATS.GATHER_TABLE_STATS (ownname=> [DBNAME], tabname=>[TBNAME], estimate_percent=>1, method_opt=> 'FOR ALL INDEXED

COLUMNS SIZE 1',cascade=>TRUE);

Or go to statement 5

DBMS_STATS.GATHER_TABLE_STATS (ownname=> [DBNAME], tabname=>[TBNAME], estimate_percent=> dbms_stats.auto_sample_size,

method_opt=> 'FOR ALL INDEXED COLUMNS SIZE 1',cascade=>TRUE);

4. Change anything on the above statements and change are not reflected if a Process is ran

BUSINESS IMPACT
-----------------------
The impact of the issue is minimal as users are affected

Cause

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