PRINTED PO REPORT ERROR ORA-01722 [message #223091] |
Wed, 07 March 2007 09:04 |
mtyndall
Messages: 1 Registered: March 2007 Location: ORLANDO
|
Junior Member |
|
|
Hello and thanks in advance,
Here is my error:
MSG-00001: Calling the archiving routine with parameters RELEASE, BLANKET, 17805
ORA-01722: invalid number
==> pk2_value = :pol_po_item_id AND
I get 2 exact hits on metalink but they don't seem to help me out.
If I run this query:
Select pk2_value
from FND_ATTACHED_DOCUMENTS
where entity_name = 'MTL_SYSTEM_ITEMS'
and pk2_value = 123
I get
Error starting at line 1 in command:
Select pk2_value
from FND_ATTACHED_DOCUMENTS
where entity_name = 'MTL_SYSTEM_ITEMS'
and pk2_value < 0
Error report:
SQL Error: ORA-01722: invalid number
01722. 00000 - "invalid number"
*Cause:
*Action:
Isn't the above error always going to occur when we compare a numeric field (:pol_po_item_id) to a VARCHAR2 field "pk2_value"?
Is there a patch maybe for the table?
ANY IDEAS?
|
|
|