Results for “fnd_imp_pscommon_vl”

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

Overview

FND_IMP_PSCOMMON_VL is a read-only database view owned by the APPS schema in Oracle E-Business Suite. It belongs to the FND (Application Object Library) product family and is documented as part of the ETRM reference for EBS 12.1.1 and 12.2.2. The view presents a consolidated comparison between two sets of patch-related file records: those defined within a patch or patch definition and those captured in a snapshot of previously applied files. Its effective role is to surface, for any given application, directory and filename combination, the new version delivered by a patch alongside the old version already present in the environment. This makes it a supporting object for patch prerequisite, dependency, and file-version analysis rather than a general-purpose transactional view. Because the identifier "new_version" is directly referenced as a column alias in the view definition, the object is frequently located when users search that term in the EBS data dictionary or in patch analysis scripts. Its status is documented as VALID.

Underlying Base Objects

The view is defined over two documented base objects:

• FND_IMP_PFILEINFO2 (documented as a SYNONYM) — provides the patch-side file information. It supplies BUG_NO, APP_SHORT_NAME, DIRECTORY, FILENAME, VERSION (aliased as NEW_VERSION), and PATCH_ID.
• FND_IMP_SFILEINFO_VL (a view) — provides the snapshot-side file information. It supplies SNAPSHOT_ID, the matching APP_SHORT_NAME, DIRECTORY and FILENAME, VERSION (aliased as OLD_VERSION), and IS_FLAGGED_FILE.

The join is an equijoin across three columns — APP_SHORT_NAME, DIRECTORY and FILENAME — meaning the view correlates a patch file with its corresponding snapshot file only when all three attributes match. Records appearing on only one side are excluded by the inner-join semantics inherent in the WHERE clause. No OUTER JOIN syntax is present in the documented view text.

Key Columns

• BUG_NO — the bug or patch number associated with the patch-side file record.
• SNAPSHOT_ID — identifier of the snapshot from which the old file version was taken.
• APP_SHORT_NAME — short name of the application owning the file; one of the three join keys.
• DIRECTORY — directory path of the file; a join key.
• FILENAME — the file name; a join key.
• NEW_VERSION — alias for PATCH_FILES.VERSION, the version supplied by the patch.
• OLD_VERSION — alias for SNAP_FILES.VERSION, the version existing in the snapshot.
• IS_FLAGGED_FILE — flag from the snapshot side indicating whether the file is marked or flagged.
• PATCH_ID — identifier of the patch record on the patch side.

Common Use Cases and Queries

The view is typically queried to detect files whose delivered version differs from the version already installed, to enumerate files associated with a particular bug or patch, and to review flagged files within a snapshot.

To list all file version differences for an application:

• SELECT app_short_name, directory, filename, old_version, new_version FROM apps.fnd_imp_pscommon_vl WHERE new_version <> old_version;

To isolate files delivered by a specific bug number:

• SELECT bug_no, snapshot_id, filename, old_version, new_version FROM apps.fnd_imp_pscommon_vl WHERE bug_no = :bug_no;

To review flagged files within a snapshot:

• SELECT snapshot_id, app_short_name, directory, filename FROM apps.fnd_imp_pscommon_vl WHERE is_flagged_file = 'Y' AND snapshot_id = :snapshot_id;

As with other APPS-owned dictionary views, queries should reference the synonym in the APPS schema and be executed with appropriate privileges. The view is informational and should not be used for direct data manipulation.