Oracle EBS : HRMS APIs List – used for Migrating External Data into HRMS

Below are use full API in HRMS most of time these API are used to migrate external data from legacy system to oracle apps

Updating the Per_periods_of_service table using

hr_ex_employee_api.update_term_details_emp

Terminate employee

hr_ex_employee_api.actual_termination_emp

Applying the final process in the shared instance using hr_ex_employee_api.final_process_emp

Re – Hire Employee

hr_employee_api.re_hire_ex_employee

Update  Existing Person in system

hr_person_api.update_us_person

Hire New Emp

hr_employee_api.create_us_employee

Costing

pay_cost_allocation_api.create_cost_allocation

Load  Assignment

hr_assignment_api.update_us_emp_asg

Load Update Assign Criteria

hr_assignment_api.update_emp_asg_criteria

Note : Contact Person Id Is To Be Passed

hr_contact_rel_api.create_contact

Note : Contact Person Id is passed as Null(default of API)

hr_contact_rel_api.create_contact

Load Phones

hr_phone_api.create_phone

hr_person_address_api.update_person_address

Load Addresses

hr_person_address_api.update_person_address

hr_person_address_api.create_person_address

Load Payment Methods

hr_personal_pay_method_api.create_us_personal_pay_method

Element Loading

py_element_entry_api.create_element_entry

py_element_entry_api.update_element_entry

Load Salaries

hr_upload_proposal_api.upload_salary_proposal

Salary Proposal

hr_maintain_proposal_api.approve_salary_proposal

State tax rules

pay_state_tax_rule_api.create_state_tax_rule

pay_state_tax_rule_api.update_state_tax_rule

County Tax Rules

pay_county_tax_rule_api.create_county_tax_rule

pay_county_tax_rule_api.update_county_tax_rule

City Tax Rules

pay_city_tax_rule_api.create_city_tax_rule

pay_city_tax_rule_api.update_city_tax_rule

Schools and Colleges

per_esa_upd.upd

per_esa_ins.ins

Performance Reviews

hr_perf_review_api.create_perf_review

hr_perf_review_api.update_perf_review

State Information Taxes

hr_sit_api.update_sit

hr_sit_api.create_sit

Qualifications

per_qualifications_api.create_qualification

per_qualifications_api.update_qualification

Locations

hr_location_api.update_location

hr_location_api.create_location

Organization

hr_organization_api.update_organization

hr_organization_api.create_org_classification

If any Change in Organization information.

if information2 = ‘Y’ then

hr_organization_api.enable_org_classification

If any Change in Organization information.

if information2 = ‘N’ then

hr_organization_api.disable_org_classification

If Organization does not exist in instance

hr_organization_api.create_organization api

Jobs

hr_job_api.update_job

hr_job_api.create_job

Positions

hr_position_api.update_position

hr_position_api.create_position

Oracle Purchasing – SQLs to debug / investigate PO issues

Get po_header_id first and run each query and then analyze the data.
For better understanding this is splited into 5 major stages.
Stage 1: PO Creation
PO_HEADERS_ALL
select po_header_id from po_headers_all where segment1 =;
select * from po_headers_all where po_header_id =;
PO_LINES_ALL
select * from po_lines_all where po_header_id =;
PO_LINE_LOCATIONS_ALL
select * from po_line_locations_all where po_header_id =;
PO_DISTRIBUTIONS_ALL
select * from po_distributions_all where po_header_id =;
PO_RELEASES_ALL
SELECT * FROM po_releases_all WHERE po_header_id =;

Stage 2: Once PO is received, data is moved to respective receving tables and inventory tables
RCV_SHIPMENT_HEADERS
select * from rcv_shipment_headers where shipment_header_id in
(select shipment_header_id from rcv_shipment_lineswhere po_header_id =);
RCV_SHIPMENT_LINES
select * from rcv_shipment_lines where po_header_id =;
RCV_TRANSACTIONS
select * from rcv_transactions where po_header_id =;
RCV_ACCOUNTING_EVENTS
SELECT * FROM rcv_Accounting_Events WHERE rcv_transaction_id IN
(select transaction_id from rcv_transactionswhere po_header_id =);
RCV_RECEIVING_SUB_LEDGER
select * from rcv_receiving_sub_ledger where rcv_transaction_id IN
(select transaction_id from rcv_transactions where po_header_id =);
RCV_SUB_LEDGER_DETAILS
select * from rcv_sub_ledger_detailswhere rcv_transaction_id IN
(select transaction_id from rcv_transactions where po_header_id =);
MTL_MATERIAL_TRANSACTIONS
select * from mtl_material_transactions where transaction_source_id =;
MTL_TRANSACTION_ACCOUNTS
select * from mtl_transaction_accounts where transaction_id IN
(select transaction_id from mtl_material_transactions where transaction_source_id =);

