Search Results cc_sync_with_hr

Overview

PN_CC_SYNC_PKG is an Oracle Applications (APPS) PL/SQL package that belongs to the Property Manager (PN) module of Oracle E-Business Suite. Its name conveys its purpose: synchronizing cost-center information (the "CC" prefix) between the Property Manager and Oracle Human Resources. In the Property Manager data model, space assignments and locations frequently carry cost-center attributes that must remain consistent with the HR assignment and payroll structures held in Oracle HRMS. When organizational changes, transfers, or period-of-service updates occur in HR, the property-related cost-center references can become stale. PN_CC_SYNC_PKG provides the programmatic mechanism to reconcile these values.

The package is classified as an "OTHER" API rather than a formal public interface, meaning it is intended primarily for internal use by other EBS components and by controlled extensions rather than as a published integration point.

Key Procedures and Functions

The ETRM metadata documents two callable units within the package:

• CC_SYNC_WITH_HR — The primary synchronization routine. Its purpose is to align the cost-center values referenced by Property Manager entities with the corresponding values maintained in Oracle HR. It is the entry point that drives the reconciliation logic between the two modules.
• GET_CC_AS_OF_DATE — A function that returns the cost-center value as it applied at a specified point in time. Because HR assignment and period-of-service data are date-effective, this function provides the date-aware retrieval needed to resolve which cost center was in force when a given synchronization or historical comparison was performed.

Parameter lists are not documented in the available metadata and are intentionally not reproduced here.

Tables Accessed

The package depends on both Property Manager and HR tables. Within Property Manager it references PN_LOCATIONS (the location/cost-center-bearing entity), PN_SPACE_ASSIGN_EMP, and PN_SPACE_ASSIGN_EMP_ALL (the employee space-assignment records and their "ALL" partitioned variant). On the HR side it references PER_ALL_ASSIGNMENTS_F (the date-effective assignment records that carry cost-center/employee assignment information) and PER_PERIODS_OF_SERVICE (which bounds an employee's continuous service and affects which assignments are relevant).

The package also declares dependencies on the STANDARD package and utility objects such as DBMS_SQL and PLITBLM, the latter a PL/SQL index-by table of VARCHAR2 used for internal set processing. These utilities support dynamic construction and bulk handling of the reconciliation queries. The presence of DBMS_SQL suggests portions of the logic assemble SQL dynamically, likely to accommodate the large "ALL" tables or varying date predicates.

Usage Notes

PN_CC_SYNC_PKG is referenced by no other documented packages, indicating it is a leaf-level utility invoked either from Property Manager forms, from concurrent programs that perform scheduled cost-center reconciliation, or from custom PL/SQL extensions. In practice, an administrator or batch job runs the synchronization to bring cost-center references in PN_LOCATIONS and the space-assignment tables into agreement with current HR assignments, typically after HR reorganization or during periodic data-cleansing cycles. Because it reads date-effective HR tables, callers should be aware of the effective date context supplied through GET_CC_AS_OF_DATE. As an "OTHER"-classified API, it should be treated as an internal, supported-in-place object: customizations may call it, but they should not assume a stable public interface across patches. Direct modification is not recommended.