AG Services Fails While Generating PMDA R3 Report With Attachment (Doc ID 2447626.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

The following error is occurring and visible from the Report Details screen on an R3 report.

HL7Report::GetAttachmentData - Contact your system administrator

at Relsys.Persistence.DataAccess.DataAccess.LoadDataSet(DbCommand command, DataSet dataSet, String tableName)
at Relsys.Common.Cache.ItemListDBLoader.GetItemList(String sTableName, Boolean bShowDeleted, String sProcName)
at Relsys.Common.Cache.ItemListCache.GetListFromDB(String sTableName, Boolean bShowDeleted, Boolean IsEnterpriseLevel, String sProcName)
at Relsys.Common.Cache.ItemListCache.GetData(String sTableName, Boolean bShowDeleted, Boolean IsEnterpriseLevel, String sProcName)
at Relsys.Common.Cache.CMNProfile.get_dsCMNProfile()
at Relsys.Common.Cache.CMNProfile.GetKeyValue(String key)
at Relsys.ESM.HL7.HL7Report.GetAttachmentData(Int64 caseId, String attachmentIds, String stempFolder)

ORA-06550: line 1, column 21:
PLS-00302: component 'P_GET_CMN_PROFILE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
at Oracle.DataAccess.Client.OracleException.H

-- Steps
The issue can be reproduced at will with the following steps.
1. Configure R3 destination and select an attachment type and auto-distribute.
2. Place this type of attachment in a case.
3. Generate report and wait for E2B Transmit AGService to pick up case.

Cause

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