Thursday, June 4, 2009

ODX-0251: Unable to find stored variable "SQL_115_AX"

I had faced the below issue ,While running the Payables invoice data Diagnostic test in R12. For that issue we had raised a Service request with Oracle. But no further progress from Oracle Support.
Version Info:

Release = 12.0.4
Patch OD for R12 RUP3 [12.0.3] (6154018) is installed
Patch Oracle Diagnostics Tools, R12.IZU.A.DELTA.4 (6497339) is installed

Issue:
ODX-0060: SQL has not been executed as table or view does not exist (ORA-00942 returned)Error executing element "sql" with the name "SQL_115_AX"Error in the sql statement:
"SELECT event_id FROM AX_EVENTS WHERE application_id = 200 AND event_type like 'NON_CASH%' AND event_field1 = :1 AND NVL(org_id, -99)= :2 UNION SELECT event_id FROM AX_EVENTS WHERE application_id = 200 AND ( event_type like 'CASH%' OR event_type like 'FUTURE%' ) AND event_field1 IN ( SELECT check_id FROM AP_INVOICE_PAYMENTS_ALL WHERE invoice_id = :3 ) AND NVL(org_id, -99) = :4" with the bind values:"'38658', '82', '38658', '82'".
SQLERROR - ODX-0251: Unable to find stored variable "SQL_115_AX".ACTION -
If the XML file for this test was delivered by Oracle Support Services, contact the support representative for assistanceXML File Information

XML Engine Version = 3.2.1

File Name = APListXml.xml (File Version = 120.0.12000000.8, File Location = ap/diag, Date = 2008/04/24)

But Finally we find out the resolution. That issue occurred with synonym of AX_EVENTS Table.

Solution:
1. Recreate the grants & synonyms through adadmin & Complie Apps Schema.

21 comments:

  1. buy xanax online xanax overdose canine - xanax clearance drug screen

    ReplyDelete
  2. buy xanax no prescription how much xanax recreational use - xanax pills what are they used for

    ReplyDelete
  3. buy zolpidem online side effects of zolpidem tartrate 5mg - zolpidem tartrate 6.25

    ReplyDelete
  4. diazepam and dosage diazepam high dose - diazepam online ohne rezept bestellen

    ReplyDelete
  5. order ativan ativan lorazepam dosage - best uses ativan

    ReplyDelete
  6. buy diazepam diazepam for sale no prescription usa - cheapest diazepam online no prescription

    ReplyDelete
  7. xanax 0.5mg zoloft drug interactions with xanax - what is xanax xr 2mg

    ReplyDelete
  8. generic ativan generic ativan photos - buy ativan online pharmacy

    ReplyDelete
  9. xanax alprazolam xanax recreational use side effects - can i take 2mg of xanax at once

    ReplyDelete
  10. buy diazepam mail order diazepam - buy valium online no prescription canada

    ReplyDelete
  11. buy ambien online overnight ambien side effects back pain - ambien cr 25 mg

    ReplyDelete
  12. buy valium online buy valium cheap uk - purchase valium online no prescription

    ReplyDelete
  13. buy somas buy soma/ watson brand com - drug interactions with somac

    ReplyDelete
  14. buy valium online diazepam valium liquid - sweet valium high lyrics meaning

    ReplyDelete
  15. order ambien online no prescription sleeping pill similar ambien - ambience mall gurgaon cinema hall

    ReplyDelete
  16. buy valium roche buy valium online no prescription uk - valium pills generic

    ReplyDelete
  17. buy soma online no prescription carisoprodol 250 mg tablets - carisoprodol classification

    ReplyDelete
  18. buy valium online valium medication pain - companies make generic valium

    ReplyDelete