Search Results sample_gen_srs

Overview

GMD_QC_LABELS_UTIL is a utility package owned by the APPS schema in Oracle E-Business Suite, classified by ETRM as a UTIL API. Its stated business purpose is to provide public definitions for generating Quality Control (QC) labels within the Oracle Process Manufacturing (OPM) quality module. The package header carries the source file name GMDULABS.pls and a version header of 120.1, dated 16-AUG-2005. The header comments identify an origin within Oracle's TVP development group in Reading, England, and preserve the copyright notice of 2000.

The package history is significant for release planning in both EBS 12.1.1 and 12.2.2. The initial entry, dated 23-JUL-2002 and attributed to H. Verding, establishes the original label generation functionality. A second revision on 17-APR-2003 by M. Gupta adapted the code for stability study processing. A third revision on 01-JUN-2005 by J. Diiorio changed the implementation for OPM Convergence, specifically replacing the parameter p_orgn_code with p_organization_id — a change that aligns QC label output with the standard organization identifier used across converged OPM and discrete manufacturing tables. Consulting material written against pre-2005 signatures may therefore reference an obsolete organization code parameter.

The package is relevant to label printing scenarios involving printers such as the "mx631 printer labels" search context, since QC sample labels are typically rendered through a concurrent request and directed to a designated label printer at the point of sample registration or collection.

Key Procedures and Functions

ETRM documents a single public program unit in this package:

• SAMPLE_GEN_SRS — A procedure implemented as an SRS (Standard Report Submission) entry point, meaning it is designed to be invoked as a concurrent program rather than called interactively from a form. Its purpose is to generate QC labels for samples. Its declared parameters follow the standard concurrent program signature, with errbuf and retcode reserved for the concurrent manager, and business inputs covering the organization, a sample number range (from-to), a delimiter, and identifiers for stability study variants and time points. The presence of variant and time point inputs reflects the 2003 stability study change; the organization input reflects the 2005 OPM Convergence change.

No other procedures or functions are documented in the released ETRM metadata, and the package is not referenced by any other package in the documented dependency set, indicating it is a terminal utility invoked directly by the concurrent manager.

Tables Accessed

The package reads and writes a defined set of OPM, HR, HZ, and inventory tables through APPS synonyms. QC sample master data is drawn from GMD_SAMPLES, with specifications resolved through GMD_SPECIFICATIONS and GMD_SPECIFICATIONS_B. Stability study filtering uses GMD_STABILITY_STUDIES, GMD_SS_VARIANTS, and GMD_SS_TIME_POINTS. Organization context is derived from HR_ALL_ORGANIZATION_UNITS_TL, HR_ORGANIZATION_INFORMATION, and MTL_PARAMETERS. Item and location data come from MTL_SYSTEM_ITEMS_B and MTL_ITEM_LOCATIONS, while customer and party details for label content are obtained from HZ_PARTIES, HZ_CUST_ACCOUNTS_ALL, and HZ_CUST_SITE_USES_ALL. GMP_RESOURCE_INSTANCES supplies resource context. Together these tables support assembly of the label header, sample identification, and destination information.

Usage Notes

SAMPLE_GEN_SRS is normally registered as an Oracle EBS concurrent program and submitted from the OPM Quality menu or by direct SRS submission. Label output is routed to a printer defined in the concurrent program definition, which is how installations targeting devices such as the mx631 label printer configure the report. Because the procedure returns errbuf and retcode, it can also be wrapped in custom PL/SQL scheduled from DBMS_SCHEDULER or called from a custom form via FND_REQUEST.SUBMIT_REQUEST rather than invoked directly. Implementers upgrading from releases prior to the 2005 OPM Convergence change must verify that any custom callers pass p_organization_id and not the discontinued p_orgn_code, and should confirm the target printer and label format are reconfigured after cloning between 12.1.1 and 12.2.2 environments.