Heads Up! Oracle Patch Affects Billing Extensions
By John Sasali and Kimberly McDonald Baker
We know that many, many users of Oracle Project Billing use Billing Extensions to tailor their invoicing capabilities. You can learn more about the expanded functionality provided by Extensions in Oracle E-Business Suite Projects by visiting our resource library, where you will find two whitepapers and a presentation.
Therefore, we want to make sure everyone who uses Extensions knows that Oracle patch 13345785:R12.PJ_PF.B causes issues with Billing Extensions. Oracle describes this patch as PERIODIC RELEASE 6 FOR 12.1.3 ON RELEASE DATE 01-FEB-2013.
This patch for Oracle E-Business Suite Release 12.1.3 causes numerous issues if you use a billing extension that creates automatic class events and you are billing expenditures on the same invoice. If your invoice is only expenditures or only events, however, you should not have any problems.
Error messages vary but you will find the following in the log.
ORACLE error during DRAFT INVOICE GENERATION (cursor=31 code=-1458: ORA-01458: invalid length inside variable character string
ORACLE error during DRAFT INVOICE GENERATION (cursor=32 code=-1722: ORA-01722: invalid number)
Oracle has this listed as as bug 16313327.