Search Results service request contact

The PN_CONTACTS_ALL table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical data structure within the Property Manager (PN) module. It serves as the primary repository for storing contact information associated with lease agreements, properties, and other real estate-related entities. This table is designed to support multi-organization access through the _ALL suffix, indicating it contains data across all operating units when Multi-Org functionality is enabled.

Table Structure and Key Columns

The PN_CONTACTS_ALL table contains several important columns that define contact relationships:

CONTACT_ID: Primary key identifier for each contact record
LAST_UPDATE_DATE, LAST_UPDATED_BY: Standard Oracle audit columns
CREATION_DATE, CREATED_BY: Track record creation details
LAST_UPDATE_LOGIN: Session information for updates
CUSTOMER_ID: Foreign key to HZ_CUST_ACCOUNTS for customer relationships
VENDOR_ID: Foreign key to AP_SUPPLIERS for supplier relationships
PERSON_ID: Links to PER_ALL_PEOPLE_F for employee contacts
ORG_ID: Operating unit identifier for Multi-Org implementations
CONTACT_TYPE_CODE: Classifies contact purpose (e.g., 'TENANT', 'LANDLORD')
PRIMARY_FLAG: Indicates primary contact status
START_DATE_ACTIVE, END_DATE_ACTIVE: Date range for contact validity

Functional Relationships

The table maintains relationships with several key EBS modules:

Property Manager Core: Links to lease agreements (PN_LEASES_ALL) and properties (PN_LOCATIONS_ALL)
Trading Community Architecture: Integrates with HZ_PARTIES and HZ_CONTACT_POINTS for unified contact management
Human Resources: Connects to PER_ALL_PEOPLE_F for employee contacts
Payables: References AP_SUPPLIERS for vendor relationships

Business Process Integration

PN_CONTACTS_ALL supports critical real estate management processes:

Lease Administration: Tracks all parties involved in lease agreements
Property Management: Maintains contacts for facilities management
Billing & Payments: Identifies responsible parties for financial transactions
Compliance Reporting: Provides audit trails for contractual obligations

Technical Considerations

Key technical aspects include:

Multi-Org Support: The ORG_ID column enables partitioned data access
Flexfield Integration: Supports descriptive flexfields for custom attributes
Concurrent Program Usage: Referenced by PN reports and interfaces
API Dependencies: Accessed through PN_CONTACTS_PKG package

Version-Specific Features

Between 12.1.1 and 12.2.2, the table structure remained largely consistent, with 12.2.2 potentially including:

Enhanced TCA integration through additional HZ_* columns
Extended flexfield capabilities
Improved indexing strategies for performance

The PN_CONTACTS_ALL table represents a foundational component of Oracle Property Manager's contact management framework, enabling comprehensive tracking of all parties involved in real estate transactions while maintaining integration with core EBS modules.

