My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.