This blog post outlines the process for updating the GL Storage Parameters.
Note:
If
you are using a copy of the Oracle Apps configured database then the storage
parameters should already be configured.
Create
Tablespaces
Create
the following tablespaces:
GLINTD
GLINTX
GLTEMP
Grant
unlimited quota for these tablespaces to GL and APPS and set the temporary
tablespaces to GLTEMP for the GL userid.
Update
GL Storage Parameters:
Use
the General Ledger Super User Oracle Apps responsibility:
Navigate
to:
Setup>System>Storage
Update
GL storage parameters using the 'Update Storage Parameters' form:
The
following table contains the objects and the storage parameters that should be
set when using the Oracle Apps configuration:
Object
|
Extent
|
||||
Type
|
Name
|
Tablespace
|
Initial(KB)
|
Next(KB)
|
Max
|
Table
|
GL_ALLOC_INTERIM
|
GLINTD
|
200
|
200
|
121
|
Table
|
GL_ARCHIVE_BALANCES
|
GLINTD
|
2000
|
1000
|
121
|
Table
|
GL_ARCHIVE_BATCHES
|
GLINTD
|
1000
|
1000
|
121
|
Table
|
GL_ARCHIVE_DAILY_BALANCES
|
GLINTD
|
2000
|
1000
|
121
|
Table
|
GL_ARCHIVE_HEADERS
|
GLINTD
|
1000
|
1000
|
121
|
Table
|
GL_ARCHIVE_LINES
|
GLINTD
|
2000
|
2000
|
121
|
Table
|
GL_ARCHIVE_REFERENCES
|
GLINTD
|
80
|
40
|
121
|
Table
|
GL_BUDGET_INTERIM
|
GLINTD
|
50
|
50
|
121
|
Table
|
GL_DAILY_POST_INT
|
GLINTD
|
500
|
250
|
121
|
Table
|
GL_DAILY_XLATE_INT
|
GLINTD
|
500
|
250
|
121
|
Table
|
GL_DAILY_XRATE_INT
|
GLINTD
|
500
|
250
|
121
|
Table
|
GL_ELIMINATION_INTERIM
|
GLINTD
|
1000
|
500
|
121
|
Table
|
GL_ELIM_SEGVAL_INT
|
GLINTD
|
1000
|
500
|
121
|
Table
|
GL_IEA_IMP_L
|
GLINTD
|
100
|
100
|
121
|
Table
|
GL_IEA_IMP_T
|
GLINTD
|
80
|
40
|
121
|
Table
|
GL_INTERCO_BSV_INT
|
GLINTD
|
250
|
200
|
121
|
Table
|
GL_INTERCO_LINES_INT
|
GLINTD
|
250
|
200
|
121
|
Table
|
GL_MC_CONV_INT
|
GLINTD
|
300
|
300
|
121
|
Table
|
GL_MC_OPTIONS_INT
|
GLINTD
|
100
|
100
|
121
|
Table
|
GL_MOVEMERGE_BAL
|
GLINTD
|
1000
|
500
|
121
|
Table
|
GL_MOVEMERGE_DAILY_BAL
|
GLINTD
|
1000
|
500
|
121
|
Table
|
GL_MOVEMERGE_INTERIM
|
GLINTD
|
1000
|
500
|
121
|
Table
|
GL_OASIS_FIN_METRICS
|
GLINTD
|
100
|
100
|
121
|
Table
|
GL_POSTING_INTERIM
|
GLINTD
|
500
|
250
|
121
|
Table
|
GL_SEGVAL_INHERIT_INT
|
GLINTD
|
500
|
250
|
121
|
Table
|
GL_SUMMARY_INTERIM
|
GLINTD
|
300
|
300
|
121
|
Table
|
GL_TRANSLATION_INTERIM
|
GLINTD
|
500
|
250
|
121
|
Table
|
GL_YEAR_END_ACCT_INT
|
GLINTD
|
50
|
50
|
121
|
Table
|
GL_YEAR_END_BAL_INT
|
GLINTD
|
500
|
250
|
121
|
Index
|
GL_ALLOC_INTERIM_N1
|
GLINTX
|
20
|
20
|
121
|
Index
|
GL_BUDGET_INTERIM_N1
|
GLINTX
|
10
|
10
|
121
|
Index
|
GL_BUDGET_INTERIM_N2
|
GLINTX
|
10
|
10
|
121
|
Index
|
GL_CODE_COMBINATION_INDEXES
|
GLINTX
|
64
|
64
|
999
|
Index
|
GL_DAILY_POST_INT_N1
|
GLINTX
|
80
|
40
|
121
|
Index
|
GL_DAILY_POST_INT_N2
|
GLINTX
|
20
|
10
|
121
|
Index
|
GL_DAILY_XLATE_INT_U1
|
GLINTX
|
80
|
40
|
121
|
Index
|
GL_DAILY_XRATE_INT_U1
|
GLINTX
|
80
|
40
|
121
|
Index
|
GL_ELIMINATION_INTERIM_N1
|
GLINTX
|
160
|
80
|
121
|
Index
|
GL_ELIMINATION_INTERIM_N2
|
GLINTX
|
160
|
80
|
121
|
Index
|
GL_ELIMINATION_INTERIM_N3
|
GLINTX
|
160
|
80
|
121
|
Index
|
GL_ELIMINATION_INTERIM_N4
|
GLINTX
|
160
|
80
|
121
|
Index
|
GL_ELIM_SEGVAL_INT_N1
|
GLINTX
|
160
|
80
|
121
|
Index
|
GL_INTERCO_BSV_INT_N1
|
GLINTX
|
20
|
20
|
121
|
Index
|
GL_INTERCO_BSV_INT_U1
|
GLINTX
|
200
|
100
|
121
|
Index
|
GL_INTERCO_LINES_INT_N1
|
GLINTX
|
40
|
20
|
121
|
Index
|
GL_MC_CONV_INT_U1
|
GLINTX
|
160
|
80
|
121
|
Index
|
GL_MC_OPTIONS_INT_U1
|
GLINTX
|
40
|
40
|
121
|
Index
|
GL_MC_OPTIONS_INT_U2
|
GLINTX
|
40
|
40
|
121
|
Index
|
GL_MOVEMERGE_BAL_N1
|
GLINTX
|
160
|
80
|
121
|
Index
|
GL_MOVEMERGE_BAL_N2
|
GLINTX
|
160
|
80
|
121
|
Index
|
GL_MOVEMERGE_DAILY_BAL_N1
|
GLINTX
|
160
|
80
|
121
|
Index
|
GL_MOVEMERGE_DAILY_BAL_N2
|
GLINTX
|
160
|
80
|
121
|
Index
|
GL_MOVEMERGE_INTERIM_N1
|
GLINTX
|
160
|
80
|
121
|
Index
|
GL_MOVEMERGE_INTERIM_N2
|
GLINTX
|
160
|
80
|
121
|
Index
|
GL_MOVEMERGE_INTERIM_N3
|
GLINTX
|
160
|
80
|
121
|
Index
|
GL_OASIS_FIN_METRICS_U1
|
GLINTX
|
40
|
40
|
121
|
Index
|
GL_POSTING_INTERIM_N1
|
GLINTX
|
80
|
40
|
121
|
Index
|
GL_POSTING_INTERIM_N2
|
GLINTX
|
20
|
10
|
121
|
Index
|
GL_POSTING_INTERIM_N3
|
GLINTX
|
80
|
40
|
121
|
Index
|
GL_SUMMARY_INTERIM_N1
|
GLINTX
|
500
|
500
|
121
|
Index
|
GL_TRANSLATION_INTERIM_N1
|
GLINTX
|
80
|
40
|
121
|
Index
|
GL_YEAR_END_ACCT_INT_N1
|
GLINTX
|
80
|
40
|
121
|
Index
|
GL_YEAR_END_ACCT_INT_U1
|
GLINTX
|
80
|
40
|
121
|
Index
|
GL_YEAR_END_BAL_INT_N1
|
GLINTX
|
80
|
40
|
121
|
Index
|
GL_YEAR_END_BAL_INT_N2
|
GLINTX
|
80
|
40
|
121
|
Index
|
GL_YEAR_END_BAL_INT_N3
|
GLINTX
|
80
|
40
|
121
|
