T78-2016: BIOVIA Chemical/Biological Registration - Oracle12c Patch Required

A defect has been identified during execution of BIOVIA Chemical/Biological Registration when the schema is installed on Oracle 12c (12.1.0.2.0) and the application is utilizing the GEMS, application based security, either the single cardinality or multiple cardinality model. The error is observed when a security model has been selected as part of the install but records have been registered that do not have membership to a security group. Such records have a 'null' security id and an exact search for such a record returns no results.

The issue is especially apparent if undertaking an upgrade of Chemical Registration 3.2, if Oracle row-level-security was employed, up to Chemical Registration 4.2 onwards (including 2016 / 2017) when moving to the GEMS, application based security model. The upgrade protocol will fail reporting an error at the end of the protocol execution - see error message.

Resolution:
The issue was traced back to an Oracle defect #18650065 relating to the optimizer in Oracle12c - 12.1.0.2.0.

Oracle have released a patch to address this defect and it is the recommendation of BIOVIA that this patch is installed on any Oracle12c (12.1.0.2.0) database where BIOVIA Chemical/Biological Registration is to be installed and utilizing the GEMS, application based security model.
Error Mesage:
Chemical Registration3.2 upgrade to Chemical Registration4.2 onwards involving switching from row-level-security to GEMS based security.

BatchingProcessor::processBatch: Pipeline Pilot exception rethrown

BatchingComponentObject::onProcess: Pipeline Pilot exception rethrown

-> 'GEMS Writer' ('GEMS Writer'); Location: 1:1:4 - error during Data Record Processing phase

CProtocolStd::onProcess: Pipeline Pilot exception rethrown

CProtocol::onProcess: Pipeline Pilot exception rethrown

vcRunComponent::onProcess: Pipeline Pilot exception rethrown

Internally referenced component: Shortcut Component (P006 Update EMS Entity History) - error during Data Record Processing phase

vcRunComponent::processData: Pipeline Pilot exception rethrown

Internally referenced component: Shortcut Component (P006 Update EMS Entity History) - error during Data Record Processing phase

CShortcutComponent::onProcess: Pipeline Pilot exception rethrown

-> 'Shortcut Component' ('Shortcut Component'); Location: 1:1:0:266:5:0:2:44:0:2:0 - error during Data Record Processing phase

CProtocolStd::onProcess: Pipeline Pilot exception rethrown

CProtocol::onProcess: Pipeline Pilot exception rethrown

-> 'Subprotocol' ('Shortcut Component'); Location: 1:1:0:266:5:0:2:44:0:2 - Handled error during Data Record Processing phase (in 'Controller' ('Controller'); Location: ): sent record to fail port