In OAC Report column value of complete length is not coming
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.
Answers
-
check the column in the RPD.
0 -
In RPD also column is Varchar
0 -
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
0 -
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
0 -
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
0 -
Agree with Bharath. Please check the column datatype length in RPD.
0 -
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
0
