Error " The transaction ID specified returned an incorrect number of rows for CURRENCY_CODE " When Testing AME Work Confirmation Transaction Type (Doc ID 1633776.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Oracle iSupplier Portal - Version 12.1.3 and later
Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version

When trying to test the Work Confirmation AME Workflow, the following error occurs:


Patch 16681076 R12.PO.B from <Note 1581227.1>  PO AME Attributes Error Out When Running Test In AME Workbench
has been applied but problem persists.

Steps
The issue can be reproduced at will with the following steps:
For a Purchase order - Buyer Work center (Complex Service)
Test-bench with seeded attribute for Work Confirmation Transaction Type transaction ID

In RCV_SHIPMENT_HEADERS table there is a record for the Work Confirmation with
SHIPMENT_HEADER_ID 123
RECEIPT_SOURCE_CODE VENDOR
VENDOR_ID 12
VENDOR_SITE_ID 12
SHIPMENT_NUM T12
ASN_TYPE WC
SHIP_TO_ORG_ID 143
WF_ITEM_TYPE WCAPPRV
WF_ITEM_KEY 1-1142


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms