My Oracle Support Banner

Projects G-Invoicing ECC Data Load - FULL_LOAD shows 400 Bad Request: Error When Run for Multiple Agencies (Doc ID 2938486.1)

Last updated on APRIL 17, 2024

Applies to:

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

Symptoms

After submittng Projects G-Invoicing ECC Data Load for a FULL_LOAD for an agency and then submitting the same program for another agency the second agency program fails with the error.

The program log file shows:

'Another job is already pending or running for this dataset IGT_ORDER. These jobs ids are 46270',"errorKey":null,"stackTraceStr":null,"status":400,"detail":

In the G-Invoicing dashboard the Orders tab contains error java information with the following error:

400 Bad Request: ("title":"Can't query the collection IGT_ORDER now as it is being constructed."

Steps to Reproduce
----------------------

  1. Log into a Projects responsibility
  2. Navigate to Other > Requests > Run
  3. Submit 'Projects G-Invoicing ECC Data Load'
  4. Navigate to the G-Invoicing Dashboard
  5. Click on Orders tab.

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.