Loading Signing Limits (Oracle Payables Help)


	Previous	Next		Contents	Index	Navigation	Glossary	Library

Loading Signing Limits

The AP_WEB_SIGNING_LIMITS table maintains records of employee signing limits. Workflow can reference this table when it processes Payables and Web Employees transactions. For example, Workflow uses this table to find the employees with appropriate signing authority for each expense report entered using Oracle Web Employees. The AP_WEB_SIGNING_LIMITS table includes the following columns:

AP_WEB_SIGNING_LIMITS

DOCUMENT_TYPE NOT NULL VARCHAR2(30)

EMPLOYEE_ID NOT NULL NUMBER

COST_CENTER NOT NULL VARCHAR2(30)

SIGNING_LIMIT NUMBER

LAST_UPDATE_DATE NOT NULL DATE

LAST_UPDATED_BY NOT NULL NUMBER(15)

LAST_UPDATE_LOGIN NUMBER(15)

CREATION_DATE DATE

CREATED_BY NUMBER(15)

ORG_ID NUMBER(15)

Table 1 - 5. (Page 1 of 1)

If an employee has signing authority for more than one cost center, you must insert one record in this table for each unique combination of DOCUMENT_TYPE, COST_CENTER, EMPLOYEE_ID, and ORG_ID.

AP_WEB_SIGNING_LIMITS

DOCUMENT_TYPE	NOT NULL	VARCHAR2(30)
EMPLOYEE_ID	NOT NULL	NUMBER
COST_CENTER	NOT NULL	VARCHAR2(30)
SIGNING_LIMIT		NUMBER
LAST_UPDATE_DATE	NOT NULL	DATE
LAST_UPDATED_BY	NOT NULL	NUMBER(15)
LAST_UPDATE_LOGIN		NUMBER(15)
CREATION_DATE		DATE
CREATED_BY		NUMBER(15)
ORG_ID		NUMBER(15)
Table 1 - 5. (Page 1 of 1)

The value for DOCUMENT_TYPE for the AP Expense Report item type is APEXP. The ORG_ID column is null unless you are implementing in a multi-organization database.

You can enter and adjust signing limits for any employee in the Signing Limits window in Payables.

Loading Signing Limits

See Also