Oracle Fusion TCA Concept

There are some queries, which is mostly we need in TCA

1. Get the contact information for a party or account in Oracle Fusion applications.



SELECT PartyPEO.PARTY_NAME,
  PartyPEO.EMAIL_ADDRESS,
  OrganizationContactPEO.JOB_TITLE,
  OrganizationContactPEO.DEPARTMENT,
  PartyPEO.STATUS AS STATUS1,
  CustomerAccountContactPEO.CUST_ACCOUNT_ROLE_ID,
  CustomerAccountContactPEO.CUST_ACCOUNT_ID,
  CustomerAccountContactPEO.CONTACT_PERSON_ID,
  CustomerAccountContactPEO.STATUS,
  CustomerAccountContactRolePE1.CUST_ACCOUNT_ROLE_ID AS CUST_ACCOUNT_ROLE_ID1,
  CustomerAccountContactRolePE1.RESPONSIBILITY_ID,
  CustomerAccountContactRolePE1.RESPONSIBILITY_TYPE,
  CustomerAccountContactPEO.ROLE_TYPE,
  PartyPEO.PARTY_ID,
  RelationshipPEO.OBJECT_ID,
  RelationshipPEO.RELATIONSHIP_REC_ID,
  RelationshipPEO.OBJECT_TYPE,
  RelationshipPEO.RELATIONSHIP_CODE,
  RelationshipPEO.RELATIONSHIP_ID,
  OrganizationContactPEO.ORG_CONTACT_ID,
  OrganizationContactPEO.PARTY_RELATIONSHIP_ID
FROM HZ_CUST_ACCOUNT_ROLES CustomerAccountContactPEO,
  HZ_ROLE_RESPONSIBILITY CustomerAccountContactRolePE1,
  HZ_PARTIES PartyPEO,
  HZ_RELATIONSHIPS RelationshipPEO,
  HZ_ORG_CONTACTS OrganizationContactPEO
WHERE (CustomerAccountContactPEO.CUST_ACCOUNT_ROLE_ID = CustomerAccountContactRolePE1.CUST_ACCOUNT_ROLE_ID)
AND (CustomerAccountContactPEO.CONTACT_PERSON_ID = PartyPEO.PARTY_ID)
AND (CustomerAccountContactRolePE1.RESPONSIBILITY_TYPE = 'BILL_TO')
AND (CustomerAccountContactPEO.STATUS = 'A')
AND (CustomerAccountContactPEO.ROLE_TYPE = 'CONTACT')
AND (RelationshipPEO.OBJECT_ID = PartyPEO.PARTY_ID)
AND (RelationshipPEO.RELATIONSHIP_ID = OrganizationContactPEO.PARTY_RELATIONSHIP_ID)
AND (CustomerAccountContactRolePE1.STATUS_FLAG = 'A')
AND (PartyPEO.STATUS = 'A') AND (RelationshipPEO.STATUS = 'A') ;


Comments

Post a Comment

Popular posts from this blog

Executing a method bindings In Bean method.

Image
Many time you be in a situation where there is a AM method exposed as a client and requirement is to execute that AM method from the backing bean. Its quite simple first you have to register that AM method in the page definition file as method bindings. Now choose the method you want to add to the page definition and executed by a bean method. for the parameter either you can use the bindings if your parameter clearly coming from bindings else leave them blank. Now in the bean method first you have to catch the handle of the DCBindingContainer and then using this binding container you can get the operation binding for the AM method and then can add the parameter. If you are have already bind the parameter with the bindings then can skip that. then you just need to call the execute method of your operation binding.
Read more

Using Java Decompiler(JD) with Oracle Jdeveloper (Jdev)

Image
  Java Decompiler(JD) with Oracle Jdeveloper (Jdev) Java Decompiler is a good tool to check the code, when we just have complied code.  There are ways by which you can check the code, which is been in form of jar with you.   Let say you got ADF Jar file for a project and now want to check, what is the code inside of an entity object IMpl or how this code is structured.  There are some simple steps to it. 1. Create an ADF application with mode and UI project. If you have more project, try to keep the name of the model same as jar. Here I have two jars to check. employee Model.jar and employeeUI.jar.   2. Now go to you jars and then unzip these jars using the unzip or 7 zip prog. 3. Once you done with the unzip then place these directries under the application and project you have created. Please have model code paste under src directory only. 4. Refresh the application now and you will be able to see ...
Read more

Current Logged in User and Roles in ADF and Fusion Apps

A) Using the groovy Expression. We can set default expression in view object attribute as below  adf.context.securityContext.getUserPrincipal().getName()  adf.context.securityContext.getUserName()    For Roles use  adf.context.securityContext.getUserRoles() B) Java Code You can get User Name in Java code also using the following code. ADFContext adfCtx = ADFContext.getCurrent(); SecurityContext secCntx = adfCtx.getSecurityContext(); String user = secCntx.getUserPrincipal().getName(); String userName = secCntx.getUserName(); String[] Roles = secCntx.getUserRoles(); C) Expression  Language You can bind ADF Faces componenets with the following EL to get logged User Name. #{securityContext.userName} #{securityContext.userRoles} D) In Fusion Applications (On Premise Implementation) ApplSession session = ApplSessionUtil.getSession(); String guid1 = session.getUse...
Read more