Results for “pspfv_enc_payrolls”

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

Overview

The view PSPFV_ENC_PAYROLLS belongs to the Oracle EBS Labor Distribution (PSP) module and presents encumbrance payroll header information enriched with descriptive attributes drawn from several related reference tables. Its principal purpose is to expose a denormalized, human-readable representation of records held in the PSP_ENC_PAYROLLS base table, translating internal foreign keys into recognizable names for business users, report developers, and integration interfaces. Rather than requiring reporting tools to resolve the business group identifier, the set of books identifier, and the payroll identifier separately, the view resolves all three into their corresponding descriptive names in a single query.

The view is defined with a WITH READ ONLY clause, so it is strictly a query construct. It cannot be used to insert, update, or delete data in the underlying encumbrance payroll records. The ETRM documentation states that this view is not implemented in the source database from which the metadata was catalogued, meaning the definition is documented but the object may not exist in every environment. Its most notable relevance to searches such as "set_of_books_name" is the SET_OF_BOOKS_NAME column, which resolves the SET_OF_BOOKS_ID foreign key against the GL_SETS_OF_BOOKS table.

Underlying Base Objects

The view is constructed from four base objects joined in a single SELECT statement:

• PSP_ENC_PAYROLLS (PEP) — the driving table, holding the encumbrance payroll header records including the business group, set of books, and payroll identifiers.
• HR_ORGANIZATION_UNITS (HOU) — joined on BUSINESS_GROUP_ID = ORGANIZATION_ID to supply the business group name.
• GL_SETS_OF_BOOKS (GL) — joined on SET_OF_BOOKS_ID = SET_OF_BOOKS_ID to supply the set of books name.
• PAY_ALL_PAYROLLS_F (PAP) — joined on PAYROLL_ID = PAYROLL_ID to supply the payroll name.

Although ETRM's "referenced base objects" list is empty, the view text clearly documents these four joins. The relationship is therefore a straightforward star-style join, where PSP_ENC_PAYROLLS supplies the primary keys and each dimension table supplies one descriptive attribute.

Key Columns

• ENC_PAYROLL_ID — primary key of the encumbrance payroll record.
• BUSINESS_GROUP_ID / BUSINESS_GRP_NAME — the business group identifier and its resolved organization unit name.
• SET_OF_BOOKS_ID / SET_OF_BOOKS_NAME — the ledger (set of books) identifier and its GL name, the column most relevant to the "set_of_books_name" search term.
• PAYROLL_ID / PAYROLL_NAME — the payroll identifier and its resolved name.
• _LA:INC_OR_EXC — a descriptive flexfield or lookup-driven attribute derived from the INC_EXC_FLAG using FND_LOOKUPS with the YES_NO lookup type, presented via the "_LA" lookup alias convention.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard WHO audit columns inherited from the base table.

Common Use Cases and Queries

A typical use is reconciling encumbrance payroll records to the ledger in which they were created. For example:

• SELECT enc_payroll_id, business_grp_name, set_of_books_name, payroll_name FROM pspfv_enc_payrolls WHERE set_of_books_name = 'Vision Operations';
• SELECT set_of_books_name, COUNT(*) FROM pspfv_enc_payrolls GROUP BY set_of_books_name;
• SELECT p.enc_payroll_id, p.payroll_name, p._LA:INC_OR_EXC FROM pspfv_enc_payrolls p;

Because the view performs three outer dimension joins, developers should use it for read-only reporting and extract/interface purposes only, and should not assume it exists in all 12.1.1 / 12.2.2 environments given the "not implemented" note.