Search Results objects_affected




Overview
Explore in AI Chat

Overview

APPLSYS.FND_IMP_AFFECTEDFILES is an Oracle E-Business Suite repository table that records the file-level and object-level impact of patch and snapshot operations applied to an EBS instance. It is an internal Oracle Applications object owned by the APPLSYS schema with FND design data reference FND.FND_IMP_AFFECTEDFILES, and it resides in the APPS_TS_TX_DATA tablespace (PCT Free 10). Its status is VALID in both 12.1.1 and 12.2.2, and the documented schema exposes 13 columns. The table is used by the patching and snapshot infrastructure to track which application files, directories, and object types were touched by a given patch, together with dependency information describing the original file location and the patched file location.

From a Data Vault modeling perspective, the heuristic classification for this object is standalone. It does not participate in a hub/link/satellite hierarchy with other EBS tables and holds no documented foreign keys to peer tables; the single documented relationship is a reference from SNAPSHOT_ID to AHL_SNAPSHOTS. It is best treated as a standalone detail/audit record rather than as a conformed dimension or fact in a Warehouse Builder–style model.

Key Information Stored

The table stores one row per affected file, linked to a patch and a snapshot. The most significant columns are:

  • PATCH_ID – a generated number uniquely identifying a (bug_no, baseline) combination; this is the primary business join key to patch metadata.
  • SNAPSHOT_ID – identifies the AHL snapshot associated with the patch application. A normal, non-unique index (FND_IMP_AFFECTEDFILES_N2) exists on SNAPSHOT_ID, PATCH_ID, PATCHED_APP_SHORT_NAME, PATCHED_DIRECTORY, and PATCHED_FILENAME, forming the effective access path.
  • BUG_NO – the bug or patch number that triggered the file change.
  • PATCHED_APP_SHORT_NAME, PATCHED_DIRECTORY, PATCHED_FILENAME – the post-patch location and name of the affected file.
  • DEP_APP_SHORT_NAME, DEP_DIRECTORY, DEP_FILENAME – the dependency (source) application, directory, and filename.
  • OBJECT_TYPE, TYPEID – the type of object affected and its type identifier.
  • OBJECTS_AFFECTED – numeric count or indicator of affected objects.
  • ACTION_REQUIRED – the action that must be performed on the affected file.

No surrogate primary key is documented in the ETRM excerpt; identification relies on the composite business key formed by PATCH_ID and SNAPSHOT_ID together with the patched file path.

Common Use Cases and Queries

The primary use case is patch impact analysis and rollback planning. Administrators and support engineers query this table to determine exactly which files were modified by a patch, which bugs are associated, and what actions remain outstanding.

  • Identifying all files affected by a specific patch: SELECT * FROM APPLSYS.FND_IMP_AFFECTEDFILES WHERE PATCH_ID = :patch_id;
  • Reporting on actions still required after patch application: SELECT BUG_NO, PATCHED_FILENAME, ACTION_REQUIRED FROM APPLSYS.FND_IMP_AFFECTEDFILES WHERE ACTION_REQUIRED IS NOT NULL;
  • Tracing snapshot-to-patch relationships: joining on SNAPSHOT_ID and PATCH_ID, exploiting the FND_IMP_AFFECTEDFILES_N2 index for efficient access.
  • Auditing changes to a particular application short name using PATCHED_APP_SHORT_NAME or DEP_APP_SHORT_NAME.

Related Objects

The documented dependency set is deliberately narrow:

  • AHL_SNAPSHOTS – referenced via SNAPSHOT_ID; the snapshot registry that anchors file state before and after patching.
  • APPS.FND_IMP_AFFECTEDFILES – the APPS synonym or view layer through which application code accesses the underlying APPLSYS table.

No other database objects are documented as referenced by or referencing FND_IMP_AFFECTEDFILES. Because the table is classified standalone, join relationships beyond SNAPSHOT_ID to AHL_SNAPSHOTS should be established through PATCH_ID and BUG_NO against patch metadata rather than through declared foreign keys. This object is Oracle proprietary and confidential information.