Procurement - EBS (MOSC)

MOSC Banner

The transaction ID specified returned an incorrect number of rows

edited Jul 6, 2016 5:00AM in Procurement - EBS (MOSC) 1 commentAnswered

Hello,

I set up AME for quote analysis approval but when i do a test from the test workbench with transaction ID being the RFQ number i get this error" The transaction ID specified returned an incorrect number of rows for QUOTE ANALYSIS ATTRIBUTE CIV. Ensure you specify a valid transaction ID and the dynamic query of the attribute returns correct number of rows."

below is the script attached to the attribute

select hr.organization_id from hr_all_organization_units hr

where hr.organization_id  in (select po.org_id from po_headers_all po where po.type_lookup_code = 'RFQ' AND po.segment1=:transactionId

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center