Page 1 of 1

Data load - disabling code combinations

Posted: Wed Mar 10, 2010 8:24 am
by benny
Hi Members,

We have a requirement of disabling around 3000 code combinations in GL 11i, could anyone share any template if they have worked on any such requirement.I have tried to build a template looking at the data load commands however was not successful.

Your help is appreciated.

Rgrds
Ben[?]

Posted: Wed Mar 10, 2010 12:14 pm
by oteixeira
Hello Benny.

Try building this template:

R1C1 = \{F11}
R1C2 = TAB
R1C3 = TAB
R1C4 = the concatenated segments of the account to be disabled
R1C5 = \^{F11}
R1C6 = \
R1C7 = \^S

Let me know if it worked.

Octavio

Posted: Wed Mar 10, 2010 12:51 pm
by AmanKhan
Its not difficult, I have done similar exercise for enabling budget on CC in R12. I am not sure if there is any change in 11i & R12 CC form.

Follow above commands and let us know if u still need help.

Regards,

Posted: Thu Mar 11, 2010 12:35 pm
by benny
Hi Octavio,

The script is working only till the poing of Querying the code combination and stops. However it does'nt disable the Enable check box of the code combination.

Could you help me to have the code combination disabled.

Rgrds
Ben[?]

Posted: Thu Mar 11, 2010 2:04 pm
by oteixeira
Hello Benny.

That happened to me also. Try the following:
In Dataload, delete the cell containing the "\" keystroke and enter a space on it. Then, from the menu, choose Edit/Convert to/Keystroke. Retry to see if it works.

Octavio