Stage 3: Invoicing details
AP_INVOICE_DISTRIBUTIONS_ALL
select * from ap_invoice_distributions_all where po_distribution_id in
( select po_distribution_id from po_distributions_all where po_header_id =);
AP_INVOICES_ALL
select * from ap_invoices_all where invoice_id in
(select invoice_id from ap_invoice_distributions_all where po_distribution_id in( select po_distribution_id from po_distributions_all where po_header_id =));

Stage 4 : Mostly there is tie up with Project related PO
PA_EXPENDITURE_ITEMS_ALL
select * from pa_expenditure_items_all peia where peia.orig_transaction_reference IN
(select to_char(transaction_id) from mtl_material_transactions where transaction_source_id = );

Stage 5 : General Ledger
Prompt 17. GL_BC_PACKETS ..This is for encumbrances
SELECT * FROM gl_bc_packets WHERE reference2 IN (’‘);
GL_INTERFACE
select * from gl_interface gli where user_je_source_name =’Purchasing’
and gl_sl_link_table =’RSL’ and reference21=’PO’ and exists
(select 1 from rcv_receiving_sub_ledger rrsl where gli.reference22 =RRSL.reference2 and GLI.reference23 =RRSL.reference3AND GLI.reference24 =RRSL.reference4AND RRSL.rcv_transaction_id in(select transaction_id from rcv_transactionswhere po_header_id ));
GL_IMPORT_REFERENCES
SELECT *FROM gl_import_references GLIR WHERE reference_1=’PO’ AND gl_sl_link_table =’RSL’AND EXISTS
( SELECT 1 FROM rcv_receiving_sub_ledger RRSLWHERE GLIR.reference_2 =RRSL.reference2AND GLIR.reference_3 =RRSL.reference3 AND GLIR.reference_4 =RRSL.reference4AND RRSL.rcv_transaction_id in
(select transaction_id from rcv_transactions where po_header_id =))

 

Oracle Forms : How to compile on Unix in 11i and R12

Login to Application Server on Unix Box for Compiling Forms

R11i

f60gen module=CUSTOM.pll userid=apps/(appspwd) module_type=LIBRARY batch=NO compile_all=special output_file=$AU_TOP/resource/CUSTOM.plx

f60gen module=XXPOCF.fmb userid=apps/(appspwd) module_type=form batch=no compile_all=special output_file=$XXPO_TOP/forms/US/XXPOCF.fmx

R12

$ORACLE_HOME/bin/frmcmp_batch module_type=LIBRARY module=$AU_TOP/resource/CUSTOM.pll userid=apps/(appspwd)output_file=$AU_TOP/resource/CUSTOM.plx compile_all=special

$ORACLE_HOME/bin/frmcmp_batch module=$XXFND_TOP/forms/US/XXFND_FHLOG.fmb userid=apps/(appspwd) output_file=$XXFND_TOP/forms/US/XXFND_FHLOG.fmx module_type=form compile_all=special

AIOUG – All India Oracle User Group – Webcasts

http://www.aioug.org/aioug_webcast.php#_Title:_ebus,

16th March -Migration Scenarios for Oracle E-Business Suite

Oracle E-Business Suite (EBS) is a complex application with many different permutations for this family of products. EBS deployments generally require a unique plan for each environment in order to properly migrate the data, application customizations, and product specific functionality to the target platform. I am going to talk about following migration approaches in details. Tru64/AlphaServer(EBS 11i) to HP-UX/Integrity(EBS R12) HP-UX/PA-RISC(EBS 11i) to HP-UX/Integrity(EBS R12) SUN Solaris/SPARC(EBS 11i) to HP-UX/Integrity and Linux/ProLiant(EBS 11i) – Split Configuration.

