Home » Applications » Oracle Fusion Apps & E-Business Suite » PRINTED PO REPORT ERROR ORA-01722
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?
Previous Topic: Inventory to set up Calender
Next Topic: Oracle AP Query
Goto Forum:
  


Current Time: Sun Dec 04 06:51:13 CST 2016

Total time taken to generate the page: 0.07436 seconds