Party relationship in oracle r12

Party Relationships | Dibyajyoti Koch:A Blog on Oracle Application

party relationship in oracle r12

A Party (person, organization, group or relationship) . Please Contact for One to One Online Training on Oracle Apps Technical, Financials. Attention: In Receivables, you can also create relationships between parties using Oracle Trading Community Architecture Relationship Manager. See. SQL statement to derive Active Party relationships related to active account parties.

Oracle as the employer of Joe, which flips the subject and object, still describes the same relationship.

Relationship Manager

Relationship Phrase and Role Pairs A relationship phrase and role pair contains a correlating phrase pair and role pair, which describes the reciprocal roles that the two entities play in the relationship. For example, a relationship phrase and role pair contains the Employee Of and Employer Of phrase pair as well as the Employee and Employer role pair.

Every relationship is based on a relationship phrase and role pair. Even though only phrase pairs are used in Relationship Manager, the corresponding role pair is still stored in the system for each relationship. A phrase pair, such as Employee Of and Employer Of, describe the role of either entity in the relationship as the subject. For example, Joe as the subject of the relationship would have Employee Of as the phrase, and Oracle as the subject would have Employer Of.

The other entity in the relationship would be the object. A relationship role pair, such as Employee and Employer, describes the two entities no matter the direction of the relationship.

Oracle AR -Difference between PARTY and CUSTOMER

For example, Joe has the Employee role and Oracle the Employer role, both as either the subject or object. Each relationship phrase and role pair also determines the type of entities for the relationship. For example, the Employer Of phrase and Employer role can be defined so that the employer must be a party of type Organization and the employee a party of type Person.

When you create a relationship with a relationship phrase or role, the reverse direction of the relationship is automatically created with the other phrase or role in the pair.

party relationship in oracle r12

For example, if you define Joe as the employee of Oracle, Oracle as the employer of Joe is also created. Relationship Type Each relationship phrase and role pair belongs to a relationship type, which categorizes the types of relationships that you can create.

For example, the relationship phrase and role pair described above would belong to an employment relationship type. Relationship types determine if the relationships created with the type are hierarchical, and if not, whether they can be circular or not. For more information, see: Every relationship type must contain at least one phrase and role pair.

TCA provides seeded relationship types and phrase and role pairs, but your administrator can create new ones as needed. Relationship Date Range Both directions of a relationship share a start and end date. The start date signifies when the relationship starts, not necessarily when it was created. Likewise, the end date is when the relationship ends. The relationship date range helps you analyze the history of an entity's relationships. For example, you can see that Joe used to work for Oracle in a subsidiary location for the past two years but has been working at Oracle headquarters since last month.

Relationship Group In general, relationship groups are used to determine which relationship roles and phrases are displayed in specific application user interfaces.

Groups can also be used to categorize roles and phrases for other functional uses. Relationship groups do not apply to Relationship Manager. In addition, every relationship is reciprocal. Relationship Phrase and Role Pairs Every relationship is based on a relationship phrase and role pair. For example, Joe as the subject of the relationship would have Employee Of as the phrase, and Oracle as the subject would have Employer Of A relationship role pair, such as Employee and Employer, describes the two entities no matter the direction of the relationship.

For example, Joe has the Employee role and Oracle the Employer role, both as either the subject or object. When you create a relationship with a relationship phrase or role, the reverse direction of the relationship is automatically created with the other phrase or role in the pair. For example, if you define Joe as the employee of Oracle, Oracle as the employer of Joe is also created.

Oracle AR -Difference between PARTY and CUSTOMER | Shivmohan Purohit's Oracle ERP BLOG

Relationship Type Each relationship phrase and role pair belongs to a relationship type, which categorizes the types of relationships that you can create. For example, the relationship phrase and role pair described above would belong to an Employment relationship type. Relationship types determine if the relationships created with the type are hierarchical, and if not, whether they can be circular or not. Relationship Group Relationship groups are used to determine which relationship roles and phrases are displayed in specific application user interfaces.

Groups can also be used to categorize roles and phrases for other functional uses. Hierarchical Relationships A hierarchical relationship ranks one entity above the other. Hierarchical relationships cannot be circular. Below diagram describes the process flow of setting up relationship types as well as phrase and role pairs.

party relationship in oracle r12

Now we are going to see how to Create relationship type Add relationship phrase and role pairs. Assign relationship phrase to relationship group Build relation between two parties using the relationship. View Relationships Sample Case: Go to any of the below two responsibilities: