WIPJDLDB load all details ORA-01858 Updating WIP Job (Doc ID 3065306.1)

Last updated on MARCH 02, 2025

Applies to:

Symptoms

 When updating a job that was created with scheduled start date in 2023, it works fine, but scheduled start dates in 2024 it fails with "WIPJDLDB load all details ORA-01858: a non-numeric character was found where a numeric was expected". The call being made is apps.wip_massload_pub.massloadjobs.

Error shown:

 to_date() calls on a date column, which appears to be the one line that is throwing the ORA error.

Line 1613-1616 of WIP_JOB_DETAILS package body:

  wip_logger.log('Op Seq '||wo_rec.operation_seq_num||' FUSD '||to_date(wo_rec.first_unit_start_date,WIP_CONSTANTS.DATETIME_FMT)||
  ' FUCD '||to_date(wo_rec.first_unit_completion_date,WIP_CONSTANTS.DATETIME_FMT) ||
  ' LUSD '||to_date(wo_rec.last_unit_start_date,WIP_CONSTANTS.DATETIME_FMT) ||
  ' LUCD '||to_date(wo_rec.last_unit_completion_date,WIP_CONSTANTS.DATETIME_FMT) ,l_dummy2);

 

Cause

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