My Oracle Support Banner

Where To Find Information Related To Job Approval Values (Doc ID 2512383.1)

Last updated on OCTOBER 04, 2019

Applies to:

Oracle Fusion Purchasing Cloud Service - Version N/A and later
Information in this document applies to any platform.

Goal

We have a BIP data model get job information from per_jobs_f table. This table also stores approval level in APPROVAL_LEVEL field which are integer values that points to the amounts that a particular job can approve. I am looking to find the table that stores the actual values that corresponds to these codes stored in PER_JOBS_F.APPROVAL_LEVEL table to be included in the report output. I am currently using a case statement to convert the job codes to corresponding approval limits. Fetching the information directly from the table allow the solution to be dynamic in case these values are added or amended in future.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.