My Oracle Support Banner

PLS-00201: identifier 'PKG_PDP_E2B' must be declared (Doc ID 2580200.1)

Last updated on AUGUST 29, 2019

Applies to:

Oracle Argus Safety - Version 8.2 and later
Information in this document applies to any platform.

Symptoms


Created a case with adverse event and scheduled an e2b report.

Upon clicking the draft link to generate the report, below error is generated:

"Error No:402000608 Description select cp.create_repository from cfg_profile cp, cfg_receiver cr where agency_id=:P_AGENCY_ID_2 and upper(trim(cr.message_profile))=upper(trim(cp.profile)); See report details."



Message found in the error log:

"Argus Safety.COM :- Oracle error 1 occurred.ORA-06550: line 1, column 7: PLS-00201: identifier 'PKG_PDP_E2B' must be declared ORA-06550: line 1, column 7:PL/SQL: Statement ignoredSQL: begin PKG_PDP_E2B.PDP_CALLING_E2B_GENERIC(:PG_MODULE_ID, :PG_IS_RUN_NOW, :PG_PI_BINDED_VARIABLES, :PG_PI_RECEIVING_AGENCY,:PG_PI_SENDING_AGENCY, :PG_PI_CREATE_REPOSITORY, :PG_CASE_ID, :PG_REG_REPORT_ID,:PG_AGENCY_ID, :PG_PI_MSG_LENGTH, :PG_PI_DRAFT, :PG_PI_USER_ID, :PGO_REPORT_ID, :PGO_RETURN_CODE, :PGO_ERROR_MESSAGE, :PGO_COMP_ROWS ,:PG_PI_VIEW_DIFFERENCE);end;PL/SQL Call Stack: SQL673 PKG_CONSOLE_COMMON.P_ERROR_LOG1 __anonymous_block"



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


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