ANNOUNCEMENT: community.oracle.com is currently Read only due to planned upgrade until 29-Sep-2020 9:30 AM Pacific Time. Any changes made during Read only mode will be lost and will need to be re-entered when the application is back read/write.
My mistake. Apparently i had one column missing and it was throwing off the insert. i found this out by changing the INSERT to an INSERT SCRIPT and then looked at the details of the script. once i added the missing column (state), it put a NULL where there was a blank, so all is good. my apologies.