Search Results displayed_document_type

Overview

APPS.AP_WEB_SIGNING_LIMITS_V is an Oracle E-Business Suite reporting view that exposes the signing-limit authorizations configured for users of the Oracle Payables and Oracle Internet Expenses web-based approval and invoice workflows. It presents the approval authority assigned to individual employees and contingent workers across the document types handled by the AP Web approval engine, such as invoices, expense reports, and payment batches. Each row represents one combination of an approver, a document type, and, where applicable, a cost center, together with the monetary signing limit that applies.

The view is part of the AP_WEB schema family of objects and is owned by APPS. It plays a supporting role in the AP Web approval workflow, where the engine determines whether a given approver is authorized to release a document at its current amount. Because it presents signing limits in a denormalized, human-readable form — resolving employee identifiers to full names and lookup codes to displayed document types — it is also commonly used for reporting and audit purposes, allowing administrators and analysts to review approval hierarchies and delegation structures. The object is present in both Oracle EBS 12.1.1 and 12.2.2, where it follows the same definition.

Underlying Base Objects

The view is defined over three primary sources joined together, with a UNION ALL combining two population paths. The three sources are:

• AP_WEB_SIGNING_LIMITS (exposed through a SYNONYM) — the base table storing the actual signing-limit records, including employee identifier, document type, cost center, and signing limit amount.
• PER_EMPLOYEES_CURRENT_X — the HR current-employee view, supplying the full name for regular employees matched on EMPLOYEE_ID.
• PER_CONT_WORKERS_CURRENT_X — the HR current contingent-worker view, supplying the full name for contingent workers matched on PERSON_ID.
• AP_LOOKUP_CODES — an Oracle Payables view resolving the DOCUMENT_TYPE lookup code to its DISPLAYED_FIELD value, filtered by LOOKUP_TYPE = 'DOCUMENT TYPE'.

Supporting program units referenced in the definition include the package AP_WEB_DB_HR_INT_PKG, whose function ISPERSONCWK is used to exclude persons already identified as contingent workers from the employee branch, ensuring no approver is double-counted between the two UNION ALL legs. The metadata also lists FND_GLOBAL, HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY as referenced objects, reflecting the standard HR security and name-formatting infrastructure applied to the current-person views.

Key Columns

• ROW_ID — the ROWID of the underlying AP_WEB_SIGNING_LIMITS row, preserving a unique physical identifier.
• EMPLOYEE_NAME — the full name of the approver, resolved from the appropriate HR current-person view.
• EMPLOYEE_ID — the employee identifier; for contingent workers this is populated from PERSON_ID.
• DISPLAYED_DOCUMENT_TYPE — the user-facing description of the document type, resolved from AP_LOOKUP_CODES.DISPLAYED_FIELD.
• DOCUMENT_TYPE — the underlying lookup code indicating the document category.
• COST_CENTER — the cost center against which the signing limit is scoped, where applicable.
• SIGNING_LIMIT — the maximum monetary amount the approver is authorized to sign for the given document type.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — standard audit columns.
• ORG_ID — the operating unit (business group) context of the signing-limit record.

Common Use Cases and Queries

The view supports approval-authority reporting, segregation-of-duties review, and troubleshooting of approval workflow behavior. A basic listing of all signing limits for an employee is straightforward:

• SELECT employee_name, displayed_document_type, cost_center, signing_limit FROM ap_web_signing_limits_v WHERE employee_id = :p_employee_id ORDER BY displayed_document_type;
• SELECT employee_name, displayed_document_type, signing_limit FROM ap_web_signing_limits_v WHERE org_id = :p_org_id AND signing_limit >= :p_amount ORDER BY signing_limit DESC;
• SELECT displayed_document_type, COUNT(*) approvers, MAX(signing_limit) max_limit FROM ap_web_signing_limits_v GROUP BY displayed_document_type;

Because the view already resolves employee names and document-type descriptions, it is convenient for direct report extraction without additional joins to HR or lookup tables. Consumers should note that the two-leg UNION ALL ensures contingent workers appear once, and that the view is subject to the operating-unit and HR security context of the querying session, since it draws on the current-person HR views.