PER Job Upload – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Upload to create and update jobs as in the Job window (Define Job): job group, name, dates, approval authority, additional employment rights, benchmark job and the Additional Job Details flexfield.

A row whose Name does not exist in the job group creates the job. Name is the concatenated Job flexfield segments of the job group’s structure; changing it on a downloaded row renames the job. End a job by entering its Date To.

Evaluation, requirements and valid grades of the Job window are not part of the upload.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Upload Mode, Business Group, Job Group, Job, Active Jobs Only

Oracle EBS Tables Used

per_job_groups, per_jobs_tl, per_jobs, per_business_groups

Report Categories

Enginatics, R12 only, Upload

PER Position Upload, PER Employee Salary Change, PER Previous Employment Upload, PER Person Assignment Upload

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output Example
Blitz Report™ XML Import PER_Job_Upload.xml
SQL Source PER Job Upload.sql
Full Report on Enginatics www.enginatics.com/reports/per-job-upload/

© Enginatics GmbH