Home » Applications » Oracle Fusion Apps & E-Business Suite » Query (F11) Using A Specified Voucher Number On Invoice Workbench Fails With ORA-1036 Error (11.5.10.2)
Query (F11) Using A Specified Voucher Number On Invoice Workbench Fails With ORA-1036 Error [message #356457] Thu, 30 October 2008 15:00
ravitalasu
Messages: 1
Registered: October 2008
Location: India
Junior Member

Dear Sir,

While querying(with F11,Ctrl+F11) invoices using voucher number on Invoice Workbench the following error occurs.

ORA-1036 illegal variable name/number error. FRM-40505: ORACLE error:unable to perform query

I have seen in metalink regarding above error. They have mentioned like we have to install patch to get resolve above error while getting updated with new version of APXINWKB.fmb.

But we are having eight Organizations in our business. We are facing above error in only two Organizations in our business. We are not getting any error while querying invoices using voucher number on Invoice workbench in remaining six organizations. If there is any problem with version of APXINWKB.fmb or any profile options. We have to face same error with all organizations in our business. And also we are not getting error while querying with other fields on Invoice Workbench in those two organizations.

So, please help me to resolve this issue and let me know if you need any other information regarding this issue. I am very thankful to you. Smile

Thanks and Regards,
Ravi... (ravi.t.oracle@gmail.com)
Previous Topic: Summary Templates
Next Topic: One Fast Formula for All Elements, returning value for 25 Elements
Goto Forum:
  


Current Time: Sun Jun 30 10:46:30 CDT 2024