Enable Oracle Content Curation Service

You can automatically get recall notices ingested into your pod that have been published by the U.S. Food and Drug Administration (FDA) by subscribing to the Oracle content curation service.

To enable the Oracle Content Curation Service, do the following:

1. Identify or create a MS Outlook client email address or Google email address to receive the recall notices from the Oracle Content Curation Service. If it’s necessary to create the client email, you will need to work with your IT team to get this email account configured. Based on the FDA recall data research. the email client is estimated to receive around 8 emails a day.
2. Only if you are using the MS Outlook client email address, for the ESS job to ingest the recall email from the curation service, you must ensure that the Azure Graph API is setup, so that the email is accessible. Your IT team (Azure Administration) will have to perform this setup. Microsoft Setup Details can be found here: https://learn.microsoft.com/en-us/graph/outlook-mail-concept-overview.
3. Only if you are using the Google email address, for the ESS job to ingest the recall email from the curation service, you must ensure that the Google client is set up, so that the email is accessible. Your IT team (Google Email Client Administration) will have to perform the following setups to get the Client ID, Client Secret, and Refresh token that are required to be configured during email registration:
   1. Create Authorization Credentials
      • Navigate to the Google Cloud Console to create authorization credentials.
   2. Create a new Google Cloud project
      • For more information about setting up a Google Cloud Project, see Google Sign-In for Websites.
   3. Configure the OAuth Consent page:
      • Once the project is created, navigate to APIs & Services > OAuth Consent page
      • Set up the consent page
   4. Provide App Information
      • Enter the App Name and User Support Email Address in the OAuth Consent page
      • Click Next
      • Select the audience as External and click Next
   5. Provide Contact Information & Agree to Terms
      • Provide the required contact information
      • Click Next
      • Agree to the Terms and Conditions
      • Click Create
   6. Add Authorized Domains
      • Navigate to the Branding section
      • Add necessary authorized domains (e.g., google.com, gmail.com)
      • Click Save
   7. Add Test Users
      • Navigate to the Audience section
      • Add Test Users
   8. Enable Gmail API
      • Navigate to APIs & Services > "Enabled APIs & services"
      • Click + ENABLE APIS AND SERVICES
      • Search for Gmail API and enable it
   9. Add Gmail API Scopes
      • Return to APIs & Services > "OAuth Consent Screen" -> "Data Access
      • Click ADD OR REMOVE SCOPES
      • Search for Gmail APISelect the required scopes (for example, Read Emails) or select all
      • Click Update to add the scopes to the project
      • Click Save
   10. Create OAuth Client ID
       • Navigate to APIs & Services > Credentials
       • Click + CREATE CREDENTIALS
       • Select OAuth Client ID
       • Choose Web application as the Application Type
       • Provide a name for the Web Client
       • Enter https://developers.google.com/oauthplayground as the Authorized Redirect URL
       • Click Create
       • A popup will display the Client ID and Client Secret. Note down these details.
   11. Navigate to OAuth Playground:
       • Navigate to Google OAuth 2.0 Playground
       • Authorize Gmail API in Playground. Under Select & authorize APIs, enter https://mail.google.com
   12. Configure OAuth Playground with Your Credentials:
       • Click the gear icon in the top right corner
       • Check the box Use your own OAuth credentials
       • Enter the "OAuth Client ID" and "OAuth Client Secret" obtained in Step 10
       • Click Authorize APIs
       • Give your consent using your Google Account
   13. Exchange Authorization Code for Tokens
       • The playground will generate an Authorization Code
       • Click Exchange authorization code for tokens to generate a Refresh Token and Access Token
4. Complete the registration to receive email communication about recalls from the Oracle Content Curation Service and to get these recall notices automatically ingested into your recall management application. Do the following:
   1. In the Setup and Maintenance work area, go to the following:
      • Offering: Manufacturing and Supply Chain Materials Management
      • Functional Area: Product Recall Management
        Note: Click Change Feature Opt-in, and enable the Opt In Task: Capture Recall Notices from the U.S. Food and Drug Administration Curated and Communicated by Oracle. Navigate back to the Product Recall Management functional area.
      • Task: Manage Registration to Receive Recall Alerts
   2. Accept the third-party service terms of use.
   3. Enter the Client ID, Tenant ID, Client Secret that you receive from your IT team. The MS client /Google client details are used to retrieve the emails, parse the content, and import the recall notices into the Oracle Cloud application.
   4. Enter the MS Outlook email address/ Google email address to which the recall alerts will be sent.
   5. Click Validate and Save.
5. Schedule the Ingest Oracle Curated Recall Notices job by navigating to Tools > Scheduled Processes.

   This job fetches the email communication sent by the Oracle content curation service and received in the email address registered in the Manage Registration to Receive Recall Alerts task. Subsequently the email content is parsed to ingest the recall notices.