My Oracle Support Banner

OFS BD 8.0.7 | OFSBD_8.0.7.0.129_30555840 - PK MISSING DOCUMENT_ID (Doc ID 2781907.1)

Last updated on MAY 12, 2023

Applies to:

Oracle Financial Services Know Your Customer - Version 8.0.0 and later
Information in this document applies to any platform.

Goal

As part of the patch, we know that “Bug 30555840 - OFS BD 8.0.7.0.129: KYC DI BATCH FAILED AT TASK 9 POPULATE CUST_ID_DOC_PRCSNG” is included here to solve the issue regarding CUST_ID_DOC_PRCSNG with missing DOCUMENT_ID column.

After the installation of the patch, we check that table and indeed the DOCUMENT_ID column was added on the table, although we saw that DOCUMENT_ID is still missing from the PK_1196.

Shouldn’t DOCUMENT_ID have been added to the primary key of CUST_ID_DOC_PRCSNG table (as the CUST_ID_DOC has in its PK)?
The earlier reported issue was that the DOCUMENT_ID was missing on the CUST_ID_DOC_PRCSNG table as well on its primary key, causing primary key violations.

 

Solution

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
Goal
Solution
References


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