Search Results prp_perz_files_pk




Overview
Explore in AI Chat

Overview

The PRP_PERZ_FILES table is a core data object within the Oracle E-Business Suite (EBS) Proposals (PRP) module, specifically in versions 12.1.1 and 12.2.2. It serves as the primary repository for storing metadata related to personalized files that sales representatives attach to sales proposals. This functionality is critical for enabling sales teams to enrich standard proposal templates with custom, client-specific documents, presentations, or other collateral, thereby enhancing the personalization and effectiveness of the sales process. The table's role is to maintain the logical link between a proposal and the associated file content, which is physically stored elsewhere in the database.

Key Information Stored

The table's structure centers on identifiers that link a personalized file to both the proposal system and the physical file data. The primary key is PERZ_FILE_ID, a unique system-generated identifier for each personalized file record. A second unique key constraint exists on FILE_ID, which is a foreign key column. This FILE_ID points to the LOB_ID in the FND_LOBS table, where the actual binary content of the uploaded file is stored. Another significant foreign key column is CITEM_VERSION_ID, which links to the IBC_CITEM_VERSIONS_B table. This relationship connects the personalized file to a specific version of a content item within Oracle's Content Manager, providing structured content management capabilities for the attached files.

Common Use Cases and Queries

A primary use case is generating reports on proposal personalization activity, such as listing all files attached to a specific proposal or identifying which sales representatives are most actively customizing proposals. Support and data cleanup operations often involve queries to locate files associated with obsolete proposals. A typical SQL pattern retrieves file metadata alongside the proposal context, often joining to related PRP tables (like PRP_PROJECTS_ALL) via the content item relationship.

SELECT pf.perz_file_id, pf.file_id, fl.file_name, fl.content_type
FROM prp_perz_files pf,
     fnd_lobs fl
WHERE pf.file_id = fl.lob_id
AND pf.citem_version_id = :p_citem_version_id;

Another common operational query is used to verify the integrity of file attachments by checking for orphaned records where the LOB data might be missing.

Related Objects

The PRP_PERZ_FILES table has defined dependencies on two key EBS objects, as indicated by its foreign key constraints. First, it depends on the FND_LOBS table, which is a central repository for storing large objects (LOBs) across the EBS application. This is where the actual file data resides. Second, it depends on IBC_CITEM_VERSIONS_B, a table from the IBC (Content Manager) module that manages versions of content items. This integration allows proposal attachments to leverage enterprise content management features like versioning, security, and workflow. The table itself is referenced by its primary key constraint (PRP_PERZ_FILES_PK) and unique key constraint (PRP_PERZ_FILES_UK1).

  • Table: PRP_PERZ_FILES 12.1.1

    owner:PRP,  object_type:TABLE,  fnd_design_data:PRP.PRP_PERZ_FILES,  object_name:PRP_PERZ_FILES,  status:VALID,  product: PRP - Proposals ,  description: This table represents the personalized files added by the sales representatives to the proposal ,  implementation_dba_data: PRP.PRP_PERZ_FILES , 

  • Table: PRP_PERZ_FILES 12.2.2

    owner:PRP,  object_type:TABLE,  fnd_design_data:PRP.PRP_PERZ_FILES,  object_name:PRP_PERZ_FILES,  status:VALID,  product: PRP - Proposals ,  description: This table represents the personalized files added by the sales representatives to the proposal ,  implementation_dba_data: PRP.PRP_PERZ_FILES , 

  • eTRM - PRP Tables and Views 12.1.1

    description: This table contains the values for the "User Defined" tokens of type "List of Values". This table stores the list of values for each token in each installed language. , 

  • eTRM - PRP Tables and Views 12.2.2

    description: This table contains the values for the "User Defined" tokens of type "List of Values". This table stores the list of values for each token in each installed language. , 

  • eTRM - PRP Tables and Views 12.1.1

    description: This table contains the values for the "User Defined" tokens of type "List of Values". This table stores the list of values for each token in each installed language. , 

  • eTRM - PRP Tables and Views 12.2.2

    description: This table contains the values for the "User Defined" tokens of type "List of Values". This table stores the list of values for each token in each installed language. ,