Oracle Employee Approval Signing Limits in Oracle EBS Applications

There is no API and other Method To Enter Signing Limits Metalink Note (171837.1)

The only option is direct insert in base table.

 

INSERT

INTO ap_web_signing_limits_all

(

document_type,

employee_id,

cost_center,

signing_limit,

last_update_date,

last_updated_by,

last_update_login,

creation_date,

created_by,

org_id

)

VALUES

(

‘APEXP’,

987,

r1.cost_centre,

l_sup_amt,

SYSDATE,

gl_user_id,

gl_login_id,

SYSDATE,

gl_user_id,

2021

);