Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Multi Master Detail form in Oracle Applications

Re: Multi Master Detail form in Oracle Applications

From: Sunny <ransun512_at_gmail.com>
Date: 4 Dec 2006 12:46:36 -0800
Message-ID: <1165265196.811288.145940@j72g2000cwa.googlegroups.com>

Hellooooo any body at home....................

I am in really need for this solution.

Thank You

Regards
sunny

On Nov 30, 2:20 pm, "Sunny" <ransun..._at_gmail.com> wrote:
> Hi
>
> If I send you the form then I will be violating company policy.
>
> It can be done with any tables where each has it is own primary key and
> foreign key.
>
> Thank You
>
> Regards
> sunny
>
> On Nov 29, 5:55 pm, DA Morgan <damor..._at_psoug.org> wrote:
>
>
>
> > Sunny wrote:
> > > Hi,
>
> > > It does not work as I tried it way back.
>
> > > Thank You
> > > Regards
> > > sunny
>
> > > On Nov 29, 5:23 pm, DA Morgan <damor..._at_psoug.org> wrote:
> > >> Sunny wrote:
> > >>> Hi All,
> > >>> I have a unique problem I will be greatful if any one can help me out.
> > >>> I have 3 blocks, A, B and C. I have created the blocks and their
> > >>> relationships using wizard. All htese blocks are based on tables.
> > >>> Relationships:
> > >>> 1. Block A is the master of block B (detail)
> > >>> 2. Block B is the master of block C (detail)
> > >>> Block A is a form layout (single record), block B is tabluar
> > >>> layout(multi records) with scroll bar and block B is tabluar
> > >>> layout(multi records). with a scroll bar
> > >>> All my block are on single canvas and window. No matter whether we put
> > >>> them in different canvas and windows or stacked canvas or tab canvas,
> > >>> but till the problem persistes.
> > >>> Lets assume:
> > >>> Block A --> showing single record
> > >>> Block B --> having 4 multi records
> > >>> Block C --> a single record for 3rd record in the Block B
> > >>> Problem/Issue.
> > >>> Assume that I have queried (F11 and Ctr + F11) on Block A and it is
> > >>> now showing as my our assumpation (as stated above)
> > >>> 1. When I click on scroll bar or 2nd, 3rd, 4th ... record in block B
> > >>> then it clears all the records in block B and block C. This clearing
> > >>> does not happen when I click on the first record of block B.
> > >>> 2. Lets assume after querying I clicked on first record of block B and
> > >>> moved down to 3rd record in block B. Now we can see the corresponding
> > >>> record in block C for the 3rd record in the block B.I click on the
> > >>> record in the block C then I clicked on the 4th record in block B, then
> > >>> it clears block B and block C. This clearing does not happen if I click
> > >>> back on the same cooresponding record in block B.
> > >>> This is happeing in "ON-CLEAR-DETAILS" trigger which is created at
> > >>> module/form level when we create master detail relationships. The
> > >>> tirgger calls "Clear_All_Master_Details" program unit. This is the code
> > >>> from "Clear_All_Master_Details" program unit which is cleaing
> > >>> currel := Get_Block_Property(trigblk, FIRST_MASTER_RELATION);
> > >>> WHILE currel IS NOT NULL LOOP
> > >>> curdtl := Get_Relation_Property(currel, DETAIL_NAME);
> > >>> IF Get_Block_Property(curdtl, STATUS) <> 'NEW' THEN
> > >>> Go_Block(curdtl);
> > >>> Check_Package_Failure;
> > >>> Clear_Block(NO_VALIDATE);
> > >>> IF :System.Block_Status <> 'NEW' THEN
> > >>> RAISE Form_Trigger_Failure;
> > >>> END IF;
> > >>> END IF;
> > >>> currel := Get_Relation_Property(currel, NEXT_MASTER_RELATION);
> > >>> END LOOP;
> > >>> I have not wrote any custom code or triggers as of now. All I have
> > >>> created is 3 block with master detail relationship using wizard.
> > >>> I do not want to modifiy any seed code of oracle applications. I really
> > >>> appricate any kind of help regarding this issue..
> > >>> Thank You
> > >>> Regards
> > >>> sunnyRecreate the blocks. If that doesn't do it ... post the version.
> > >> --
> > >> Daniel A. Morgan
> > >> University of Washington
> > >> damor..._at_x.washington.edu
> > >> (replace x with u to respond)
> > >> Puget Sound Oracle Users Groupwww.psoug.org-Hidequoted text -- Show quoted text -If you can, without violating company policy, send me the form
> > off-line.
> > --
> > Daniel A. Morgan
> > University of Washington
> > damor..._at_x.washington.edu
> > (replace x with u to respond)
> > Puget Sound Oracle Users Groupwww.psoug.org-Hide quoted text -- Show quoted text -- Hide quoted text -- Show quoted text -
Received on Mon Dec 04 2006 - 14:46:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US