Fusion Global HR: 24B: Approvals Rules Page Error: JBO-27122: SQL error during statement preparation After Upgrade (Doc ID 3024908.1)

JBO-27122: SQL error during statement preparation. Statement: SELECT ApprovalProcessEO.ACTIVE, ApprovalProcessEO.COMPOSITE_ID, ApprovalProcessEO.CREATED_BY, ApprovalProcessEO.CREATION_DATE, ApprovalProcessEO.DESCRIPTION, ApprovalProcessEO.ENTERPRISE_ID, ApprovalProcessEO.LAST_UPDATE_DATE, ApprovalProcessEO.LAST_UPDATE_LOGIN, ApprovalProcessEO.LAST_UPDATED_BY, ApprovalProcessEO.MODULE_ID, ApprovalProcessEO.NAME AS Name, ApprovalProcessEO.OBJECT_VERSION_NUMBER, ApprovalProcessEO.PROCESS_ID, ApprovalProcessEO.RULE_FILE_NAME, ApprovalProcessEO.TASK_FILE_NAME, ApprovalProcessEO.TXN_MODULE_IDENTIFIER, (select count(error.transaction_id) from hrc_txn_error error, hrc_txn_header header where error.transaction_id = header.transaction_id and header.module_identifier = TXN_MODULE_IDENTIFIER) AS VIEW_ATTR, ApprovalCompositeEO.COMPOSITE_NAME, ApprovalCompositeEO.COMPOSITE_ID AS COMPOSITE_ID1, (select count(data.transaction_id) from hrc_txn_data data, hrc_txn_header header where data.transaction_id = header.transaction_id and data.status='PENDING' and header.module_identifier = TXN_MODULE_IDENTIFIER) AS PENDING_COUNT, ApprovalOptionsEO.APPROVAL_DISABLED, ApprovalOptionsEO.APPROVAL_OPTIONS_ID, ApprovalOptionsEO.PROCESS_ID AS PROCESS_ID1, ApprovalOptionsEO.ALERT_ENABLED, ApprovalCompositeEO.OBJECT_VERSION_NUMBER AS OBJECT_VERSION_NUMBER1, ApprovalProcessEO.BYPASS_SUPPORTED, ApprovalProcessEO.IS_TXN_FRAMEWORK_PROCESS, ApprovalProcessEO.TXN_SUB_MODULE_IDENTIFIER, ApprovalProcessEO.FAMILY, ApprovalOptionsEO.ARCHIVE_PERIOD, ApprovalProcessEO.IS_RULE_SIMULATION_SUPPORTED, ApprovalProcessEO.RULE_CONFIGURE_MODE, ApprovalOptionsEO.SEND_TO_USERS, ApprovalOptionsEO.ALERT_TEMPLATE_OBJECT_GUID, ApprovalOptionsEO.PURGE_PERIOD, ApprovalProcessEO.ASYNC_BYPASS_SUPPORTED, ApprovalOptionsEO.ASYNC_BYPASS_ENABLED, ApprovalProcessEO.IS_PARALLEL_TXN_SUPPORTED, ApprovalOptionsEO.IS_PARALLEL_TXN_ENABLED FROM HRC_ARM_PROCESS_VL ApprovalProcessEO, HRC_ARM_COMPOSITES_VL ApprovalCompositeEO, HRC_ARM_APPROVAL_OPTIONS ApprovalOptionsEO WHERE (ApprovalProcessEO.COMPOSITE_ID = ApprovalCompositeEO.COMPOSITE_ID) AND (ApprovalProcessEO.TXN_SUB_MODULE_IDENTIFIER is null) AND (ApprovalProcessEO.PROCESS_ID = ApprovalOptionsEO.PROCESS_ID) ORDER BY ApprovalProcessEO.Name