Skip to Main Content

APEX

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!

Oracle Apex hidden item does not save to database

Anil kumar singhJul 5 2020 — edited Jul 9 2020

Hello ,

I have two regions :

Region 1 has the following fields :

ORG_ID

WIP_ENTITY_ID

JOB_NAME

Region 2 has the following fields:

ORG_ID

WIP_ENITTY_ID

JOB_NAME

FURNACE_NAME

POUR_TEMP

PRESSURE

In region 2, I have hidden the fields ORG_ID, WIP_ENTITY_ID, JOB_NAME. The region 2 is an Interactive Grid, based on a database table xx_furnace_data with the 6 database columns as listed in Region 2.

The process flow is as follows:

1. User enters the ORG_ID, JOB_NAME and the I query another table and get the value of WIP_ENTITY_ID

2. When the user navigates to Region 2 , which is an Interactive Grid, using Dynamic Action, I am able to copy the values of ORG_ID, WIP_ENTITY_ID and JOB_NAME from Region 1to Region 2.  Only the fields FURNACE_NAME, POUR_TEMP and PRESSURE are visible to users.

When the users save the data in the Interactive Grid, the ORG_ID, WIP_ENTITY_ID and JOB_NAME are null.

Then when I make these fields as textfield ,  I can see the ORG_ID, WIP_ENTITY_ID and JOB_NAME have the correct values and now after making the fields visible , it saves the data into the database.

How can I make the fields ORG_ID, WIP_ENTITY_ID and JOB_NAME  as hidden and at same time save their values in the database.

I did see a similar  discussion but that suggestion was not complete and it did not work.

Thanks

Anil

Comments
Post Details
Added on Jul 5 2020
22 comments
3,585 views