Search Results com_si_info




Overview
Explore in AI Chat

Overview

APPS.PAY_JP_INPUT_VALUE_IDS_V is a Japanese localization view within the Oracle E-Business Suite Payroll (PAY) schema. Its purpose is to resolve the internal input value identifiers used by Oracle Payroll's Japanese statutory balance and reporting functionality, specifically for the Social Insurance (SI), Health Insurance (HI), and Welfare Pension (WP) processing requirements that apply to Japanese payroll operations. Rather than storing data itself, the view presents a single row per business group, surfacing the surrogate input value IDs that the payroll engine requires when it evaluates balance feeds, element input values, and regulatory reports for Japanese legal entities.

The view is comparatively narrow in scope but operationally significant: it acts as a lookup bridge, converting the business-friendly combination of an input value name and a business group into the numeric ID that downstream payroll processes and reports consume. Because these IDs are assigned dynamically when payroll elements and input values are defined, applications and custom reports should never hard-code them; this view provides the supported, data-driven way to obtain the correct values. In the context of the search term "com_si_info," the view is directly relevant, since two of its columns are derived from the COM_SI_INFO input value group.

Underlying Base Objects

According to the ETRM metadata, the view is owned by APPS and is defined over two documented objects:

  • PER_BUSINESS_GROUPS (view) — the driving row source, providing business_group_id and legislation_code for every business group defined in the enterprise. The view returns one output row per business group row.
  • PAY_JP_BALANCE_PKG (package) — the PL/SQL package whose function get_input_value_id is invoked once per derived column. This function accepts an input value group name, an input value name, a business group ID, and a legislation code, and returns the corresponding input value ID.

The view therefore has no direct base table of its own; it is a pure derivation layer over PER_BUSINESS_GROUPS, calling the Japanese payroll balance package seven times.

Key Columns

The view exposes the following columns, each produced by pay_jp_balance_pkg.get_input_value_id:

  • BUSINESS_GROUP_ID — the identifier of the business group, passed through from PER_BUSINESS_GROUPS.
  • COM_HI_QUALIFY_INFO / QUALIFY_DATE and DISQUALIFY_DATE — input value IDs for the health insurance qualification and disqualification date input values.
  • COM_SI_INFO / HI_LOCATION — the input value ID for the health insurance location associated with social insurance information. This is the first of the two columns tied to the searched term "com_si_info."
  • COM_WP_QUALIFY_INFO / QUALIFY_DATE and DISQUALIFY_DATE — input value IDs for welfare pension qualification and disqualification dates.
  • COM_SI_INFO / WP_LOCATION — the input value ID for the welfare pension location, the second column derived from COM_SI_INFO.
  • COM_SI_REPORT_INFO / OUTPUT_FLAG — the input value ID for the social insurance report output flag.

Common Use Cases and Queries

Typical usage includes driving Japanese payroll reports, validating element input value configuration, and supporting custom fast formulas or interfaces that must reference the correct input value IDs without hard-coding. A representative query follows:

  • SELECT business_group_id, hi_location, wp_location, output_flag FROM apps.pay_jp_input_value_ids_v WHERE business_group_id = :p_bg_id;
  • Join the view to payroll element or input value definitions using the returned IDs to confirm configuration consistency across business groups.
  • Use it in validation scripts that compare returned IDs against values expected by Japanese statutory reporting, flagging misconfigured business groups.