vipin's blog

 Tricky Error  oracle.jbo.expr.JIEvalException: JBO-25077:  If you are gtting this error  JBO-25077: Name ***sVO not found in the given object: ViewRow [oracle.jbo.Key[300000008822036 ]].     at oracle.jbo.common.JboBeanUtils.getProperty(JboBeanUtils.java:95)     at oracle.jbo.common.JboBeanUtils.getPropertyInMapOrBean(JboBeanUtils.java:252) This normally will be coming from the destination view accesssor. Open this View Object  and  go in the end and see if something is not coming in the warning.   <ViewLinkAccessor     Name="BookVO"     ViewLink="xx.test.view.link.bookToTopics"     Type="oracle.jbo.Row"     Reversed="true"     IsUpdateable="false"/> If  Viewlink is correctly created jdev can auto correct also. Correct and rerun your application Most of the cases error will be gone.

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_ACCO