Results for “pay_jp_def_pact_v”
43 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PAY_JP_DEF_PACT_V is an Oracle E-Business Suite database view owned by the APPS schema and registered as VALID in the ETRM repository. It belongs to the PAY (Payroll) product family and, as its description states, is used for Japanese localization only. The view exposes payroll action information related to the Japanese "Defined PACT" (payment agreement/contract) context, presenting a denormalized and decoded projection of data that is otherwise stored in canonical, non-human-readable form in the underlying DML view.
Because Oracle EBS stores certain numeric and date values in canonical formats internally (for example, payroll identifiers and dates held in canonical representations), the raw base view is not directly suitable for reporting or integration. PAY_JP_DEF_PACT_V resolves this by applying the FND_NUMBER and FND_DATE conversion functions, returning canonical-to-number and canonical-to-date values. This makes the view appropriate for reporting layers, extracts, and downstream integrations that need readable payroll, organization, and date values for the Japanese localization.
Underlying Base Objects
The documented referenced base objects for this view are:
- FND_DATE (PACKAGE) — used to convert canonical date columns to standard date values via FND_DATE.CANONICAL_TO_DATE.
- FND_NUMBER (PACKAGE) — used to convert canonical numeric columns to standard numbers via FND_NUMBER.CANONICAL_TO_NUMBER.
- PAY_JP_DEF_PACT_DML_V (VIEW) — the source view from which all rows and columns are selected.
PAY_JP_DEF_PACT_V is defined as a filtered and projected select over PAY_JP_DEF_PACT_DML_V, restricted by two predicates: ACTION_CONTEXT_TYPE = 'PA' and ACTION_INFORMATION_CATEGORY = 'JP_DEF_PACT'. This means the view surfaces only those action-information records that belong to the Japanese Defined PACT action category within the Payroll action context. The relationship to PAY_JP_DEF_PACT_DML_V is therefore one of narrowing and decoding: the DML view provides the raw row set, while PAY_JP_DEF_PACT_V filters to the Japanese Defined PACT subset and converts canonical values into standard numbers and dates.
Key Columns
The view exposes the following columns. Identity and versioning columns include ROW_ID, ACTION_INFORMATION_ID, OBJECT_VERSION_NUMBER, PAYROLL_ACTION_ID, EFFECTIVE_DATE, and ACTION_INFORMATION_CATEGORY. The ACTION_CONTEXT_TYPE column is always 'PA' in this view by definition.
- PAYROLL_ID — canonical value converted to a standard number; identifies the associated payroll.
- ORGANIZATION_ID — canonical value converted to a standard number; identifies the organization.
- SUBMISSION_PERIOD_STATUS — status of the submission period for the Defined PACT.
- SUBMISSION_START_DATE and SUBMISSION_END_DATE — canonical dates converted to standard dates, marking the submission period.
- TAX_OFFICE_NAME — name of the tax office associated with the record.
- SALARY_PAYER_NAME — name of the salary payer.
- SALARY_PAYER_ADDRESS — the address of the salary payer. This is the column most directly relevant to the search term "salary_payer_address".
- Audit columns — LAST_UPDATE_LOGIN, LAST_UPDATED_BY, LAST_UPDATE_DATE, CREATED_BY, and CREATION_DATE support standard EBS auditing and traceability.
Together, SALARY_PAYER_NAME, SALARY_PAYER_ADDRESS, and TAX_OFFICE_NAME constitute the payer/tax-office details required for Japanese payroll submission reporting.
Common Use Cases and Queries
Typical use cases include Japanese localization reporting, extraction of salary payer and tax office details, and integration of submission period data into external payroll or filing systems. The view is commonly queried by payroll and localization analysts to obtain decoded payroll and organization identifiers alongside payer address information.
A representative query retrieving salary payer details, including the address column that motivated the search, is:
- SELECT payroll_id, organization_id, salary_payer_name, salary_payer_address, tax_office_name, submission_period_status, submission_start_date, submission_end_date FROM apps.pay_jp_def_pact_v WHERE payroll_action_id = :p_action_id;
Because the view already filters to ACTION_CONTEXT_TYPE = 'PA' and ACTION_INFORMATION_CATEGORY = 'JP_DEF_PACT', no additional filtering on those columns is required. Additional predicates on EFFECTIVE_DATE or PAYROLL_ACTION_ID are frequently used to isolate a specific action or effective period. Joins back to payroll action or organization tables should use the decoded PAYROLL_ID and ORGANIZATION_ID columns, since these are already returned in standard numeric form.
-
View: PAY_JP_DEF_PACT_V 12.1.1
This view is used for Japanese localization only.
APPS.PAY_JP_DEF_PACT_V·↳ FND_DATE·↳ FND_NUMBER·↳ PAY_JP_DEF_PACT_DML_V·Explore PAY module →
-
View: PAY_JP_DEF_PACT_V 12.2.2
This view is used for Japanese localization only.
APPS.PAY_JP_DEF_PACT_V·↳ FND_DATE·↳ FND_NUMBER·↳ PAY_JP_DEF_PACT_DML_V·Explore PAY module →
-
VIEW: APPS.PAY_JP_DEF_PACT_V 12.1.1
-
VIEW: APPS.PAY_JP_DEF_PACT_V 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - PAY Tables and Views 12.1.1
Temporary table used to hold invalid location addresses.
-
12.2.2 DBA Data 12.2.2
-
eTRM - PAY Tables and Views 12.2.2
Temporary table used to hold invalid location addresses.
-
12.1.1 DBA Data 12.1.1
-
eTRM - PAY Tables and Views 12.1.1
Temporary table used to hold invalid location addresses.
-
eTRM - PAY Tables and Views 12.2.2
Temporary table used to hold invalid location addresses.