Oracle Application Express ApEx - calculated field and list of values

Solve a small problem in Oracle Application Express (ApEx) version 3.1.

This is an old version of ApEx !

I need you to document how to create a list of values and populate a read only calculated / descriptive field based on the selected value



Document or video explaining how to do this.

Screen snapshots are probably sufficient

Language must be English

You can use any tables.

My example here uses EMPLOYEES / DEPARTMENTS demo tables

I dont need fancy documentation. It just needs to be good enough for me to understand how it works so I can make the changes to the actual application at my end

Screen Design


ApEx form with a region based on EMPLOYEES table

Emp Id [1234]

Emp Name [Joe Smith]

Salary [10000]]

Department Id [999] Department Name [Accounting]

Summary of requirements


Document how to do the following

1) create the list of values based on department

2) optionally make the department id field enterable (I dont mind if it is read only and can only be updated via the list of values

3) The department name will need to be recalculated when

3a) The user selects a department from the list of values

3b) The user enters a value in the department id field then tabs out of the field

3c) The user queries a different employee row which has a different department id

Department Id field


This is a foreign key field that joins to the Department Id primary key column in the Departments table

The value of this field is populated by the user selecting a value from the list of values via the LIST button

At your discretion, this field can either be

1) read only so the user can only enter a value in the field by selecting a value form the list.

or 2) enterable so the user can type a value in the field. In this case, the department name field

must refresh to show the matching department

List button


This button displays a list of departments and allow the user to select one row.

After selecting a department from the list of values, the department id and department name are displayed in the appropriate screen field

Department Name field


This is a display only calculated field

It displays the department name based on the value of the department id field

If the department id changes, the department name should be recalculated by retrieving the department name from the department table based on the department id

Skills: Oracle

See more: oracle list values, oracle apex read field, list values oracle apex, apex calculated field, type of use case, screen of the mind, problem in accounting field, problem in accounting, oracle apex demo, how to create accounting, field in accounting, example of a requirements document, employee express, application requirements document example, accounting express, needs of accounting, oracle queries, oracle application express, oracle apex, old 10000, express, EMP, Apex, accounting works, foreign key

About the Employer:
( 0 reviews ) Sydney, Australia

Project ID: #4764157

13 freelancers are bidding on average $176 for this job


Dear Sir, please let me help you. Regards: Peter.-

$111 USD in 3 days
(1 Review)

Hi I want to do the project. thanks.

$111 USD in 3 days
(2 Reviews)

I am working on APEX Oracle over 7+. I can do this job now.

$133 USD in 7 days
(1 Review)

Will support you!

$103 USD in 7 days
(1 Review)

i'm 14+ years experienced, ready to start work

$263 USD in 8 days
(0 Reviews)

I can help you

$150 USD in 5 days
(0 Reviews)

Please read PM

$157 USD in 5 days
(0 Reviews)

Hi sbovin, I can provide you a document which shows you how to create the List Of Values (LOV). I work with Apex (since it was known as HTMLDB) in a professional setting. So if you need more help please let me know.

$222 USD in 1 day
(0 Reviews)

I am an oracle apex developer and i can solve your request do contact me.

$222 USD in 4 days
(0 Reviews)

Hi, I am expert on Oracle Developer Suite and Oracle 9i to 11gR2 and Oracle Application Express ( Apex all version) . I have the experience on Oracle Database 10G/11G and Oracle SQL Query, Procedure, Function, Trigg More

$177 USD in 7 days
(0 Reviews)

I can do it

$600 USD in 30 days
(0 Reviews)

Let start with us......

$100 USD in 6 days
(0 Reviews)

Hi, We are team of Oracle Apex developer. We can execute this Project in Oracle apex in 3 days with video demonstration. Please let us know if you are interested. Regards, Mark

$111 USD in 3 days
(0 Reviews)

I am an IT professional with 3 years of experience working on APEX. Please check you inbox for more details about my proposal. Thank you,

$50 USD in 5 days
(0 Reviews)