Oracle Application Blog

Create Project party in oracle projects accounting using PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY

DECLARE l_project_id_PREM         PA_PROJECT_PARTIES.PROJECT_ID%TYPE  :=NULL; l_project_role            VARCHAR2(240) :=NULL; l_resource_name           PER_ALL_PEOPLE_F.FULL_NAME%TYPE :=NULL; l_start_date_active       DATE :=NULL; l_end_date_active     …

Read More

Create or Update HR location in oracle apps

SET DEFINE OFF; CREATE OR REPLACE PACKAGE      apps.xxal_hr_location_cre_upd_api AUTHID DEFINER IS    l_count         NUMBER;    l_location_id   NUMBER;    PROCEDURE create_location (       p_validate …

Read More

API to create projects in Oracle Project Accounting using PA_PROJECT_PUB

SET DEFINE OFF; create or replace PACKAGE      apps.xxal_pa_project_creation AUTHID DEFINER IS    PROCEDURE create_project (       p_api_version_number       IN             …

Read More

Update Oracle Project information using PA_PROJECT_PUB.

SET DEFINE OFF; CREATE OR REPLACE PACKAGE BODY apps.xxal_pa_project_creation AS    PROCEDURE create_project (       p_api_version_number       IN              NUMBER    …

Read More

iExpenses – change the lable name in template

From Sysadmin Responsibility: 1.       Navigate to the Functional Administrator responsibility à Personalization. 2.       Provide Document path like “/oracle/apps/ap/oie/webui/OIEREVIEWSUMMARY” and click on GO tab and from search results Personalize Page icon…

Read More

API to Update Profile Value – SSO to Local

DECLARE L_SUCCESS BOOLEAN; CURSOR uid is SELECT user_name,user_id from fnd_user where user_name in (select user_name from apps.fnd_user where email_address in (select email_address from apps.per_all_people_f where 1=1 and employee_number in (‘215677…

Read More

API to Update Profile Value – Local to SSO

DECLARE L_SUCCESS BOOLEAN; CURSOR uid is SELECT user_name,user_id from fnd_user where user_name in (select user_name from apps.fnd_user where email_address in (select email_address from apps.per_all_people_f where 1=1 and employee_number in (‘215677’…

Read More

Script to delete the employee record using API in oracle

–Create Table create table papf_16082018 (person_id number, employee_number varchar2(10)); –Insert Data insert into papf_16082018 values (53687,’215677′); commit; update apps.fnd_user set employee_id=null where employee_id in                 (select distinct p.person_id from apps.per_all_people_f…

Read More

Export employee data with personal expenses in i-expense and the expense is not claimed

SELECT pap.full_name, pap.email_address, pap.employee_number,                 aeh.invoice_num, aeh.total total_amount,                 aeh.amt_due_employee personal_amount, aeh.expense_status_code,                 aeh.report_header_id, aeh.employee_id, aeh.org_id, aeh.ROWID,                 round((trunc(sysdate)-trunc(aia.creation_date)))days,aia.creation_date            FROM ap_expense_report_headers_all aeh, per_all_people_f pap,ap_invoices_all aia           WHERE aeh.employee_id =…

Read More

Employee data extract based on business group

SELECT      hou.name                business_unit,      papf1.first_name,      papf1.middle_names,      papf1.last_name,      papf1.full_name         emp_full_name,      pj.name                 employeee_job_desc,      pj.attribute16          wd_job,      papf1.employee_number   employee_number,      papf1.email_address     employee_email_hr,      fu.email_address        employee_email_fnd,      fu.user_name           …

Read More