GL_AUTOMATIC_POSTING_SETS
GL_AUTOMATIC_POSTING_SETS contains the automatic posting sets you defined in the AutoPost Criteria Set program. Each row includes the name and description of your set and its set level criteria. There is a one-to-many relationship between a row in this table and rows in the GL_AUTOMATIC_POSTING_OPTIONS table.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
GL_AUTOMATIC_POSTING_SETS_PK |
AUTOPOST_SET_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| AUTOPOST_SET_ID | NUMBER | 18 | Yes | Journal autopost set unique identifier. | ||
| AUTOPOST_SET_NAME | VARCHAR2 | 30 | Yes | User entered journal autopost set name. | ||
| SUBMIT_ALL_PRIORITIES_FLAG | VARCHAR2 | 1 | Yes | Submit all priorities defined in the set for posting flag. | ||
| ENABLED_FLAG | VARCHAR2 | 1 | Yes | Whether or not autopost set is enabled. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| DESCRIPTION | VARCHAR2 | 240 | Journal autopost set description. | |||
| NUM_OF_PRIORITY_OPTIONS | NUMBER | 2 | Number of top priorities in the set to be submitted for posting. | |||
| EFFECTIVE_DAYS_BEFORE | NUMBER | 5 | Number of days prior to the submission date. | |||
| EFFECTIVE_DAYS_AFTER | NUMBER | 5 | Days the system counts after a submission date when determining the journal entries to select for automatic posting. | |||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | AutoPost Criteria Sets (GL_AUTOMATIC_POSTING_SETS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | AutoPost Criteria Sets (GL_AUTOMATIC_POSTING_SETS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | AutoPost Criteria Sets (GL_AUTOMATIC_POSTING_SETS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | AutoPost Criteria Sets (GL_AUTOMATIC_POSTING_SETS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | AutoPost Criteria Sets (GL_AUTOMATIC_POSTING_SETS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | AutoPost Criteria Sets (GL_AUTOMATIC_POSTING_SETS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | AutoPost Criteria Sets (GL_AUTOMATIC_POSTING_SETS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | AutoPost Criteria Sets (GL_AUTOMATIC_POSTING_SETS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | AutoPost Criteria Sets (GL_AUTOMATIC_POSTING_SETS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | AutoPost Criteria Sets (GL_AUTOMATIC_POSTING_SETS) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | AutoPost Criteria Sets (GL_AUTOMATIC_POSTING_SETS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | AutoPost Criteria Sets (GL_AUTOMATIC_POSTING_SETS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | AutoPost Criteria Sets (GL_AUTOMATIC_POSTING_SETS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | AutoPost Criteria Sets (GL_AUTOMATIC_POSTING_SETS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | AutoPost Criteria Sets (GL_AUTOMATIC_POSTING_SETS) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | AutoPost Criteria Sets (GL_AUTOMATIC_POSTING_SETS) | ||
| SECURITY_FLAG | VARCHAR2 | 1 | Yes | Enable definition access set security flag. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| PROGRAM_ID | NUMBER | 18 | Identifies the concurrent program. | |||
| PROGRAM_LOGIN_ID | NUMBER | 18 | Identifies the login identifier of the concurrent program in Oracle Fusion Applications. | |||
| PROGRAM_APPLICATION_ID | NUMBER | 18 | Identifies the Oracle Fusion Application that spawned the concurrent program. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| LAST_RUN_DATE | TIMESTAMP | Identifies the execution date of the last spawned concurrent request instance of the concurrent program. | ||||
| SUBMIT_APPROVAL_AS_CREATOR | VARCHAR2 | 1 | Indicates whether the user who created the batch is the submitter for approval. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| gl_automatic_posting_options | gl_automatic_posting_sets | AUTOPOST_SET_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_AUTOMATIC_POSTING_SETS_U1 | Unique | Default | AUTOPOST_SET_ID |
| GL_AUTOMATIC_POSTING_SETS_U2 | Unique | Default | AUTOPOST_SET_NAME |