For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Update: Just in case anyone has this question in the future.
I did some experimentation and the CEO record needs to have a null value in its parent key field in the
original data table before the scripts are run to build and populate the parent-child relationship table.