Installing Satellite 5.5 with external Oracle database encounters error 'ORA-02291: integrity constraint (RHNSAT.RHN_PACKAGESYNCBL_PNID_FK) violated - parent key not found'

Issue

• The following error was encountered while re-populating a Satellite 5.5 external database:

./install.pl --answer-file=/root/sat-inst-answers.txt --clear-db --skip-selinux-test --skip-ssl-cert-generation --skip-ssl-vhost-setup --external-db

** Database: Services stopped.  Clearing DB.

*** Progress: #################################

Could not populate database.

insert into rhnPackageSyncBlacklist (package_name_id)
*
ERROR at line 1:

ORA-02291: integrity constraint (RHNSAT.RHN_PACKAGESYNCBL_PNID_FK) violated - parent key not found

• Satellite 5.5 installation with External database fails with following error:

Database service name (SID)? rhnsat
** Database: Testing database connection.
** Database: Populating database.
:
:
*** Progress: #################################
Could not populate database.

In /var/log/rhn/populate_db.log:

insert into rhnPackageSyncBlacklist (package_name_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (RHNSAT.RHN_PACKAGESYNCBL_PNID_FK) violated - parent key not found

OR

Database service name (SID)? rhnsat
** Database: Testing database connection.
** Database: Populating database.
:
:
*** Progress: #################################
Could not populate database.

In /var/log/rhn/populate_db.log:
insert into rhnPackageSyncBlacklist (package_name_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (RHNSUSER.RHN_PACKAGESYNCBL_PNID_FK) violated - parent key not found