Search Results ap_web_signing_limits_v




Overview
Explore in AI Chat

Overview

AP_WEB_SIGNING_LIMITS_V is a valid, retrofitted APPS-owned view in the Oracle E-Business Suite Payables (AP) module. It presents employee-level signing limit records for the Oracle iExpenses / Payables Web-based approval hierarchy and is defined over the AP_WEB_SIGNING_LIMITS table joined to Oracle HRMS person views and the AP_LOOKUP_CODES view. The view was retrofitted specifically to accommodate both regular employees and contingent workers, resolving person names from two distinct HRMS sources and consolidating them through a UNION ALL.

The view is significant because it abstracts the underlying signing limit table and HRMS person lookups behind a single, security-aware interface. It exposes a human-readable EMPLOYEE_NAME alongside the raw EMPLOYEE_ID, making it directly consumable by reporting tools, Oracle Web ADI layouts, and custom approval-workflow extensions. The query searched by the user, "employee_name," corresponds to the HR.FULL_NAME alias that the view projects from both PER_EMPLOYEES_CURRENT_X and PER_CONT_WORKERS_CURRENT_X.

Underlying Base Objects

The view is defined over the following documented base objects:

  • AP_WEB_SIGNING_LIMITS (SYNONYM) — the primary transactional source holding employee signing limits by document type and cost center.
  • PER_EMPLOYEES_CURRENT_X (VIEW) — current employees, joined on SL.EMPLOYEE_ID = HR.EMPLOYEE_ID.
  • PER_CONT_WORKERS_CURRENT_X (VIEW) — current contingent workers, joined on SL.EMPLOYEE_ID = HR.PERSON_ID in the second UNION ALL branch.
  • AP_LOOKUP_CODES (VIEW) — resolves DOCUMENT_TYPE to a DISPLAYED_FIELD value where LOOKUP_TYPE = 'DOCUMENT TYPE'.
  • AP_WEB_DB_HR_INT_PKG (PACKAGE) — its ISPERSONCWK function filters regular employees from contingent workers so each branch returns the appropriate population.
  • FND_GLOBAL, HR_GENERAL, HR_PERSON_NAME, HR_SECURITY (PACKAGES) — referenced indirectly through the HRMS person views to support name formatting and row-level security.

The UNION ALL structure ensures that an employee appears once and only once, depending on whether ISPERSONCWK classifies them as a contingent worker.

Key Columns

  • ROW_ID — the ROWID of the AP_WEB_SIGNING_LIMITS row, used for update navigation.
  • EMPLOYEE_NAME — the HR FULL_NAME of the employee or contingent worker (the column users search for).
  • EMPLOYEE_ID — the person identifier linking to HRMS and approval hierarchy.
  • DISPLAYED_DOCUMENT_TYPE — the user-facing document type label from AP_LOOKUP_CODES.
  • DOCUMENT_TYPE — the lookup code value stored on the signing limit record.
  • COST_CENTER — the cost center to which the signing limit is scoped.
  • SIGNING_LIMIT — the monetary approval limit for the employee/document type combination.
  • ORG_ID — the operating unit, enabling multi-org security filtering.
  • Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY.

Common Use Cases and Queries

Typical uses include validating approval authority, auditing signing limits by cost center, and feeding external reporting. A simple lookup by the searched attribute is:

  • SELECT EMPLOYEE_NAME, EMPLOYEE_ID, DISPLAYED_DOCUMENT_TYPE, COST_CENTER, SIGNING_LIMIT FROM APPS.AP_WEB_SIGNING_LIMITS_V WHERE EMPLOYEE_NAME LIKE :p_name;
  • SELECT EMPLOYEE_ID, DISPLAYED_DOCUMENT_TYPE, SIGNING_LIMIT FROM APPS.AP_WEB_SIGNING_LIMITS_V WHERE ORG_ID = :p_org_id AND COST_CENTER = :p_cost_center;

Because the view already resolves document type labels and person names, it is preferred over querying AP_WEB_SIGNING_LIMITS directly for any reporting that requires descriptive fields.