asked on

CDG-01170

CDG-01170 when I generate some modules migrated from 6.0

Oracle Designer 6i
Oracle Developer 6i with patch 1 installed

We have table A, B and C. Table C is a child table of parent table A and B. The 2 Fks of table C are part of a mandatory arc.

If you try to generate a module having the master-detail components "A and C" or "B and C" you will get error CDG-01170.

We have many modules like that, migrated from Oracle Designer 6.0. There were no problems in Oracle Designer 6.0.

In Oracle Designer 6i I need to remove the arc to make it works.

Is this a bug or a new behavior ? We need to know before performing the official migration to 6i.

bestoracleexpert

Hi,

You cannot have mandatory ARC relationship, the FKs should be optional. Check the FK property in the child table.

Tried this steps,

Designer 6.0 ,

1. Created P1 and P2 tables with child CH1 table,
P1 and P2 have arc relationship with CH1. set the validate FK =client,

2. Created form module based on P1 and CH1 ,
Generated form based on default template/olb and default settings,
This generated fine and was able to insert into CH1 table,

3. Migrated the application into 6i,
No discrepencies found,
Was able to generate the form based on default template/olb and the form behaved the as in 6.0 ,

Didnot get CDG-1170 error in 6i,

Confirm if I am missing something,

There are no problems logged on this issue using ARC and 6i is expected to behave the same as in 6.0 ,

ASKER CERTIFIED SOLUTION

ramaswamymorla

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

krishbest

ASKER

Can you tell me a test case?

krishbest

ASKER

Can you tell me a test case?