Search Results artifact_name

Overview

The IGP_US_PUB_ARTIFACTS table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, owned by the IGS (iGrants) product family. Its primary function is to store details and binary content for public artifacts. In the context of EBS, an artifact typically refers to a document or file uploaded and managed within the application, such as a supporting document for a grant or public-facing material. The table's designation as "public" suggests these artifacts are intended for broader distribution or access compared to internal system documents. It serves as the system of record for the metadata and the actual BLOB (Binary Large Object) content of these files, enabling document storage, retrieval, and management directly within the database.

Key Information Stored

The table's structure is designed to capture both descriptive metadata and the file content itself. The ARTIFACT_ID column serves as the unique, sequence-generated primary key for each record. A critical column, as indicated by the user's search, is ARTIFACT_NAME (VARCHAR2(256)), which holds the name of the uploaded file. The ARTIFACT_TYPE column (VARCHAR2(80)) stores the MIME type (e.g., application/msword, image/pjpeg), defining the file's format. The binary content is stored in the ARTIFACT_CONTENT column as a BLOB. The ACCOUNT_ID column links the artifact to an author via a foreign key relationship to the IGP_AC_ACCOUNTS table. Additional columns include FILE_SIZE for future use and standard EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER) for auditing and data integrity.

Common Use Cases and Queries

This table is central to operations involving the storage and retrieval of user-uploaded documents. Common use cases include uploading a public report or image for a grant application, serving a stored document to an end-user via a web interface, or generating a list of available public resources. A fundamental query to retrieve all artifact metadata, excluding the BLOB for performance, is:

• SELECT ARTIFACT_ID, ARTIFACT_NAME, ARTIFACT_TYPE, FILE_SIZE, ACCOUNT_ID, CREATION_DATE FROM IGS.IGP_US_PUB_ARTIFACTS WHERE ARTIFACT_TYPE LIKE 'image/%';

To locate a specific artifact by its name, a query would leverage the unique index on ARTIFACT_NAME:

• SELECT * FROM IGS.IGP_US_PUB_ARTIFACTS WHERE ARTIFACT_NAME = 'Annual_Report_2023.pdf';

Reporting often involves joining with the account table to display the author's information alongside the artifact details.

Related Objects

The IGP_US_PUB_ARTIFACTS table has defined relationships with other EBS objects. It is referenced by the APPS synonym IGP_US_PUB_ARTIFACTS, which is the standard access point for application code. Crucially, it maintains a foreign key relationship where the ACCOUNT_ID column references the IGP_AC_ACCOUNTS table. This enforces referential integrity, ensuring every artifact is associated with a valid account. The table's integrity is enforced by the primary key index IGP_US_PUB_ARTIFACTS_PK on ARTIFACT_ID and a unique index IGP_US_PUB_ARTIFACTS_U1 on ARTIFACT_NAME, preventing duplicate file names within the public artifact repository.