Oracle SOA Suite (MOSC)

MOSC Banner

Create relationship database adapter

edited Feb 22, 2017 11:16AM in Oracle SOA Suite (MOSC) 8 commentsAnswered

I am trying to create a 1:M relationship, on database tables, using the database adapter. I have done this many times in JDev 11.* with no issues. In 12.2.1, I cannot get it working.

As I step through the wizard, I import my tables, as normal. The adapter then identifies a lack of primary keys and asks that I select with columns to use. I do this for all related tables. In the Create Relationship screen, I can select my parent table and my child table. Once I select the 1:M relationship radio button, the adapter correctly identifies my key on the root table but the drop down for the child table is empty. I am given nothing as an option to chose, even though I have already identified what should be a key

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center