Error When Selecting Project Number When Using Custom WebADI To Enter Expenditures (Doc ID 1635616.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Expenditure Processing

When attempting to select a Project for a WEB ADI batch the following error occurs.

ERROR
-----------------------
WEBADI_ERROR__FRENCH_AND_ENGLISH_IMGREG.docx - screenshot file of the WEB ADI screen with error:

Souce de transaction: IMG Misc Uncosted
Nom du lot: S8TRAC3492_ESS WEB

Erreur:
L'erreur suivante est survenue
Exception Name: oracle.apps.bne.exception.BneSQLException - GLB_ER_DATABASE_RETRIEVE java.sql.SQLException: 0RA-06502: PL/SQL: erreur numerique ou error sur un valuer: character to number conversion error ORA-06512: a ligne 1 Signet du fichier journal 848653

This occurs in both English and French screens and happens on the instance where patches were applied. Customer also noticed the Operating Unit SQL defined is no longer in the instance where the patches were applied.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply the following patches:
  17603319 - GDF : DIST/LINE VARIANCE HOLD ON AP INVOICES BECAUSE OF TAX DATA
  17534720 - "PO Output for Communication ends in error. This patch should fix the problem and several other bugs."
  17839156 - R12.PJ_PF.B.6
  17861729 - PJ_PF: CUMULATIVE RELEASE 1 ON TOP OF 12.1.3 DELTA6 RELEASE DATE 23-JAN-2014
  18161967 - PACKAGE PAAPIMP_PKG (PAAPIMPB.PLS) IS INVALID AFTER APPLYING THE PATCH 17861729

2. Create a WEB ADI batch
3. Select a project number and error is encountered

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot enter and complete a WEB ADI batch

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms