API to UPDATE Oracle FND User
来源:互联网 发布:流光软件有毒吗 编辑:程序博客网 时间:2024/04/29 21:04
-- ------------------------------------------------
-- API to UPDATE Oracle FND User
-- ------------------------------------------------
DECLARE
lc_user_name VARCHAR2(100) := 'PRAJ_TEST';
lc_user_password VARCHAR2(100) := 'Oracle123';
ld_user_start_date DATE := TO_DATE('23-JUN-2012');
ld_user_end_date VARCHAR2(100) := NULL;
ld_password_date VARCHAR2(100) := TO_DATE('23-JUN-2012');
ld_password_lifespan_days NUMBER := 90;
ln_person_id NUMBER := 76104;
lc_email_address VARCHAR2(100) := 'PRAJ_TEST@def.com';
BEGIN
fnd_user_pkg.updateuser
( x_user_name => lc_user_name,
x_owner => NULL,
x_unencrypted_password => lc_user_password,
x_start_date => ld_user_start_date,
x_end_date => ld_user_end_date,
x_password_date => ld_password_date,
x_password_lifespan_days => ld_password_lifespan_days,
x_employee_id => ln_person_id,
x_email_address => lc_email_address
);
COMMIT;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
DBMS_OUTPUT.PUT_LINE(SQLERRM);
END;
修改前
修改后如图2
- API to UPDATE Oracle FND User
- API to CREATE FND User
- FND: Function Parameter How-to
- Unable To Import Or Enter Sale Order - ORA-20001: APP-FND-01564: ORACLE error - 1422 in get_seq_info
- How to manage Oracle Database User profile
- ORACLE grant connect, resource to user
- Design Preamble Your app includes an update button or alerts the user to update the app. To avoid us
- OAF-Error001:Oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESS
- update-api
- Update the SAFCode project to the new LLVM API
- Using API FND_PROFILE.save to update profile from backend
- how to update hire date of employee by api
- ERROR 1142 (42000): UPDATE command denied to user 'test'@'192.168.1.101' for table 'employees'
- unable to update security settings Access denied for user 'root@localhost(using password:yes)'
- To avoid user confusion, app version updates must utilize the iOS built-in update mechanism.
- mysql安装报错 - Unable to update security settings. Access denied for user 'root'@'loca
- mysql SELECT/UPDATE command denied to user 'root'@'localhost' for table 'XXX' 报错1142处理
- Oracle.apps.fnd.cp.request包常用java类分析
- 基于单幅图像的深度估计
- iOS开发ASIHTTPRequest进度追踪
- Animation Timing
- document.compatMode属性
- 代码库
- API to UPDATE Oracle FND User
- php ci框架之view
- 微软等工具资源下载站点
- centos6.4安装redmine
- MyBatis官方下载地址(含mybatis-spring)
- 两个字符串的最长公共子串
- Android基类设计方法详解
- 免费空间推荐
- web项目中加入filter,仍然存在乱码的解决方法