DBA Data[Home] [Help] [Dependency Information]

TABLE: AX.AX_SETUP_GLOBAL

Object Details
Object Name: AX_SETUP_GLOBAL
Object Type: TABLE
Owner: AX
FND Design Data: TableAX.AX_SETUP_GLOBAL
Subobject Name:
Status: VALID


This table stores the global system parameters. It is a single row
table.
The column CHAR_MODE_FLAG exists for backward compatibility purposes
and it is used to detect non-GUI installations not having used the
Setup forms. This column is pre-seeded with 'Y' and it is
updated to 'N' every time the GUI setup form performs a commit.
Users cannot use the Load program to load rules once the GUI Setup
forms are used. This is to ensure that the users continue setup using
the forms once it is initiated.
The column AX_ENABLED is set to 'Y' if at least a subledger is
defined (row in AX_SETUP_SUBLEDGER). As such, it is a
denormalization.
The column SETUP_STATUS shows the status of the AX setup. It is
initially set to 'NOT_FROZEN' and is set to 'FROZEN' when the setup
freeze process completes successfully.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
AX_ENABLED VARCHAR2 (1) Yes AX is enabled in at least one subledger system
COMMIT_BATCH_SIZE NUMBER
Yes Size of commit batch for event translation
BAL_COMMIT_BATCH_SIZE NUMBER
Yes Size of commit batch for balance calculation
SLEEP_TIME NUMBER
Yes Sleep time for concurrent processing
CHAR_MODE_FLAG VARCHAR2 (1) Yes Character mode flag
SETUP_STATUS VARCHAR2 (30) Yes Status of AX setup
UPGRADE_STATUS VARCHAR2 (255)
Status of balance calculation upgrade
SETUP_COMPLETION_STATUS VARCHAR2 (30)
Actual Status of AX setup
SETUP_AUTO_RELOAD VARCHAR2 (1)
Automatically reload rules
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      AX_ENABLED
,      COMMIT_BATCH_SIZE
,      BAL_COMMIT_BATCH_SIZE
,      SLEEP_TIME
,      CHAR_MODE_FLAG
,      SETUP_STATUS
,      UPGRADE_STATUS
,      SETUP_COMPLETION_STATUS
,      SETUP_AUTO_RELOAD
FROM AX.AX_SETUP_GLOBAL;

Dependencies

[top of page]

AX.AX_SETUP_GLOBAL does not reference any database object

AX.AX_SETUP_GLOBAL is referenced by following:

SchemaAPPS
SynonymAX_SETUP_GLOBAL