My Oracle Support Banner

G-Invoicing: Seller Facilitated Orders Are Failing to Send an Update to the Agreement Approver Because of Error ORA-6502: PL/SQL: Numeric or Value Error: Character to Number Conversion Error (Doc ID 2969414.1)

Last updated on SEPTEMBER 19, 2023

Applies to:

Oracle Project Billing - Version 12.2.11 and later
Information in this document applies to any platform.

Symptoms

Two Orders are failing send an update to the agreement to approver due to the following error - ORA-06502: PL/SQL: numeric or value error: character to number conversion error.

The workflow activity monitor shows the error in workflow

Failed Activity Update Agreement to Approved
Activity Type Function
Error Name -6502
Error Message ORA-06502: PL/SQL: numeric or value error: character to number conversion error
Error Stack pa_ag_wf.approve_wf_status(PAAGPPRW, SFO_14152397008890-2-2107, 529117, RUN) Wf_Engine_Util.Function_Call(pa_agreement_workflow.approve_wf_status, PAAGPPRW, SFO_14152397008890-2-2107, 529117, RUN)

This issue is experienced when creating a Seller Facilitated Order (SFO)

  1. Submit SFO for approval.
  2. Submit Intragovernmental Orders Interface Program
  3. Enterprise Command Center (ECC) G-Invoicing Dashboard shows Orders in Draft status, pending approval submission.
  4. Agreement Approver never receives requested approval
  5. Reviewing workflow activities shows the workflow in error status.

 

Changes

 

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.