Results for “secured_data”

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

Overview

APPS.PA_PROJECT_FUNDINGS_V is a secured reporting view over project funding records in Oracle Projects. It exposes the allocation of a funding amount from a funding agreement to a specific project and, optionally, to a specific task, together with the full set of multi-currency amounts maintained by the funding engine. The view's distinguishing characteristic is that it does not expose raw project, task, and task-name values unconditionally. Instead, each of the four descriptive columns (project number, project name, task number, and task name) is wrapped in a DECODE(pa_security.allow_query(P.project_id), 'Y', <real value>, SUBSTR(PA_PROJ_ELEMENTS_UTILS.Get_PA_Lookup_Meaning('TRANSLATION', 'SECURED_DATA'), 1, n)) construct. When the current user is not authorized to query the project, the real value is replaced by a translated lookup meaning for the token SECURED_DATA, truncated to the appropriate column width.

This design is why user searches on the string "secured_data" resolve to this view. The token is not a column or a table; it is a substitution label that masks data the caller may not see. The view therefore serves as the security boundary for funding information consumed by concurrent programs, Oracle Forms, OAF pages, and third-party integrations.

Underlying Base Objects

The documented base objects are:

• PA_PROJECT_FUNDINGS (synonym) — the driving table, aliased F, supplying the primary key PROJECT_FUNDING_ID, foreign keys, all currency allocations, and the descriptive flexfield attributes ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE10.
• PA_PROJECTS_ALL (synonym) — aliased P, supplying SEGMENT1, NAME, and the billing and invoicing currency defaults such as PROJECT_BIL_RATE_DATE_CODE, PROJFUNC_BIL_RATE_DATE_CODE, and INVPROC_CURRENCY_TYPE.
• PA_TASKS (synonym) — aliased T, supplying TASK_NUMBER and TASK_NAME.
• PA_PROJECT_TYPES_ALL (synonym) — aliased PT, supplying ALLOWABLE_FUNDING_LEVEL_CODE and PROJECT_TYPE_CLASS_CODE.
• PA_SECURITY (package) — provides allow_query, the function that evaluates project-level security for the session.
• PA_PROJ_ELEMENTS_UTILS (package) — provides Get_PA_Lookup_Meaning, used to resolve the SECURED_DATA substitution text.
• PA_MULTI_CURRENCY (package) — provides Get_User_Conversion_Type, which translates stored rate type codes into user-facing rate type names.

Key Columns

• PROJECT_FUNDING_ID — primary key of the funding row; the join key back to PA_PROJECT_FUNDINGS for any update.
• PROJECT_ID, TASK_ID, AGREEMENT_ID — the project, optional task, and funding agreement to which the allocation belongs.
• BUDGET_TYPE_CODE — the budget type receiving the funded amount.
• ALLOCATED_AMOUNT, DATE_ALLOCATED — the entered funding amount and the date it was allocated.
• PROJECT_ALLOCATED_AMOUNT, PROJFUNC_ALLOCATED_AMOUNT, INVPROC_ALLOCATED_AMOUNT, REVPROC_ALLOCATED_AMOUNT — the same amount converted into project, project functional, invoice processing, and revenue processing currencies.
• FUNDING_CURRENCY_CODE, PROJECT_CURRENCY_CODE, PROJFUNC_CURRENCY_CODE, INVPROC_CURRENCY_CODE, REVPROC_CURRENCY_CODE — the currency associated with each stored amount.
• PROJECT_EXCHANGE_RATE, PROJFUNC_EXCHANGE_RATE, INVPROC_EXCHANGE_RATE, REVPROC_EXCHANGE_RATE — the rates applied for each conversion, with the corresponding PROJECT_RATE_TYPE, PROJFUNC_RATE_TYPE, and date columns.
• PROJECT_RATE_TYPE_NAME, PROJFUNC_RATE_TYPE_NAME — user-facing conversions derived through PA_MULTI_CURRENCY.
• ALLOWABLE_FUNDING_LEVEL_CODE, PROJECT_TYPE_CLASS_CODE — project type attributes that determine whether funding is allowed at project or task level.
• PM_FUNDING_REFERENCE, PM_PRODUCT_CODE — reference and product identifiers used when funding originates from another application or external source.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–10 — descriptive flexfield context and segments.
• ROW_ID — the ROWID of the underlying PA_PROJECT_FUNDINGS row.

Common Use Cases and Queries

The view is typically queried to list funding allocated to a project, to reconcile funded amounts by currency, or to detect rows where descriptive values are masked for the current user.

• List funding for a project with its budget type and allocated amount, ordered by allocation date.
• Compare ALLOCATED_AMOUNT to the project functional and invoiced amounts to validate exchange rate treatment.
• Filter on ALLOWABLE_FUNDING_LEVEL_CODE to determine whether task-level funding rows are expected for a project type.
• Detect security masking by comparing the project number column against PA_PROJECTS_ALL.SEGMENT1 joined on PROJECT_ID.

A representative query:

SELECT project_funding_id, project_id, task_id, budget_type_code, allocated_amount, project_allocated_amount, projfunc_allocated_amount, funding_currency_code, date_allocated FROM apps.pa_project_fundings_v WHERE project_id = :p_project_id ORDER BY date_allocated;

Because the masking logic invokes PA_SECURITY for every row, queries returning large funding populations should constrain PROJECT_ID or AGREEMENT_ID whenever possible to limit the number of security evaluations performed.