Error When Selecting Project Number When Using Custom WebADI To Enter Expenditures
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.
On : 12.1.3 version, Expenditure Processing
When attempting to select a Project for a WEB ADI batch the following error occurs.
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
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.
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
The issue has the following business impact:
Due to this issue, users cannot enter and complete a WEB ADI batch
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms