LSH: OC Global Meta-data Adapter

Hi Everyone!!

Integrating Oracle Life Sciences (LSH) with Oracle Clinical needs Adapter setup.
As a part of it, OC Global meta-data job has be run in LSH. It failed due to the fact that OC security restricting the privileges on GET_MAX_JN_SN for LSH account.

--excerpt of job log--

Log for the job: Standard Execution Setup

Parameters:

Remote Location: ..............OCPROD/OCPROD

Submission Type: ..............Immediate.

Library Domain Name: ..........DATA STANDARDS

Submission Mode: ..............Full.

Refresh Type: .................Full

Blind Break: ..................No.

Data Currency: ................Current Immediate Source.

Execution Priority: ...........Normal.

Execution Status : Initializing :: Job Status: Pending :: 07-03-2011 20:43:19

Execution Status : SETFAILURE :: Job Status: Failure :: 07-03-2011 20:43:19

Error Code: -6502:: Error Description: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 1795

ORA-20200: *** ERROR: Cdr_Exe_Runtime.recordLSCurrency: ORA-20200: *** ERROR: getLSCurrency:Calling LSCurrencyFunction - ORA-06550: line 1, column 44:

PLS-00201: identifier 'GET_MAX_JN_SN.GET_MAX_JN_SN@OCPROD_1301_1194390001_1' must be declared

ORA-06550: line 1, column 34:

PL/SQL: Statement ignored::9:

Execution Status : SETFAILURE :: Job Status: Failure :: 03-03-2011 20:43:19

-- end of excerpt of log--

Solution is to run the below grants in Oracle Clinical.

grant execute on rxc.GET_MAX_JN_SN to OPS$LSH”

This would help if someone is facing OC Adapter setup with LSH.