+ Write Article

Oracle Articles Examples, Tutorials and Articles

Published by
Introduction

The code here is used for delete all data generated from Accrual Load Run program, if using Online Accrue (perpetual)

Background

After using the PL/SQL code, you can run accrual load run again and use AP and PO Reconciliation Report to see the ...
Read More Read More
Published by
Introduction

Useful queries for Oracle Apps

Background

It's very useful in Day to Day Work for functional consultants.

The code

By using this Scripts we will get the basic information ...
Read More Read More
Published by
1.Query to get Account Code Combination Description

Code sql:
SELECT gl_flexfields_pkg.get_concat_description
                                          (chart_of_accounts_id,
                                           code_combination_id
...
Read More Read More
Published by
Count of records processed with a particular Request ID:

Code sql:
==================================================== 
SELECT COUNT(1) 
FROM   apps.XLA_EVENTS 
--where  application_id = 222   
WHERE    request_id = XXXXXXXX; 
=========================================================
...
Read More Read More
Published by
Transferring Assets Steps

You can transfer assets between employees, depreciation expense accounts, and locations.

Transferring a single asset

To transfer an asset between employees, expense accounts, and locations:

1. Choose Asset > Asset ...
Read More Read More
Published by
Use this query to find the mailer address to be used in SMTP

Code sql:
SELECT b.component_name, 
c.parameter_name, 
a.parameter_value 
FROM apps.fnd_svc_comp_param_vals a, 
apps.fnd_svc_components b, 
apps.fnd_svc_comp_params_b c 
WHERE b.component_id =
...
Read More Read More
Published by
EBS Tax Rule Set Up to Override existing Tax Rule

The issue: User could not create manual AR Invoice with a given Tax Code as it was throwing error that the Tax Rate Code is not valid. On investigation on existing Tax Set Up, it was found that the “Determine Place of Supply” is set to ...
Read More Read More
Published by
The following is a Query to fetch employee details in Oracle HRMS

Code sql:
SELECT 	 papf.person_id 		person_no
		,papf.employee_number 	empno
		,papf.full_name 		emp_name
		,papf.date_of_birth		dob
		,pj.job_id			job_no
		,pj.name			job_name
		,pap.position_id
...
Read More Read More
Published by
Create Employee API

The hr_employee_api.create_employee procedure holds the script to do interface to create employee

Code:

Code sql:
DECLARE
 
 
 LC_EMPLOYEE_NUMBER                                PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE
...
Read More Read More
Published by
The following is a Query to get PR and PO Details

Code sql:
SELECT poh.segment1 po_number, pol.line_num, pol.item_description,
       ploc.quantity, mtl.segment1 || ',' || mtl.segment2 po_item,
       prh.segment1 req_num, fnd.user_name requestor, prl.need_by_date
...
Read More Read More

Page 1 of 10 1 2 3 4 5 6 7