Thursday, December 10, 2009

Initialization of Oracle apps

DECLARE
l_appl_id NUMBER;
l_appl_name VARCHAR2 (100) := 'PA';
l_user_id NUMBER;
l_user_name VARCHAR2 (100) := 'OPERATIONS';
l_responsibility_id NUMBER;
l_resp_name VARCHAR2 (200)
:= 'Projects, Vision Operations (USA)';
BEGIN

-- To get the Application ID of given Application.
SELECT application_id
INTO l_appl_id
FROM fnd_application
WHERE application_short_name = l_appl_name;

-- To get the User ID information of given user
SELECT user_id
INTO l_user_id
FROM fnd_user
WHERE user_name = l_user_name;

-- To get the Resp ID information of the given responsibility.
SELECT responsibility_id
INTO l_responsibility_id
FROM fnd_responsibility_tl
WHERE responsibility_name = l_resp_name AND application_id = l_appl_id;

--Initialixze the Application to use the API.
fnd_global.apps_initialize (l_user_id, l_responsibility_id, l_appl_id);
END;

Thursday, December 10, 2009 by Team search · 0

Creation of Buyer

Buyer Setup

1) In HRMS ‘People > Enter and maintain’,Create New Employee whose Last name must be same as User name Which we are logged in. Go to Assignment, Enter Org,Position and Job.Save the record.

2) In Sysadmin ‘Security > User > Define’,Query for the user & enter ‘person’ field with employee name created in HRMS.Save the record.

3) In PO ’ Setup >Personal > Buyers ‘, Create new buyer for our user. Now we can create a PO

4) In PO ’ Setup >Approvals > Approval groups ’, Create an approval group.

5) Go to ‘Setup >Approvals > Approval Assignments’ , Select the position ( as given in HRMS) and assign approval group for different document types. Now we can approve Documents

by Team search · 0

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.