File: Service Provider.pdf 12.1.1
product: PN - Property Manager , size: 36.567 KBytes , file_type: PDF Diagram ,
File: Service Provider.pdf 12.2.2
product: PN - Property Manager , size: 36.567 KBytes , file_type: PDF Diagram ,
Table: PN_CONTACTS_ALL 12.2.2
owner:PN, object_type:TABLE, fnd_design_data:PN.PN_CONTACTS_ALL, object_name:PN_CONTACTS_ALL, status:VALID, product: PN - Property Manager , description: Contact information identified at the site level of a service provider , implementation_dba_data: PN.PN_CONTACTS_ALL ,
Table: PN_CONTACTS_ALL 12.1.1
owner:PN, object_type:TABLE, fnd_design_data:PN.PN_CONTACTS_ALL, object_name:PN_CONTACTS_ALL, status:VALID, product: PN - Property Manager , description: Contact information identified at the site level of a service provider , implementation_dba_data: PN.PN_CONTACTS_ALL ,
Table: PN_PHONES_ALL 12.1.1
owner:PN, object_type:TABLE, fnd_design_data:PN.PN_PHONES_ALL, object_name:PN_PHONES_ALL, status:VALID, product: PN - Property Manager , description: Telecommuting information to reach a contact , implementation_dba_data: PN.PN_PHONES_ALL ,
Table: PN_PHONES_ALL 12.2.2
owner:PN, object_type:TABLE, fnd_design_data:PN.PN_PHONES_ALL, object_name:PN_PHONES_ALL, status:VALID, product: PN - Property Manager , description: Telecommuting information to reach a contact , implementation_dba_data: PN.PN_PHONES_ALL ,
Lookup Type: PN_JOB_TITLE 12.2.2
product: PN - Property Manager , meaning: PN JOB TITLE , description: Job Title for Contact ,
Lookup Type: PN_JOB_TITLE 12.1.1
product: PN - Property Manager , meaning: PN JOB TITLE , description: Job Title for Contact ,
Lookup Type: PN_OBLIGATION_FIN_RESP_PARTY 12.1.1
product: PN - Property Manager , meaning: PN OBLIGATION FIN RESP PARTY , description: Obligation's financial responsible party ,
Lookup Type: PN_OBLIGATION_FIN_RESP_PARTY 12.2.2
product: PN - Property Manager , meaning: PN OBLIGATION FIN RESP PARTY , description: Obligation's financial responsible party ,
Table: PN_ADDRESSES_ALL 12.1.1
owner:PN, object_type:TABLE, fnd_design_data:PN.PN_ADDRESSES_ALL, object_name:PN_ADDRESSES_ALL, status:VALID, product: PN - Property Manager , description: Information on locations and service providers , implementation_dba_data: PN.PN_ADDRESSES_ALL ,
Table: PN_ADDRESSES_ALL 12.2.2
owner:PN, object_type:TABLE, fnd_design_data:PN.PN_ADDRESSES_ALL, object_name:PN_ADDRESSES_ALL, status:VALID, product: PN - Property Manager , description: Information on locations and service providers , implementation_dba_data: PN.PN_ADDRESSES_ALL ,
Lookup Type: PN_LANDLORD_SERVICE_TYPE 12.1.1
product: PN - Property Manager , meaning: PN LANDLORD SERVICE TYPE , description: Landlord Services ,
Lookup Type: PN_LANDLORD_SERVICE_TYPE 12.2.2
product: PN - Property Manager , meaning: PN LANDLORD SERVICE TYPE , description: Landlord Services ,
Table: PN_LANDLORD_SERVICE_HISTORY 12.1.1
owner:PN, object_type:TABLE, fnd_design_data:PN.PN_LANDLORD_SERVICE_HISTORY, object_name:PN_LANDLORD_SERVICE_HISTORY, status:VALID, product: PN - Property Manager , description: Track changes in the service provided by the landlord to the tenant , implementation_dba_data: PN.PN_LANDLORD_SERVICE_HISTORY ,
Lookup Type: PN_LOCATION_FEATURE_TYPE 12.2.2
product: PN - Property Manager , meaning: PN LOCATION FEATURE TYPE , description: Location Features ,
Table: PN_COMPANY_SITES_ALL 12.1.1
owner:PN, object_type:TABLE, fnd_design_data:PN.PN_COMPANY_SITES_ALL, object_name:PN_COMPANY_SITES_ALL, status:VALID, product: PN - Property Manager , description: Site information of a service provider , implementation_dba_data: PN.PN_COMPANY_SITES_ALL ,
Table: PN_COMPANIES_ALL 12.2.2
owner:PN, object_type:TABLE, fnd_design_data:PN.PN_COMPANIES_ALL, object_name:PN_COMPANIES_ALL, status:VALID, product: PN - Property Manager , description: Information pertaining to a service provider , implementation_dba_data: PN.PN_COMPANIES_ALL ,
Table: PN_LANDLORD_SERVICE_HISTORY 12.2.2
owner:PN, object_type:TABLE, fnd_design_data:PN.PN_LANDLORD_SERVICE_HISTORY, object_name:PN_LANDLORD_SERVICE_HISTORY, status:VALID, product: PN - Property Manager , description: Track changes in the service provided by the landlord to the tenant , implementation_dba_data: PN.PN_LANDLORD_SERVICE_HISTORY ,
Table: PN_COMPANY_SITES_ALL 12.2.2
owner:PN, object_type:TABLE, fnd_design_data:PN.PN_COMPANY_SITES_ALL, object_name:PN_COMPANY_SITES_ALL, status:VALID, product: PN - Property Manager , description: Site information of a service provider , implementation_dba_data: PN.PN_COMPANY_SITES_ALL ,
Table: PN_COMPANIES_ALL 12.1.1
owner:PN, object_type:TABLE, fnd_design_data:PN.PN_COMPANIES_ALL, object_name:PN_COMPANIES_ALL, status:VALID, product: PN - Property Manager , description: Information pertaining to a service provider , implementation_dba_data: PN.PN_COMPANIES_ALL ,
Lookup Type: PN_LOCATION_FEATURE_TYPE 12.1.1
product: PN - Property Manager , meaning: PN LOCATION FEATURE TYPE , description: Location Features ,
Table: PN_CONTACT_ASSIGNMENTS_ALL 12.2.2
owner:PN, object_type:TABLE, fnd_design_data:PN.PN_CONTACT_ASSIGNMENTS_ALL, object_name:PN_CONTACT_ASSIGNMENTS_ALL, status:VALID, product: PN - Property Manager , description: Llinks locations or leases with the site of a service provider. , implementation_dba_data: PN.PN_CONTACT_ASSIGNMENTS_ALL ,
Table: PN_CONTACT_ASSIGNMENTS_ALL 12.1.1
owner:PN, object_type:TABLE, fnd_design_data:PN.PN_CONTACT_ASSIGNMENTS_ALL, object_name:PN_CONTACT_ASSIGNMENTS_ALL, status:VALID, product: PN - Property Manager , description: Llinks locations or leases with the site of a service provider. , implementation_dba_data: PN.PN_CONTACT_ASSIGNMENTS_ALL ,