In OAC Report column value of complete length is not coming

Indra Sardana-Oracle

Summary:

In OAC report column values are expected like :

Antigua and Barbuda

Bosnia and Herzegovina

Central African Republic

Equatorial Guinea

Ecuador

Where as in OAC report column values are coming :

Antigua

Bosnia

Central

Equator

Ecuador

Whereas in database in table column is defined as Varachar2(200) and values are present like :

Antigua and Barbuda

Bosnia and Herzegovina

Central African Republic

Equatorial Guinea

Ecuador

Any Input what could be possible reason.

Wayne Van Sluys

check the column in the RPD.

Indra Sardana-Oracle

In RPD also column is Varchar

Wayne Van Sluys

in each layer check that the column does not have a formula. Check in Physical Layer that it is querying same column in DB that you expect and do show values on that column

Anirban Basu-133546

Hi Indra ,

Can you get the session query of the OAC report and run the same in DB and check what is the output for that column

thanks

Anirban

Bharath Raghupathi-Oracle

Hi Indra,

One possibility is In the Physical layer check the column datatype length. It might be defined as varchar(7) as we are seeing only the first 7 characters.

Thanks,

Bharath

Sahithi Kolasani-Oracle

Agree with Bharath. Please check the column datatype length in RPD.

Indra Sardana-Oracle

Thanks Bharath and Sahithi and Wayne

Issue was with column length defined at physical layer it was Varchar2(7) instead of Varchar2(200)

Regards,

Indra Sardana