Results for “pos_chg”

16 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.GHR_SS_POS_CHG_DATES_V is a supplementary database view owned by the APPS schema within Oracle E-Business Suite Release 12.1.1 and 12.2.2. In the Oracle ETRM repository the object is registered as VALID with the FND Design Data reference GHR.GHR_SS_POS_CHG_DATES_V, confirming that it belongs to the Oracle Human Resources (GHR) product family. The view is classified as a supplementary view used to simplify Oracle Forms coding — that is, it exists primarily to serve the user interface layer of the HR self-service and position management forms rather than to act as a general-purpose reporting entity.

Oracle's own documentation carries an explicit warning that the view is not intended for direct query or data manipulation by customers, since its definition may change dramatically in subsequent minor or major releases. Nevertheless, because the view is exposed publicly (PUBLIC.GHR_SS_POS_CHG_DATES_V), it is frequently encountered by technical consultants investigating position change history in HRMS. Its role in reporting and integration is therefore best understood as an internal convenience projection over position change data, combining person, assignment, position, and position extra information attributes with the effective dating of the change.

Underlying Base Objects

The documented dependencies of APPS.GHR_SS_POS_CHG_DATES_V are as follows:

  • GHR_PA_HISTORY (SYNONYM) — the position and assignment history store, which supplies the effective-dated change records.
  • HR_ALL_POSITIONS_F (SYNONYM) — the dated positions entity, providing position definition attributes.
  • PER_ASSIGNMENTS_F2 (VIEW) — the assignment date-track view, supplying assignment number, primary flag, and assignment identifiers.
  • PER_POSITION_EXTRA_INFO (SYNONYM) — the position extra information table, which holds the group 1, group 2, and valid grade identifiers.
  • HR_GENERAL (PACKAGE) — the HR general purpose PL/SQL package, typically used to apply security and business-group filters within the view definition.
  • HR_SECURITY (PACKAGE) — the HR security package, invoked to enforce row-level security on person and position data.

The APPS synonym is also referenced publicly as GHR_SS_POS_CHG_DATES_V. The dependency list confirms that the view is a join-based projection rather than a stored table, and that its row content is filtered by the HR security model at runtime.

Key Columns

  • PERSON_ID (NUMBER, 10) — the person identifier for the individual whose position change is being displayed.
  • ASSIGNMENT_ID (NUMBER, 10) — the assignment identifier associated with the change.
  • ASSIGNMENT_NUMBER (VARCHAR2, 30) — the user-visible assignment number.
  • PRIMARY_FLAG (VARCHAR2, 30) — indicates whether the assignment is the primary assignment.
  • POSITION_ID (NUMBER, 15) — the position identifier involved in the change.
  • EFFECTIVE_DATE (DATE) — the effective date of the position change record.
  • POS_GRP1_ID (NUMBER) — Position Extra Info Group 1 ID; this is the column returned when users search for the term pos_grp1_id.
  • POS_GRP2_ID (NUMBER) — Position Extra Info Group 2 ID.
  • POS_VALID_GRADE_ID (NUMBER) — Position Extra Info Valid Grade ID.

Common Use Cases and Queries

The principal use case is the self-service position change date form, which retrieves the effective-dated position and extra information attributes for a person or assignment. A typical query pattern selecting the group 1 identifier is:

  • SELECT PERSON_ID, ASSIGNMENT_ID, POSITION_ID, EFFECTIVE_DATE, POS_GRP1_ID FROM APPS.GHR_SS_POS_CHG_DATES_V WHERE ASSIGNMENT_ID = :p_assignment_id;

Because the view is secured through HR_SECURITY, results are automatically restricted to the rows the querying user is permitted to see. For production reporting, Oracle recommends building custom extracts directly on the documented base objects (GHR_PA_HISTORY, HR_ALL_POSITIONS_F, PER_ASSIGNMENTS_F2, PER_POSITION_EXTRA_INFO) rather than on this view, since its column list is subject to change without notice.