Oracle ERP R12. Unassign or delete large number of items .

There is an option on the Tools menu of the Delete Item form that opens the Item Search screen.
There you can search on a number of criteria, including status, and the search results are populated in your Delete Group.
You can review the list, and delete unwanted entries (or add new ones, if necessary).

Then run the Delete process.

Reference from Metalink : ID 1347893.1

Oracle ERP R12. 使用者忘記密碼 如何自行變更密碼

分享同事提供的自行變更密碼做法:

1. 在登入畫面下方,點選”Login Assistance”

2. 輸入帳號,點選"Forgot Password" , 系統就會發送密碼重設的mail至該帳號上所定義的mail

3. 待收到mail後,點選mail內"Reset your password"的超連結,即可進入密碼重設的畫面. 

狗爸的世界: Oracle ERP R12. 使用interface批量變更品號的operation code ....

狗爸的世界: Oracle ERP R12. 使用interface批量變更品號的operation code ....: Sample code : DECLARE   --   T_OLD_OP VARCHAR2(10) := '2T02';  --**** old operation code   T_NEW_OP VARCHAR2(10) := '2S02...

狗爸的世界: Oracle ERP R12. - 如何快速複製使用者權限 , How to grant privi...

狗爸的世界: Oracle ERP R12. - 如何快速複製使用者權限 , How to grant privi...: 以下Sample是當有新人時,可以快速複制user a 的權限至user b的作法 ~ My Sample code : (Package) /*PACKAGE HEADER*/ CREATE OR REPLACE PACKAGE XX_FND_USER_RESP_P...

狗爸的世界: Oracle ERP R12. 如何使用API (FND_USER_PKG)建立帳號. How to...

狗爸的世界: Oracle ERP R12. 如何使用API (FND_USER_PKG)建立帳號. How to...: 以下是使用FND_USER_PKG.CREATEUSER 建立使用者的範例程式碼 Sample code : FND_USER_PKG.CREATEUSER(X_USER_NAME            => :USER_NAME , --USER ACCOUNT ...