Skip to Main Content

Java Development Tools

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!

refresh a value of a field in form based on other fields in the form - ADF

User_1KZ3NAug 9 2018 — edited Aug 17 2018

Hi Guys,

i want to refresh the value of the field based on the other fields in the form.

I have performed the following steps but didn't helped. kindly suggest.

1. updated the attribute in the VO with Expression

if (CustNum != null)

{

return 'Y';

}

else

{

return 'N';

}

}

2. set autosubmit for CustNum filed & partial trigger for other field.

i didn't see value is getting refreshed.

********************Edited******************************

use case:

I have a form, which will insert a data into the table on click of the submit button.

Table have some customer related records.

For Example:

Table fields/ form inputs

cust_id (user editable field)

Cust_Name (user editable field)

Cust_department (user editable field)

Is_Cust_Active (not user editable field)

if user enter value for cust_id & Cust_Name , then Is_cust_active field has to auto populate with Y else it has to auto poupulate with N

Message was edited by: 2812601

This post has been answered by Cvele_new_account on Aug 9 2018
Jump to Answer

Comments

934699
Hi Chandana,

You can use XSLT Transform to perform this task. I would suggest to use Varray as input. If you still need to use Ref Cursor then you have to manually map these elements & attributes and you wont be able to map using Jdeveloper's design editor.

Thanks,
Maulik
919712
Hi Chandana,

I am using the ref cursor as my out parameter. When i am testing this composite, i am getting the below error.

Cause: java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'XXIER_MAIN_PROC' ORA-06550: line 1, column 7: PL/SQL: Statement ignored Check to ensure that the API is defined in the database and that the parameters match the signature of the API.

Any Idea on this...

Regards,
Sudheer
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 6 2018
Added on Aug 9 2018
8 comments
547 views