OA Frawework – External LOV

In this post, we will discuss about implementing an External LOV in OAF. To understand the implementation better, please have a look at the diagram below.   As shown in the diagram, we create a LOV Region in the project

Tagged with: , , , , , ,
Posted in OAF, Oracle

Oracle HR – Person Details Tables.

The indicative details of all persons are stored in table PER_ALL_PEOPLE_F. This table stores the historic and current information of the employee based on the Date track mode used during the record updates. Tables below present the same data, but

Tagged with: , , , ,
Posted in HRMS and Payroll, Oracle

Oracle HR – Date Tracking

Date tracking in Oracle E-business is a mechanism to store data based on dates. This helps storage of historical data along with current data in the system. The date tracked tables in Oracle end with ‘_F’ and have columns EFFECTIVE_START_DATE

Tagged with: , , , ,
Posted in HRMS and Payroll, Oracle

Execution Plans

Originally posted on Oracle Scratchpad:
This is the index to a series of articles I’ve been writing for redgate, published on their AllThingsOracle site, about generating and reading execution plans. I’ve completed a few articles that haven’t yet been published, but I’ll…

Posted in Uncategorized

Oracle HR – Script for Adding phone details for Employees

The requirement was to add phone details ( Work phone number, work mobile number) a list of employees. We have implemented this using hr_phone_api Process Steps: 1. Create a temp table CREATE TABLE load_phone_temp AS SELECT parent_id,phone_number work_phone,phone_number mobile_phone FROM

Tagged with: , , , , , , ,
Posted in HRMS and Payroll, Oracle

Oracle Payroll – P45 Reversal

Customer reverse a P45 which was issued in error. This can be done using ‘GB Rollback’ Concurrent Program Navigation Path: Payroll > View > Requests > Submit a Request Concurrent Program: GB Rollback Parameters: Year Process Type: Magnetic Report Payroll

Tagged with: , , , ,
Posted in HRMS and Payroll, Oracle

Oracle HRMS: Cannot delete an employee – Assignment Extra Information Exists

Issue: User cannot delete an employee record on HRMS People Enter and Maintain screen as there are assignment extra information exists for the employee. Solution: Use API to delete assignment extra information for the employee. /* Formatted on 2014/04/23 09:50

Tagged with: , , , , , , ,
Posted in HRMS and Payroll, Oracle, scripts

Querying date tracked views – Oracle

When we try to query pay_balance_feeds_v on TOAD, but did not get any rows. SELECT * FROM pay_balance_feeds_v This is because the view ( most of the views in Oracle HR/Payroll) are date tracked, which means the data can only

Tagged with: , , , ,
Posted in Oracle, Payroll, plsql

1z0-144: SELECT FOR UPDATE/ WHERE CURRENT OF

SELECT FOR UPDATE statement allows us to lock the records in the cursor result set. The lock will be released when a transaction control statement like ROLLBACK/COMMIT is executed. CURSOR cursor_name IS select_statement FOR UPDATE [of column_list] [NOWAIT]; WHERE CURRENT OF is

Tagged with: , , , , , , ,
Posted in 1z0-144, Oracle, plsql

Oracle GL- Financial Statement Generator

What is FSG? FSG is short form for Financial Statement Generator.  It is a powerful reporting tool available in Oracle EBS to create reports which meet user defined criteria. The reports can be defined by the user and can be

Tagged with: , , , , , ,
Posted in General Ledger, Oracle
Follow

Get every new post delivered to your Inbox.