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:

Anonymous said...

buy xanax online xanax overdose canine - xanax clearance drug screen

Anonymous said...

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

Anonymous said...

buy zolpidem online side effects of zolpidem tartrate 5mg - zolpidem tartrate 6.25

Anonymous said...

diazepam and dosage diazepam high dose - diazepam online ohne rezept bestellen

Anonymous said...

order ativan ativan lorazepam dosage - best uses ativan

Anonymous said...

buy diazepam diazepam for sale no prescription usa - cheapest diazepam online no prescription

Anonymous said...

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

Anonymous said...

generic ativan generic ativan photos - buy ativan online pharmacy

Anonymous said...

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

Anonymous said...

buy diazepam mail order diazepam - buy valium online no prescription canada

Anonymous said...

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

Anonymous said...

buy valium online buy valium cheap uk - purchase valium online no prescription

Anonymous said...

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

Anonymous said...

buy valium online diazepam valium liquid - sweet valium high lyrics meaning

Anonymous said...

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

Anonymous said...

buy valium roche buy valium online no prescription uk - valium pills generic

Anonymous said...

buy soma online no prescription carisoprodol 250 mg tablets - carisoprodol classification

Anonymous said...

buy valium online valium medication pain - companies make generic valium

oakleyses said...

nike air max, gucci handbags, ugg boots, louis vuitton outlet, polo ralph lauren, christian louboutin outlet, christian louboutin uk, cheap oakley sunglasses, nike free, tory burch outlet, burberry pas cher, polo outlet, jordan shoes, sac longchamp pas cher, oakley sunglasses, replica watches, louis vuitton, longchamp outlet, oakley sunglasses, nike free run, christian louboutin shoes, ray ban sunglasses, oakley sunglasses wholesale, louis vuitton outlet, nike air max, louis vuitton, louboutin pas cher, tiffany jewelry, prada handbags, nike roshe, oakley sunglasses, air max, prada outlet, ugg boots, nike outlet, tiffany and co, ray ban sunglasses, longchamp outlet, chanel handbags, michael kors pas cher, longchamp pas cher, jordan pas cher, replica watches, polo ralph lauren outlet online, uggs on sale, longchamp outlet, kate spade outlet, christian louboutin

oakleyses said...

ray ban uk, coach purses, polo lacoste, sac vanessa bruno, nike tn, hogan outlet, michael kors, michael kors outlet online, converse pas cher, nike air max uk, kate spade, michael kors outlet, hollister pas cher, uggs outlet, coach outlet, north face, michael kors outlet, north face uk, nike air max uk, ray ban pas cher, uggs outlet, nike air force, ralph lauren uk, mulberry uk, lululemon canada, nike free uk, true religion jeans, guess pas cher, replica handbags, timberland pas cher, nike blazer pas cher, coach outlet store online, michael kors outlet online, burberry handbags, abercrombie and fitch uk, michael kors, nike air max, michael kors outlet, vans pas cher, oakley pas cher, true religion outlet, hollister uk, nike roshe run uk, sac hermes, true religion outlet, new balance, michael kors outlet online, burberry outlet, true religion outlet

oakleyses said...

canada goose, moncler outlet, canada goose outlet, toms shoes, montre pas cher, louis vuitton, moncler, canada goose, swarovski, juicy couture outlet, louis vuitton, replica watches, links of london, moncler, canada goose uk, moncler uk, hollister, wedding dresses, thomas sabo, karen millen uk, canada goose outlet, barbour uk, louis vuitton, ugg uk, ugg,ugg australia,ugg italia, moncler outlet, doudoune moncler, ugg,uggs,uggs canada, canada goose, supra shoes, coach outlet, canada goose outlet, ugg pas cher, ugg, pandora uk, louis vuitton, canada goose jackets, juicy couture outlet, moncler, marc jacobs, louis vuitton, pandora jewelry, lancel, swarovski crystal, pandora jewelry, pandora charms, barbour, moncler