My Oracle Support Banner

How to Determine Whether SET_REFRDEL_PROJECT_BYPASS has Been Set for a Database (Doc ID 2652941.1)

Last updated on MARCH 27, 2020

Applies to:

Primavera P6 Professional Project Management - Version 15.1.0.0 and later
Primavera P6 Enterprise Project Portfolio Management - Version 15.1.0.0 and later
Information in this document applies to any platform.

Goal

The SET_REFRDEL_PROJECT_BYPASS procedure sets the value for variable g_refrdel_project_bypass in the refrdel_bypass package for an Oracle database.  The variable is not stored in a database table.  Is there a method for verifying whether SET_REFRDEL_PROJECT_BYPASS has been enabled for a particular P6 database?

When a project is deleted, multiple tracking records are added to the REFERDEL table.  Alternatively, for Oracle databases the REFRDEL Bypass procedure can be enabled, causing only a single delete record to be stored in the REFRDEL table for a deleted project and project ID.  Note: The bypass procedure affects only delete project operations.

Steps for enabling the SET_REFRDEL_PROJECT_BYPASS procedure are available in section REFRDEL Bypass Procedure of the P6 EPPM Database Administration Guide in the product documentation for the installed P6 version (select the link for the appropriate version, highlight Administering on the left, click the PDF link under How do I administer P6 EPPM databases on-premises?).

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.