My Oracle Support Banner

REQAPPRV: AME - Real Transaction Test Returns Unexpected Attribute Value When Using po_ame_setup_pvt.get_new_req_header_id In Attribute SQL (Doc ID 1619614.1)

Last updated on APRIL 03, 2025

Applies to:

Oracle Purchasing - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Observed Behaviour:
When running a Real Transaction in the AME Workbench, a different attribute value is returned from when running the SQL in a SQL Client

Expected Behaviour:
When running a Real Transaction in the AME Test Workbench, the same attribute value is returned from when running the SQL in a SQL Client

Steps:
1. Navigate to the Approvals Management Business Analyst
2. On the right hand side, under the Approval Process Setup section, enter PURCHASE_REQ for the '1. Select the transaction type'
3. Click on the link under '4. Test Workbench '
4. Click the 'Run Real Transaction Test (1)' button
5. Enter the DOCUMENT_ID value in the Transaction ID field and click 'Go'
6. Attribute value returned
7. Run attribute query in SQL client and a different value is returned.

NOTE: In the images below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.