Go to the first tab in the CIS configuration screen (for configuring the .dbc file). This is where is asks for your database. Below is the list of Tables in your database. To the right is a similar pulldown that will have probably the same names as the tables in your database,
More importantly, the top line should be BLANK. Select this blank line and save the .dbc file.
Now go back and relink and update the part and it should go "Approved: Current" with the green dot.
I had this problem and it took 2 days to figure out that I mistakenly changes the setting the the name of a new database table I added. After that, only original database parts worked (I made a copy of the cadence CIS db and added a parts table for my new stuff because I didn't want to add parts to the main tables.)
Interestingly enough, if you search the documentation for the function of the pulldown I note above - THERE IS NOTHING ABOUT IT. You can find a page that describes everything on that configuration tab EXCEPT THAT PULLDOWN.
We found 1 google result where the person said its used to help use mechanical parts and get them on the BOM, but there was not detail and we did not understand the functionality of the pulldown except that it seems to act as some sort of filter.
Hope this helps future users searching for help on error ORCIS-6182 approved part not found,