By John Sasali and Kimberly McDonald Baker

We know that many users of Oracle Project Billing use Billing Extensions to tailor their invoicing capabilities. You can learn more about the expanded functionality of 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 ensure 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 are billing expenditures on the same invoice. However, if your invoice is only for expenditures or events, 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
)
PAI_ORACLE_ERROR

or

ORACLE error during DRAFT INVOICE GENERATION (cursor=32 code=-1722: ORA-01722: invalid number)

Oracle has this listed as bug 16313327.