Wednesday, August 7, 2019

Diffierent types Apps Tables

_ALL Conatains multi org data before using this table you need to set client_into to specific org , Org_id is common column.

_V view created on base table

_VL view created on multi language tables.  always use the condition LANGUAGE = USERENV(’LANG’).

_TL Tables support multi language.

_B These Main base tables

_F these date tracked tables for only in HRMS and these table contain 2 common columns effective_start_date and effective_end_date

_S sequence related tables

_AVN Audit view shadow tables contains data track information

No comments:

Post a Comment

AME (Approval Management Engine)

AME (Approval Management Engine) : AME Stands for Oracle Approval Management Engine. AME is a self service web application that enables...