My Oracle Support Banner

Unable to Schedule agile9_utils.agile9_weekly_analyze Under DBA_JOBS in Agile PLM After 19c Upgrade (Doc ID 2891774.1)

Last updated on AUGUST 24, 2022

Applies to:

Oracle Agile PLM Framework - Version 9.3.6.0 and later
Information in this document applies to any platform.

Symptoms

Actual Behavior

User is able to see 'agile9_UTILS.agile9_weekly_analyze' package/procedure created in Agile Product Lifecycle Management (PLM) database schema, but unable to find the scheduled job to run this weekly under DBA_JOBS table after 19c upgrade.

Expected Behavior

User should be able to run 'agile9_UTILS.agile9_weekly_analyze' package/procedure weekly after 19c upgrade without any issue.

Steps

The agile9_UTILS.agile9_weekly_analyze job can be verified with the below steps.

  1. Log into SQLPlus
  2. Execute below query
  3. Do not see any jobs created in this table which uses agile9_UTILS.agile9_weekly_analyze.

Changes

 Agile database upgrade from 12c to 19c

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.