Receipt error APP-PO-14094: No records meet your search criteria [message #504530] |
Tue, 26 April 2011 04:20 |
|
Udayd
Messages: 3 Registered: April 2011 Location: India
|
Junior Member |
|
|
Hi Everyone,
I get the following error while receiving material in R12 and have an approved PO with open quantities.
APP-PO-14142: rcv_receipts_eh.event-000: ORA-0000: normal, successful completion
Cause: A SQL error has occurred in rcv_receipts_eh.event. The SQL error is ORA-0000 normal, successful completion
APP-PO-14094: No records meet your search criteria
Has anyone resolved this issue? What is the solution?
Please help - thanks in advance.
Uday
|
|
|
|
|
Re: Receipt error [message #504668 is a reply to message #504530] |
Wed, 27 April 2011 04:01 |
davholla
Messages: 116 Registered: August 2009 Location: London
|
Senior Member |
|
|
See Metalink 945443.1
EDITED by LF: Metalink notes are protected by copyright. Therefore, you are not allowed to post the whole document here. I have removed its contents and left the note number so that the OP could read it.
[Updated on: Wed, 27 April 2011 14:20] by Moderator Report message to a moderator
|
|
|
Re: Receipt error [message #505546 is a reply to message #504668] |
Tue, 03 May 2011 11:38 |
|
Udayd
Messages: 3 Registered: April 2011 Location: India
|
Junior Member |
|
|
Thank you for the solution - I was travelling and could not look into this earlier.
I am a functional guy and have to take the assistance of my DBA for running the scripts.
The procedure up to step 4 runs fine but while executing the command in step 5, it runs into some error unable to create form and TNS error though we are able to log into sql from application and database tiers. We have also verified tnsnames.ora and it is fine. Both application and database listners are up and working fine. Please let me know if I am missing on something.
Regards,
Uday
|
|
|