My Oracle Support Banner

"Sequences Close To Maximum Value" Error For HR PAY_CA_RL2_PDF_SEQ_S and HR PAY_CA_RL1_PDF_SEQ_S Under EBS Concurrent Processing Analyzer Report (Doc ID 3014239.1)

Last updated on APRIL 02, 2024

Applies to:

Oracle HRMS (Canada) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

After database upgrade to 19C below error is noticed under EBS Concurrent Processing Analyzer Report


Sequences Close To Maximum Value

________________________________

SEQUENCE_OWNER  SEQUENCE_NAME               LAST_NUMBER   MAX_VALUE   PCT_MAX
HR                             PAY_CA_RL2_PDF_SEQ_S  80000002          80500001      99
HR                             PAY_CA_RL1_PDF_SEQ_S  41010001          41510000      99


Issue can be checked with below steps:

  1. Run EBS Concurrent Processing Analyzer Report.
  2. Check the html output.

Changes

 Database upgrade 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.