Publication Flag Reenables After Copy And Paste In Web Application (Doc ID 2519028.1)

Last updated on SEPTEMBER 11, 2019

Applies to:

Symptoms

ACTUAL BEHAVIOR  
---------------
When attempting to copy a project or create a project from a template, it is not taking the default flag of px_enable_publication_flag column from the PROJECT table as intended.  


EXPECTED BEHAVIOR
-----------------------
New projects should be setting the publication flag based on default value, and it always be setting to N (when default flag = Y).

STEPS
-----------------------
1.  Verify that the default flag on the px_enable_publication_flag of the PROJECT is set to Y (which is the default). As schema owner, run:

     SQL> select DATA_DEFAULT from user_tab_columns where table_name = 'PROJECT' and column_name = 'PX_ENABLE_PUBLICATION_FLAG';

2.  Login to P6 Web Access.
3.  Copy a project (shouldn't matter what the publication flag is set to)
4.  Paste to create the new project.

Changes

Cause

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