My Oracle Support Banner

Existing Personal Queries Not Updated Properly And Available In The SPWA (Doc ID 2531784.1)

Last updated on FEBRUARY 08, 2022

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.6.3 and later
Information in this document applies to any platform.

Symptoms

12.2.6.3

We appplied the CUM#7 patch in a test instance.
After patch application, when we try to migrate the queries from ASCP Planning Workbench to SPWA using "Migrate Personal Queries to SP Work Area" concurrent program, we see the following message in the log:
+---------------------------------------------------------------------------+
msc_apq_pkg.migrate_queries begin
query migrated already:
msc_apq_pkg.migrate_queries end
+---------------------------------------------------------------------------+

When we check the MSC_PERSONAL_QUERIES table. For all the existing , equivalent SPWA Query names are created/spawned by the patch.
However, they are not visible or available in the SPWA.

When looked closely... Following columns are null for the "_new" query names: (for few records PLAN_TYPE is 0)
PLAN_TYPE
FAVORITE_FLAG
VIEW_FORMAT

For the records, which are manually migrated before the patching has the following column values:
PLAN_TYPE = 1
FAVORITE_FLAG = 1
VIEW_FORMAT = 3

In the past, we had the same/similar problem.
DEV suggested the following updates:
1) update msc_personal_queries set plan_type=1 where adf_flag=1 and
nvl(plan_type,0)=0 and orig_query_id is not null;

2) update msc_personal_queries set favorite_flag=1 where adf_flag=1 and
favorite_flag is null and orig_query_id is not null;
commit;

We have permissions to do the updates in test instances. But when the patch promoted to PROD, we cannot perform UPDATE or DELETE statements.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.