My Oracle Support Banner

Sample Creation Using GMD_SAMPLES_PUB Fails With Message 'Cannot Find A Matching Specification Record'. (Doc ID 2437221.1)

Last updated on SEPTEMBER 20, 2018

Applies to:

Oracle Process Manufacturing Product Development - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, API Issues

When creating Item sample (for sales Orders and internal orders) using the API GMD_SAMPLES_PUB.Create_Samples api error appears.
The Error appears in both English and French Canadian depending on the setting of profile option: ICX_NUMERIC_CHARACTERS.

ERROR
-----------------------
GMD_INVALID_ORDER_LINE (LINE=LINE_ID) <Cannot find a matching specification record.>"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Run GMD_SAMPLES_PUB.Create_Samples and p_find_matching_spec is set to ‘Y’.
2. Sample creation fails with message 'GMD_INVALID_ORDER_LINE (LINE=LINE_ID) <Cannot find a matching specification record.>

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.