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 laterInformation in this document applies to any platform.
Symptoms
On : 12.1.3 version, Purchase Order
While trying to attach a long texted formatted attachment to a PO, the following error appears:
ERROR
-----------------------
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.
STEPS
-----------------------
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
Cause
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
Symptoms |
Cause |
Solution |
References |