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
Advertisements

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


 Joomla! Day India - March 12th and 13th, 2011

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

 

 Joomla! Day India - March 12th and 13th, 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