For more webcast and AIOUG Events –

Date	Time (IST)	Topic	Speaker	Type
11-AUG-2010	9:00 AM	All About Dead Locks	Arup Nanda	Members
September		Sangam10		Conference
13-OCT-2010	5:00 PM	RMAN: Backup and Recovery – The Most Essential but The Most Ignored	Asif Momen	Members
17-NOV-2010	5:00 PM	Extreme Performance with EXADATA	Satyendra Kumar	Members
08-DEC-2010	5:00 PM	TBD	TBD	Members
12-JAN-2011	9:00 AM	11gR2 New Features in RAC – Part I – Whats news in Clusterware!!	Murali Vallath	Members
February		TechNight @ Chennai	Free	Free Event
09-FEB-2011	9:00 AM	Oracle Performance Tuning	Kapil Goyal	Members
16-MAR-2011	5:00 PM	Migration Scenarios for Oracle E-Business Suite	PS Janakiram	Free Event
13-APR-2011	5:00 PM	Oracle Scheduler and the Database Resource Manager	Bala Kumar	Free Event
11-MAY-2011	5:00 PM	Oracle Application(EBS) Upgrade Best Practices	Mithun Ashok	Free Event
June		TechDay @ TBD	Free	Free Event

 

Oracle Technical – A Poem using Oracle Concepts

Life is an Oracle…
Make your life as deep as a Database.
Be always as unique as a Primary Key.
Be productive as an Index.
Take others’ good habits as a Foreign Key.
Share your joys with others as a Cluster.
Always keep note of your doings as good as a Data Dictionary.
Grant some privileges to others as a Role.
Secure the things as a DBA.
Do the things in order as a Rowid.
Follow your resolution as strict as a Sequence.
Light other’s life as a Trigger.
Be prepared for the worst as an Exception.
Always be fruitful as a Function.
Forgive others as a Rollback Transaction.
Be thankful to God as a Commit Transaction.
Always help others like Checkpoint.
Choose the best path like an Optimizer.
Project yourself the best like a View.
DO ALL THESE, YOUR PLACE WILL BECOME ORACLE

Joomla Day India 2011 in Pune

The target audience will be primarily Joomla! Content Management System developers, designers, administrators and users, Business owners & technologists as well as Joomla end users this means that anyone can come to Joomla Day  and participate.

Delegates will come from a range of public and private sectors, both national and international, in various markets, actively seeking information about Joomla! and other areas of web-based technology.

Event Details– Date : 12th & 13th March, 2011. Saturday, Sunday.

Venue :
Bajaj Gallery,
MCCIA Trade Tower,
5th floor, International Conventional Center,
Senapati Bapat Road,
Pune

Registration – FREE — http://ticketing.ayojak.com/event/joomla-day-india-2011

 

Things we need less and things need more

Courtesy to – HBR Blog  Full article - http://blogs.hbr.org/schwartz/2011/03/30-things-we-need-and-30-we-do.html

Do you have the feeling, as I do, that in the tsunami of everyday life, we’re getting too much of stuff we don’t need, and not enough of what we do? Herewith my first set of suggestions about how to redress the imbalance:

WE NEED LESS:	WE NEED MORE:
Information	Wisdom
Shallow billionaires	Passionate teachers
Self-promotion	Self-awareness
Multitasking	Control of our attention
Inequality	Fairness
Sugar	Lean protein
Action	Reflection
Super sizes	Smaller portions
Private jets	High-speed trains
Calculation	Passion
Experts	Learners
Blaming	Taking responsibility
Judgment	Discernment
Texting	Reading
Anger	Empathy
Output	Depth
Constructive criticism	Thank-you notes
Possessions	Meaning
Righteousness	Doing the right thing
Answers	Curiosity
Long hours	Longer sleep
Complaining	Gratitude
Sitting	Moving
Selling	Authenticity
Cynicism	Realistic optimism
Self-indulgence	Self-control
Speed	Renewal
Emails	Conversations
Winning	Win-win
Immediate gratification	Sacrifice