What should the status of a guide be if you want to see it in...

The status of a guide indicates the stage of its development and deployment in the OGL console. There are three possible statuses for a guide: Draft, Unpublished Revision, and Published. Draft status means that the guide is still under development and has not been published yet. Unpublished Revision status means that the guide has been published before, but has been modified and not published again. Published status means that the guide has been published and is visible to the users in the production environment. Therefore, if you want to see a guide in your production environment, it should have the Published status. You can publish a guide by using the Publish button in the Content Editor or the Full Editor. You can also unpublish a guide by using the Unpublish button in the Content Editor or the Full Editor. References:

Oracle Guided Learning Content Developer Foundations Associate Rel 1

Organising & Managing OGL Content Course

Creating OGL Content Course