You are browsing the archive for Oracle Applications.

Oracle Apps Key Flex Fields

Oracle Applications KFF list

KFF ID KFF NAME MODULE
GLLE GL Ledger Flexfield General Ledger
GL# Accounting Flexfield General Ledger
GLAT Reporting Attributes:Accountin General Ledger
CAT# Category Flexfield Assets
KEY# Asset Key Flexfield Assets
LOC# Location Flexfield Assets
CT# Territory Flexfield Receivables
RLOC Sales Tax Location Flexfield Receivables
FEAC Activity Flexfield Enterprise Performance Foundation
FECO Cost Object Flexfield Enterprise Performance Foundation
SERV Service Items Inventory
MCAT Item Categories Inventory
MDSP Account Aliases Inventory
MICG Item Catalogs Inventory
MKTS Sales Orders Inventory
MSTK System Items Inventory
MTLL Stock Locators Inventory
FII# Management Flexfield Financial Intelligence
FWK FWK Item Flexfield Common Modules-AK
GRD Grade Flexfield Human Resources
JOB Job Flexfield Human Resources
PEA Personal Analysis Flexfield Human Resources
POS Position Flexfield Human Resources
SCL Soft Coded KeyFlexfield Human Resources
ICX Item Contexts Keyflex Human Resources
CAGR CAGR Flexfield Human Resources
CMP Competence Flexfield Human Resources
BANK Bank Details KeyFlexField Payroll
COST Cost Allocation Flexfield Payroll
GRP People Group Flexfield Payroll
RES Training Resources Learning Management
ACCT Account Structure Asia/Pacific Localizations
BPS PSB Position Flexfield Public Sector Budgeting
GRP# Group Asset Capital Resource Logistics – Assets
SGP# Super Group Capital Resource Logistics – Assets
AHLO AHL Operation Complex Maintenance Repair and Overhaul
AHLR AHL Route Complex Maintenance Repair and Overhaul
ZX# eBTax Context Flexfield E-Business Tax

Oracle Apps Jobs

Oracle Corporation is one of the largest global software firm. It has software products to cover many aspects of enterprise ranging from database to servers, middleware, ERP, CRM, PLM. Even in economy downturn there are plenty of oracle jobs for skilled professionals.

Lets discuss about Oracle jobs for Oracle Apps professionals (Oracle Apps also known as Oracle Applications, Oracle eBusiness suite, Oracle ERP, Fusion Apps).

Oracle Jobs – Functional:

Responsibilities:

  • Requirements Gathering
  • Business process mapping with oracle appsĀ  product features.
  • Gap analysis
  • Configuring setups
  • Functional solution design
  • User Training
  • Issue Resolution

Skill set required:

  • Knowledge in one or more Oracle Manufacturing, Distribution, Purchasing, Financials, Engineering suite of modules
  • Functional experience in relevant industry
  • Strong business analysis skills
  • Excellent communication skills

Oracle Jobs – Technical:

Responsibilities:

  • Technical solution design
  • Forms Design
  • Reports Design
  • Interface Design
  • Unit Testing
  • Performance tuning
  • Issue resolution

Skill Set required

  • SQL, PL/SQL skills
  • Oracle report designer
  • Oracle forms design & Application Development Framework (ADF)
  • Oracle database & apps table structure knowledge
  • XML Publisher knowledge
  • Oracle triggers, alerts, procedures
  • Oracle workflow
  • Good communication skills
  • Oracle functional knowledge is a plus

Oracle Jobs – System Admin & DBA:

  • Oracle Database knowledge
  • Database backups
  • Database restore
  • Patch analysis & recommendations
  • Concurrent Program Que management
  • Application / Database Upgrades

Popular Oracle jobs web sites:

jobs.oracle.com

indeed.com/q-Oracle-jobs.html

dice.com

simplyhired.com/a/jobs/list/q-oracle

glassdoor.com/Job/Oracle-Jobs-E1737.htm

justoraclejobs.com

www.net-temps.com

Oracle Application Implementation Tables

List of database tables for Oracle Application Implementation module:

  • AZ_APIS
  • AZ_API_ATTRIBUTES
  • AZ_API_DEPENDENCIES
  • AZ_API_DEPENDENCY_ATTRIBUTES
  • AZ_ARCHIVE
  • AZ_ARCHIVE_STEPS
  • AZ_CONTEXTS_SQL
  • AZ_DIFF_RESULTS
  • AZ_FILES
  • AZ_GROUPS
  • AZ_INSTANCES
  • AZ_MORG_TRIGGERS
  • AZ_PROCESSES
  • AZ_PRODUCT_FLOWS
  • AZ_PRODUCT_PHASES
  • AZ_REGISTRATION_ACCTS
  • AZ_REPORTER_DATA
  • AZ_REQUESTS
  • AZ_SELECTION_SETS_B
  • AZ_SELECTION_SETS_TL
  • AZ_SELECTION_SET_APIS
  • AZ_SELECTION_SET_ENTITIES_B
  • AZ_SELECTION_SET_ENTITIES_TL
  • AZ_STRUCTURES_B
  • AZ_STRUCTURES_TL
  • AZ_STRUCTURE_APIS_B
  • AZ_STRUCTURE_APIS_TL
  • AZ_TEMPLATES