Results for “source_assignment_action_id”

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

Overview

The PAY_JP_SOE_PREPAY_PAYMENTS_V view is a Japanese localization object within the Oracle E-Business Suite Payroll (PAY) module. It resides in the APPS schema and holds a VALID status. As its description indicates, the view is used exclusively for Japanese localization purposes — more specifically, it supports the Japanese "Statement of Earnings" (SOE) prepayment reporting requirements tied to the SOE functional framework delivered for Japan. The view consolidates prepayment information recorded against assignment actions, payroll actions, and organizational payment methods, enriching it with descriptive lookup values, currency formatting, and locking-state indicators derived from the PAY_JP_SOE_PKG package.

In Oracle EBS 12.1.1 and 12.2.2, this object functions as a read-only reporting and integration surface. It is not an operational table; it exposes a denormalized projection over the underlying prepayment and payment method data, allowing SOE-related concurrent programs, Oracle Reports, OAF pages, or custom extracts to retrieve prepayment amounts and payment type metadata without directly joining multiple payment tables. Because it references package functions that return a "locked action" marker, the view is also used to determine whether a prepayment record is currently locked by an in-progress SOE action.

Underlying Base Objects

Per the ETRM metadata, the view is defined over the following documented base objects: FND_CURRENCY (PACKAGE), HR_GENERAL (PACKAGE), PAY_ASSIGNMENT_ACTIONS, PAY_JP_SOE_PKG (PACKAGE), PAY_ORG_PAYMENT_METHODS_F, PAY_ORG_PAYMENT_METHODS_F_TL, PAY_PAYMENT_TYPES, PAY_PAYMENT_TYPES_TL, PAY_PAYROLL_ACTIONS, PAY_PERSONAL_PAYMENT_METHODS_F, PAY_PRE_PAYMENTS, and DUAL.

The core join chain is built from PAY_PERSONAL_PAYMENT_METHODS_F (PPM), PAY_PRE_PAYMENTS (PPP), PAY_PAYROLL_ACTIONS (PPA), and PAY_ASSIGNMENT_ACTIONS (PAA). The view correlates PPA.PAYROLL_ACTION_ID to PAA.PAYROLL_ACTION_ID, and PPP.ASSIGNMENT_ACTION_ID to PAA.ASSIGNMENT_ACTION_ID, then links PPP.ORG_PAYMENT_METHOD_ID to PAY_ORG_PAYMENT_METHODS_F. Translation tables — PAY_PAYMENT_TYPES_TL and PAY_ORG_PAYMENT_METHODS_F_TL — supply the language-specific names, while their base tables provide identifiers. Effective-dating is enforced by comparing PPA.EFFECTIVE_DATE against the org payment method effective dates. The HR_GENERAL.DECODE_LOOKUP and FND_CURRENCY.GET_FORMAT_MASK packages supply descriptive lookup text and currency display formatting respectively.

Key Columns

• ASSIGNMENT_ACTION_ID — Identifier linking the prepayment to a specific assignment action.
• PRE_PAYMENT_ID — Primary identifier of the prepayment record from PAY_PRE_PAYMENTS.
• M_ASSIGNMENT_ACTION_ID, M_OBJECT_VERSION_NUMBER, M_PAYROLL_ACTION_ID — "Locked action" numeric values returned by PAY_JP_SOE_PKG.GET_LOCK_ACTION_NUM, used to detect SOE locking.
• M_ACTION_TYPE, M_ACTION_STATUS — Locked action type and status values from GET_LOCK_ACTION_VAL.
• CATEGORY — Payment type category from PAY_PAYMENT_TYPES.
• PAYMENT_TYPE_NAME — Translated payment type description from PAY_PAYMENT_TYPES_TL.
• ORG_PAYMENT_METHOD_NAME — Translated organizational payment method name.
• PRIORITY — Prepayment priority from PAY_PERSONAL_PAYMENT_METHODS_F.
• VALUE / formatted VALUE — Prepayment amount and its currency-formatted character representation (via FND_CURRENCY.GET_FORMAT_MASK).
• CURRENCY_CODE — Currency of the prepayment value.
• EXTERNAL_ACCOUNT_ID — External account reference from the payment method.

The decoded action type (via HR_GENERAL.DECODE_LOOKUP on ACTION_TYPE) and the MESSAGES_EXIST_FLAG from PAY_JP_SOE_PKG provide the human-readable action label and a flag indicating whether SOE messages exist for the assignment action.

Common Use Cases and Queries

The primary scenario is generating Japanese SOE prepayment statements. A report or extract selects prepayment amounts and payment types for a given payroll action, then uses the lock indicators to determine editability.

• Listing prepayments for an assignment action, including payment type and formatted value.
• Identifying prepayments locked by an SOE action using the M_ columns.
• Extracting formatted amounts for display in SOE statements.

Typical query:

SELECT assignment_action_id, pre_payment_id, payment_type_name, org_payment_method_name, value, currency_code, m_action_status FROM apps.pay_jp_soe_prepay_payments_v WHERE assignment_action_id = :p_assignment_action_id ORDER BY priority;

Because the view invokes package functions on every row, queries should always be constrained by assignment action or payroll action to avoid full scans.