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 7.9.6.2 [AA 1830] and later
Information in this document applies to any platform.

Goal

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 11.1.0.7.

Solution

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