You are browsing the archive for Oracle Applications.

Oracle Apps Key Flex Fields

Oracle Applications KFF list

KFF IDKFF NAMEMODULE
GLLEGL Ledger FlexfieldGeneral Ledger
GL#Accounting FlexfieldGeneral Ledger
GLATReporting Attributes:AccountinGeneral Ledger
CAT#Category FlexfieldAssets
KEY#Asset Key FlexfieldAssets
LOC#Location FlexfieldAssets
CT#Territory FlexfieldReceivables
RLOCSales Tax Location FlexfieldReceivables
FEACActivity FlexfieldEnterprise Performance Foundation
FECOCost Object FlexfieldEnterprise Performance Foundation
SERVService ItemsInventory
MCATItem CategoriesInventory
MDSPAccount AliasesInventory
MICGItem CatalogsInventory
MKTSSales OrdersInventory
MSTKSystem ItemsInventory
MTLLStock LocatorsInventory
FII#Management FlexfieldFinancial Intelligence
FWKFWK Item FlexfieldCommon Modules-AK
GRDGrade FlexfieldHuman Resources
JOBJob FlexfieldHuman Resources
PEAPersonal Analysis FlexfieldHuman Resources
POSPosition FlexfieldHuman Resources
SCLSoft Coded KeyFlexfieldHuman Resources
ICXItem Contexts KeyflexHuman Resources
CAGRCAGR FlexfieldHuman Resources
CMPCompetence FlexfieldHuman Resources
BANKBank Details KeyFlexFieldPayroll
COSTCost Allocation FlexfieldPayroll
GRPPeople Group FlexfieldPayroll
RESTraining ResourcesLearning Management
ACCTAccount StructureAsia/Pacific Localizations
BPSPSB Position FlexfieldPublic Sector Budgeting
GRP#Group AssetCapital Resource Logistics – Assets
SGP#Super GroupCapital Resource Logistics – Assets
AHLOAHL OperationComplex Maintenance Repair and Overhaul
AHLRAHL RouteComplex Maintenance Repair and Overhaul
ZX#eBTax Context FlexfieldE-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