[ADF Help] How to create a view for multiple tables

10-11  Source: Network gathering  Views:0 

Advertisement
Hi,
I am using Jdeveloper 11G and ADF framework, and trying to create a view to update multiple tables.
ex:
Table A has these fields: ID, Name
Table B has these fields: ID, Address
A.ID and B.ID are primary keys.
B.ID has FK relationship with A.ID
(basically, these tables have one-to-one relation)
I want to create a view object, which contains these fields: B.ID (or A.ID), A.Name, B.Address.
So I can execute C,R,U,D for both tables.
I create these tables in DB, and create entity objects for these tables.
So there are 2 entity objects and 1 association.
Then I create a view object based on B and add fields of A into the view:
If the association is not a "Composition Association",
when I run the model ("Oracle Business Component Browser") and try to insert new data, fields of A can't edit.
If the association is a "Composition Association", and click the insert button, I will get
"oracle.jbo.InvalidOwnerException: JBO-25030: Failed to find or invalidate owning entity"
If I create a view object based on A and add filed of B into the view:
When I run the model and try to insert new data, fields of B can't edit, no matter the association is or is not a composition association.
So... how can I create a view for multiple tables correctly?
Thanks for any advices!
Here are some pictures about my problem, if there is any unclear point, please let me know.
http://leonjava.blogspot.com/2009_10_01_archive.html
(A is Prod, B is CpuSocket)
Edited by: user8093176 on Oct 25, 2009 12:29 AM
Hi Branislav,
Thanks, but the result is same ....
In the step 2 of creating view object, I can select entity objects to be added in to the view.
If I select A first, and then select B (the "Source Usage" of B is A), then finishing the wizards.
When I try to create a new record in the view, I can't edit any properties of B (those files are disabled).
If I select B first, and then select A in crating view object, the result is similar ...
Thanks for any further suggestion.
Leon
Related articles
  • [ADF Help] How to create a view for multiple tables 10-11

    Hi, I am using Jdeveloper 11G and ADF framework, and trying to create a view to update multiple tables. ex: Table A has these fields: ID, Name Table B has these fields: ID, Address A.ID and B.ID are primary keys. B.ID has FK relationship with A.ID (b

  • How  to create classification view for material? 11-30

    HI All, How to create classification view for material? is there any function  module? pls let me know. Bandicheck the standard include "LCLBPAU14" this is using the following F.M call function 'BAPI_OBJCL_CREATE' exporting objectkeynew = l_obje

  • How to create one TO for multiple TRs 10-11

    Dear All, how to create one TO for multiple TRs, kindly suggest me Regards, baluAs for your question: it is discussed in sAP online help: http://help.sap.com/saphelp_erp60_sp/helpdata/en/c6/f841f24afa11d182b90000e829fbfe/frameset.htm Sorry I misunder

  • How to create xsd's for each table in repository instead of entire repos 10-11

    Hi Gurus, Is there any way i could create xsd's for each table in the repository separately instead of creating single xsd file from "Export repository schema" option which creates a single xml file for the entire repository.I need to create xsd

  • How to create t-code for a table and how to create transaction variant??? 10-11

    Hi, I have created a custom table zsark. Now my requirement is : I have to create a transaction variant zsark_var for sm30 and table zsark. I have to disable the output of the first screen. I have to assign the transaction variant to the transaction

  • How to create a attribute for a table 10-11

    I am created a table with four columns. How to create a attribute for each column.........Hi Cranjith Kumar, First Create a node for ur table.In that give your table name in the dictionary structure then select option add attributes from the structur

  • How to create one delivery for multiple sales order 10-11

    Hi!! Friends, Can some one explain the steps to be followed in creating one delivery for multiple sales order in SAP SD. Regards AKASH Message was edited by:         AKASH TAMBIHi.,               You can combine different orders in to one delivery ,B

  • How to create a view for all Service Requests that are not approved by reviewer 10-11

    Hallo, I want to create a view in the Service Requests library that shows all SRs that are not approved. How to configure condition that says: if a SR has related Review Activity which is In Progress, show that SRs? I couldn't find this when creating

  • How to create an iterator for a table? 11-30

    Hey I know this is a question for begginners- but maybe you could help me Im rtying to go over some table rows with an iterator I know the function "binding.findIteratorBinding(tablenameIterator) but it seems that I should do something more since I g

  • SEPA file – how to create one file for multiple company codes 10-11

    Dear experts, My company has multiple company codes and they process automatic payments (F110) for multiple company codes in the same run. The company wants to generate one SEPA file for all company codes. In OBPM1  for SEPA format in the section ``P

  • Index - How to create an index for multiple InDesign files? 10-11

    Hi everyone, I'm using InDesign CS2 to create a 250 page catalogue. Most of it is finished now, and I've come to creating the index. The catalogue is spread over about 10 InDesign files. How do I create an index for this? No paragraph styles were set

  • How to create group bom for multiple plants with different company codes 10-11

    Dear all, In my current scenario we have 5 Company codes with a plant with each company. The same kind of materials exist in all the 5 plants, so what i want is when i create any BOM, that BOM has to extend in all the company codes, as with GROUP BOM

  • How to create production order for multiple items having common raw materia 10-11

    Dear all, We are running a sheet metal fabrication company at Vadodara Gujrat. Please guide us how to create single production order for multiple items using single raw material?? For example, We want to produce baby shirt(item code AAA001), shirt wi

  • Create a view from multiple tables 11-30

    Hi all, I am a newbie, so sorry if this is a "basic" question. I had 3 tables TAB1, TAB2 and TAB3 TAB1 has STU_ID(pk), NAME, GRADE, ADDRESS TAB2 has COURSE_ID(pk), STU_ID(fk), COURSE_NAME, ROOM_NUM, TIME, DAY TAB3 has MENTOR_NAME, TITLE, AVAILAB

  • How to create send connectors for multiple sites in the same domain? 10-11

    Current Scenario: We have 2 offices, 1 in London and 1 in India. Both are in the same domain and are connected via VPN. Both have their own separate Exchange 2003 server. Each location sends out their mail via the Default SMTP Virtual Server on their

  • How to create production version for multiple BOM & Routing ? 10-11

    If I have 3 BOMs ( A, B & C ) and 2 Routing ( 1 & 2 ) for material XYZ then how then production version will be created ? I feel that there will be 6 PVs. combination of A1, A2, B1, B2, C1 & C2. but some one told me that  I have to create dupl

  • How to create one node for multiple instances of hardware 10-11

    I want a single minor device node to act as the interface to all instances of my hardware, in this case a co-processor chip on the     PCI bus. For the number of chips found at boot time, I want requests to be dispatched, one per chip, in a round-rob

  • How to create one node for multiple cards? 10-11

    I want a single minor device node to act as the interface to all instances of my pci-cards. I have the same pci-cards(pcixxx, xxx).You may want to create minor nodes on the fly using cloning or makedevice() interface. WDD has an example on it in xx_o

  • How to create a view between two table under different database? 11-30

    thxAssuming the different database is Oracle, you'll probably need to create a 'dblink'. Researching that topic should get you where you need to go.Read other 2 answers

  • How to create XMLTYPE View from the XMLType table 11-30

    Hi: I have a large XML file and inserted to the XMLTYPE table For the XQUERY purpose I would like to create XMLView of the table. The examples I got from Oracle to create XML view are for small files. Can some one help me how to create XMLType VIEW f