Results for “pa_cint_rate_info”

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

Overview

The view PA_CINT_RATE_INFO is a single-organization (single-org) view belonging to the Oracle Projects (PA) module. It is created specifically to support a form-based user interface in Oracle E-Business Suite, functioning as a security-enabled wrapper over the underlying multi-org table PA_CINT_RATE_INFO_ALL. The "_ALL" suffix on the base table confirms that the stored data is partitioned by operating unit through the ORG_ID column, and the view applies a runtime filter to restrict visible rows to the organization currently set in the user's session.

In the context of the search term "interest_calculation_method," this view is the reporting and form-layer access point for the INTEREST_CALCULATION_METHOD column. This column determines how interest is computed against unpaid project invoices and expenditures—typically specifying standard, simple, or compounded interest treatment. Because the view exposes this attribute alongside the relevant cost code, rate code, and threshold parameters, it serves as a compact source of interest-rate configuration data for a given operating unit.

The ETRM metadata notes that the object is "Not implemented in this database." This indicates the view was documented but not instantiated in the reference environment, though its definition remains valid for the 12.1.1 and 12.2.2 releases.

Underlying Base Objects

The view is defined over a single documented base object, PA_CINT_RATE_INFO_ALL, which stores interest-rate setup records across all operating units. The view text performs a direct projection of columns from this table with no joins to other tables, and applies row-level filtering through a WHERE clause that resolves the current organization context.

The organization filter relies on the USERENV('CLIENT_INFO') facility. The view extracts the first ten characters of CLIENT_INFO, converts the value to a number, and compares it against ORG_ID. Where CLIENT_INFO's first character is a space, NULL is substituted; when no client information exists, the value defaults to -99. The same expression is applied to both the RATE.ORG_ID column and the session value, using NVL on each side, ensuring that records for the active operating unit are returned consistently.

Key Columns

• INTEREST_CALCULATION_METHOD — Specifies the method used by Oracle Projects to calculate interest on delinquent amounts; central to the user's search.
• IND_COST_CODE — Identifies the expenditure or cost code to which the interest rate configuration applies.
• EXP_ORG_SOURCE — Indicates the source organization used for expenditure determination.
• PROJ_AMT_THRESHOLD / TASK_AMT_THRESHOLD — Monetary thresholds, at project and task level, above which interest calculation applies.
• PROJ_DURATION_THRESHOLD / TASK_DURATION_THRESHOLD — Time-based thresholds governing when interest begins to accrue.
• CURR_PERIOD_CONVENTION — Defines the convention used for the current accounting period when applying interest.
• PERIOD_RATE_CODE — References the interest rate code applicable per period.
• THRESHOLD_AMT_TYPE / BUDGET_TYPE_CODE / FIN_PLAN_TYPE_ID — Identify the threshold amount type, budget type, and financial plan type used in configuration.
• ORG_ID — The operating unit identifier driving the single-org filter.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard auditing columns.

Common Use Cases and Queries

This view is most often queried to audit interest-rate configuration, confirm the calculation method applied to a cost code, or reconcile threshold and duration parameters across an operating unit. Because it is single-org, queries issued through a form or a session with CLIENT_INFO set automatically return only the relevant organization's rows.

To inspect interest calculation method settings:

• SELECT ind_cost_code, interest_calculation_method, period_rate_code, proj_amt_threshold, task_amt_threshold FROM pa_cint_rate_info;

To list all configured rate codes with their thresholds and budget types:

• SELECT org_id, ind_cost_code, interest_calculation_method, threshold_amt_type, budget_type_code, fin_plan_type_id FROM pa_cint_rate_info ORDER BY ind_cost_code;

To review audit metadata for recently modified configuration:

• SELECT ind_cost_code, interest_calculation_method, last_updated_by, last_update_date FROM pa_cint_rate_info WHERE last_update_date > SYSDATE - 30;

For cross-organization reporting, the base table PA_CINT_RATE_INFO_ALL should be queried instead, since the view restricts results to a single operating unit determined by the session context.