How to Partition W_GL_OTHER_F Based on Date Range
Last updated on MARCH 08, 2017
Applies to:Business Intelligence Applications Observer - Version 18.104.22.168 [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 22.214.171.124.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms