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!
I am working on an APEX application and am faced with an issue in which data present in the database is not read by the application. Rather, the application reads some of fields from the database and not the rest without throwing any error message. This small application has a main page that contains tombstone information about work projects we are engaged in and is represented by approximately 30 Oracle items of type ‘Database column' that are the fields of the main project overview table. This main page also has several interactive reports that allow the users to manipulate data from other related tables like project costs, project deliverables, project recommendations, etc. While the functionality to create/update/delete from these related tables works perfectly, I am still unable make the same functionality work for the main table and am unable to figure out why as Oracle is not giving me an error message. The changes I submit in the application clearly hit the database as I can see the record updated in the Oracle Object Browser or by querying in SQL commands. I have visually depicted the situation below and thank you in advance for any assistance. 1)Open project number ‘1982’ and populate with dummy data and ‘save’. 2) Entered data appears in the main table correctly 3) Open record project number 1982 and observe that only some of the fields are shown in the application even though the fields are clearly populated accurately in the underlying table.