My Oracle Support Banner

Error: "Procedure or function 'REPLACE_REFLECTION_PROJECT' expects parameter '@pservice_id', which was not supplied." When Merging Reflection Project Using The 'Replace' Function With SQL Server Database (Doc ID 2619225.1)

Last updated on JUNE 24, 2021

Applies to:

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



INFORMATION: Process Started: <date-time>
*** ERROR ***: SQL State: 4, SQL Error Code: 201, Level: 16, Procedure: REPLACE_REFLECTION_PROJECT, Line: 0
Procedure or function 'REPLACE_REFLECTION_PROJECT' expects parameter '@pservice_id', which was not supplied.
INFORMATION: Process Ended: <date-time>


  1. Log in P6 Client (connected to SQL Server DB).
  2. Create a project reflection (Ex: sample data project EC00530).
  3. Open Project and add a new activity (the aim is to generate a modification to trigger the merging).
  4. Go back to projects page and choose "Merge Reflection into source project" from the reflection.
  5. In the preview popup, select "Replace Reflection..." as the after merging action.
  6. Launch merging.
  7. Error is displayed.


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

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