Forum Stats

  • 3,852,564 Users
  • 2,264,114 Discussions
  • 7,905,099 Comments

Discussions

Issue with appmodule (adf jdeveloper)

3355505
3355505 Member Posts: 4
edited Dec 1, 2016 12:49PM in JDeveloper and ADF

Hello everyone, I'm facing an issue with AppModule, I cannot execute any action (insert, delete, save, edit ...) because all these butons are grayed out, I tried with several databases but it's always the same problem, I'm using JDev12.1.3 and Oracle Database 11g Express Edition, please anyone have a suggestion?adf.png

Tagged:
3355505

Best Answer

  • Timo Hahn
    Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,733 Red Diamond
    edited Nov 30, 2016 4:33PM Answer ✓

    Are your view objects based on entity objects or are they build from sql statements?

    In the later case it's normal as you can't insert, edit or remove  from view objects which are build on sql statements.

    Timo

    3355505

Answers

  • Timo Hahn
    Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,733 Red Diamond
    edited Nov 30, 2016 4:33PM Answer ✓

    Are your view objects based on entity objects or are they build from sql statements?

    In the later case it's normal as you can't insert, edit or remove  from view objects which are build on sql statements.

    Timo

    3355505
  • 3355505
    3355505 Member Posts: 4
    edited Nov 30, 2016 4:42PM

    All my views are based on entity objects

  • Timo Hahn
    Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,733 Red Diamond
    edited Nov 30, 2016 5:23PM

    Have you checked if the schema is writeable with e.g. sql developer or any other sql tool?

    And check that your entity is updatable in hte Vo definition

    pastedImage_0.png

    Timo

  • 3355505
    3355505 Member Posts: 4
    edited Nov 30, 2016 5:52PM

    I checked that my entities are updatable in View object definition, but the problem still exists.

    Also, I used sql developer to insert data in my schema (by insert into tables), I'm not sure if that's what you meant by checking if my schema is writeable.

  • amishra
    amishra Member Posts: 121 Bronze Badge
    edited Nov 30, 2016 9:36PM

    Can you also check if all the entity attributes which are part of EmpView1 have Updatable property not set to 'Never'

  • Timo Hahn
    Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,733 Red Diamond
    edited Dec 1, 2016 12:33AM

    Can you start a new project in a new application as a test to see if it's only in your current application?

    You just need to add one or two entities and view objects.

    Timo

  • 3355505
    3355505 Member Posts: 4
    edited Dec 1, 2016 12:48PM

    I found it, actually I did a stupid thing when creating entity objects, I created "Query based view object" instead of "Entity based view object" that's why all buttons were grayed out, thank you Tomi your answer was very helpful.

    adf2.png

This discussion has been closed.