My Oracle Support Banner

Error Updateing Log Test Attchment IN PO It Gives Error Ora-04045 Errors During Recompilation/revali (Doc ID 2777117.1)

Last updated on MARCH 15, 2022

Applies to:

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


On : 12.1.3 version, Purchase Order

While trying to attach a long texted formatted attachment to a PO, the following error appears: 

Error updateing log test attchment IN PO it gives error ORA-04045 errors during recompilation/revalidation of package and this issue is happing on table FND_DOCUMENTS_LONG_TEXT and trigger FND_DOCUMENTS_LT_PO_UBR and FND_DOCUMENTS_LT_PO_UAS
ORA-25006: Can not specify this colunm in UPDATE OF Claue and column name is Long_TEXT.

The issue can be reproduced at will with the following steps:
1. Login to Purchasing Respsonbility
2. Go to Purchase Order Summary
3. Open the PO 
4. Go to attachments of PO 
5. Attempt to attach a long text formatted attachment
6. Get the error 


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.