🔹 Join the OracleApps88 Telegram Group - Stay up to date with the latest on Oracle EBS R12 and Oracle Cloud/Fusion Applications. 📌 Telegram Group : https://t.me/OracleApps88

💡 Facing issues copying code/scripts or viewing posts? We're here to help!
📬 Contact on Telegram : https://t.me/apps88
📱 Telegram/WhatsApp: +91 905 957 4321
📧 Email Support: OracleApp88@Yahoo.com

Saturday, September 26, 2015

Oracle Employee Signing/Approval Limits Conversion

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',             123,             r1.cost_centre,             l_sup_amt,             SYSDATE,             gl_user_id,             gl_login_id,             SYSDATE,             gl_user_id,
             201);

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect