How to Partition W_GL_OTHER_F Based on Date Range
(Doc ID 1291012.1)
Last updated on MARCH 08, 2017
Applies to:Business Intelligence Applications Observer - Version 22.214.171.124 [AA 1830] and later
Information in this document applies to any platform.
Customer want to range partition W_GL_OTHER_F table on acct_period_end_dt_wid
for quarter year. acct_period_end_dt_wid is number datatype, How can they partition with date range...?
As per the performance guide for 7961 says , identify a partition key of type Date and for W_GL_OTHER_F it is acct_period_end_dt_wid.
But as per customer's observation, acct_period_end_dt_wid is a number datatype. Is it possible to do a range partitioning on this partition key column. If not what is the best method to implement.
BIAPPS 7961 with Oracle db version is 126.96.36.199.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!