Entries by Oracle ERP Apps Guide

, ,

Oracle Application:Data Model

When we install Oracle Database by default system will creates SYS and SYSTEM schemas. These consist of all Data Dictionary Tables. Like this if we install Oracle Applications System will automatically creates schemas of all Modules (i.e. GL, AR, AP, etc.) with the respective module name as User and Password. Along with these schemas some […]

, , ,

Oracle Applications R12 Architecture

The Oracle E-Business Suite Release 12 Architecture is a framework for multi-tiered, distributed computing that supports Oracle Applications products. Architecture-R11i vs R12 In EBS R12, various servers or services are distributed among the following three levels, or tiers. The Desktop Tier The Application Tier The Database Tier Oracle E-Business Suite Release 12 Architecture 1] The […]

, ,

KFF vs. DFF: Differences

A flexfield in Oracle Application is a field made up of sub–fields, or segments.  They are basically used to implement code structure or to capture additional information. There are two types of flexfields: key flexfields and descriptive flexfields. A key flexfield appears on your form as a normal text field with an appropriate prompt while a descriptive flexfield appears on your […]

, , ,

HZ tables in Oracle Receivables

HZ_PARTIES:The HZ_PARTIES table stores basic information about parties that can be shared with any relationship that the party might establish with another party. The primary key for this table is PARTY_ID.Few Important Columns are PARTY_ID: Party identifier PARTY_NUMBER: Unique identification number for this party PARTY_NAME: Name of the party PARTY_TYPE: The party type can only […]