My Oracle Support Banner

Running invoice As Web Service Fnished in Error "ORA-01841: (full) year must be between -4713 and +9999, and not be 0" (Doc ID 2637233.1)

Last updated on FEBRUARY 09, 2020

Applies to:

Oracle Fusion Project Billing Cloud Service - Version 11.13.19.10.0 and later
Information in this document applies to any platform.

Symptoms

Run Generate invoice As Web Service

Use WSDL Link:
https://<Pod Name>.fa.us2.oraclecloud.com:443//ess/esswebservice?WSDL

Run the payload using submit ESS process and I am getting process_ID

In Fusion application Generate invoice process (Request ID = 53639) status is error.

ERROR
ORA-01841: (full) year must be between -4713 and +9999, and not be 0

STEPS
The issue can be reproduced at will with the following steps:
Run Generate invoice As Web Service
https://edwz-dev2.fa.us2.oraclecloud.com:443//ess/esswebservice?WSDL

1. Use below payload for submitting the request
xmlns:sch="http://xmlns.oracle.com/scheduler"
 xmlns:typ="http://xmlns.oracle.com/scheduler/types">
 
  
  Running invoice As Web Service
  
  InvoiceGenerationJob
  
oracle/apps/ess/projects/billing/workarea/invoice
  JOB_DEFINITION
  
  FscmEss
  2019-12-25T08:50:40
  
  
  STRING
  submit.argument1
  IS
  

  STRING
  submit.argument13
  18688
  

  STRING
  submit.argument15
  2019-12-15
  

  STRING
  submit.argument20
  2019-12-15
  

  STRING
  submit.argument21
  N
  

  STRING
  submit.argument22
  DETAIL
  

  STRING
  submit.argument23
  Yes
  
  
  
  

2. Response
xmlns:wsa="http://www.w3.org/2005/08/addressing">
  
  submitRequest
  urn:uuid:b0f01c1d-e386-4155-b3a8-f28d2b30d963
  uuid:3cd67f1b-9bda-4cca-8a76-191e5f54d5da
  
  
  
  53639
 
  

In Response I am able to get process_ID but in application I am getting status as error as above



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