Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Enable or Disable field based on a value for the current record

Paulo VenturaOct 19 2015 — edited Oct 23 2015

Hi experts!

I really do need your help, since I don't know what else I could do

I'm building a custom form here.

Long story short:

There's 3 values assigned to the "Tipo Pagto" field:

Padrão, Cartão and Permuta.

ora1.png

If the current record of this field is set to Padrão o Permuta, the next 2 fields, "Dt Pagamento" and "Número Invoice" should be disabled, like the image bellow

ora.JPG

But if Tipo Pagto is set to "Cartão", then, the 2 next fields, for the exactly same record should be available and updatable.

My current scenario is this:

ora2.JPG

When I set one to Cartão, it opens all rows and make it insertable aswell.

Also, when I fill the record where was Tipo Pagto as Cartão seted, and jump to the next record and change the value for Permuta or Padrão, the 1st record would now be disabled

ora3.JPG

Tried to use set_item_instance_property, but I'm on R12 and it doesn't work on it.

Tried SET_RECORD_PROPERTY, but then says that no field block exists.

Does someone has any tips?

Thanks in advance!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 20 2015
Added on Oct 19 2015
18 comments
23,888 views