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

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, API Issues

ACTUAL BEHAVIOR
---------------
During sample creation(for the spec having validity rule with SO line number say 1.10 or more ..ie having shipment line more that 9), sample creation fails with message 'Cannot find a matching specification record'. Package GMD_SPEC_MATCH_GRP function FIND_CUSTOMER_SPEC fails in query (check the comment in the code-- get the line_number for the order_line_id). The same fix for validity rule is applicable here also. Please arrange for a one-off patch in this case also.

EXPECTED BEHAVIOR
-----------------------
System should create samples

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. User is calling standard API to create samples.
2. sample creation fails with message 'Cannot find a matching specification record'. Package GMD_SPEC_MATCH_GRP function FIND_CUSTOMER_SPEC fails in query


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