Posts

Showing posts with the label EBS

IExpense error : The specified approver is not a user of the application.

Image
Problem statement:   While creating the iexpense report user faces a issue that "The specified approver is not a user of the application. Please enter another approver. or select one from the list of values. Diagnosis: select * from per_all_people_f where full_name = &SupervisorName; Take the person_id and apply as an input in the below query select * from fnd_user where empolyee_id = &person_id; The result of the query will be no data found Soultion: Create the oracle/FND user for the supervisor. Navigation:  System administrator --> Define user check the below query, if it gives result then the issue has been resolved. Now you can try to re-create the expense report and you will be able to create the expense report this time select * from fnd_user where empolyee_id = &person_id;

Oracle Script to Copy Responsibilities of one user account to another user account

fnd_user_pkg.addresp is an Oracle Seeded API to add responsibilities to a user account. Please find below the pl/sql block using fnd_user_pkg.addresp API /*******************************************************************************  *PURPOSE: To copy responsibilities of one oracle user account to another oracle user account *  *AUTHOR: Oracle Apps Pie                                                *  *******************************************************************************/ -- -- DECLARE   --   resp_count NUMBER := 0;      CURSOR src_user_resp_details   IS      SELECT DISTINCT fa.application_short_name,       fr.responsibility_key                  ,       fsg.security_group_key,       furga.end...