My Oracle Support Banner

When Accessing Timecard Approval Notification for Contingent Workers It Errors With “ORA-06502: PL/SQL: Numeric or value error: character to number conversion error” (Doc ID 2936377.1)

Last updated on OCTOBER 25, 2024

Applies to:

Oracle Time and Labor - Version 12.2.12 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.12 version, Timecard Approval

When accessing notification for Contingent Worker (CWK) timecard approval
get the following error:



STEPS TO REPRODUCE:
------------------------

  1. Login as Contingent Worker with Self-Service Time Responsibility
  2. Create a timecard and submit for approval
  3. Login as Timecard Approver and open the timecard approval notification from the Home Page under Worklist
  4. It errors with “ORA-06502: PL/SQL: Numeric or value error: character to number conversion error”

 

Changes

 Upgraded to 12.2.12

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
References


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