How to increase the attribute length of Transaction Class

[Anon Anon]

When I describe transclass table, I see the transclass attribute of datatype varchar2 and of length 30.

 

Oracle SQL> desc transclass

Name	Null	Type
TRANSCLASS	NOT NULL	VARCHAR2(30)

 

But when we try to enter values in Clarity UI, Admin -> Finance -> Setup -> Classification ->Transaction Classes -> New, Transaction class cannot take the value of length more than 8.

 

My requirement was to add value of length 12, to find out where exactly the restriction was posed to clarity, I have used &debug method and found maxDatasize="8" is applied over this attribute.

I do queried our linux box where clarity is deployed to check  all the files which has the string maxDatasize="8", but i was unable figure out the file which i should modify to accomplish my objective.

Attached a text file which is pipelined output from linux machine(files with the string maxDatasize="8")

 

Any suggestion on which file i should modify to do this? and even if i do so, do we need to recycle the services to make it effective???

Attachment(s)

search_with_maxdata8.txt.zip   1 KB 1 version

[navzjoshi00]

I would suggest to check with support before taking this up

 

NJ

[Deactivated User]

My understanding is that the db lengths are longer than the GUI lengths to allow twobit characters.

Further you do not mess with OOTB field lenghts of an existing system unless you want to mess your system.

Transaction class is used in a number of places and that makes it particularly risky.

 

Do as Navzjoshi suggests open a case with support and if they give approval and provide instructions you have justification.