Search Results calculate_duplicate_time_frame

Overview

CS_SR_DUP_CHK_PVT is a private PL/SQL package within the Oracle EBS Service (CS) module, owned by the APPS schema. It centralizes the logic that detects and manages duplicate Service Requests (SRs) prior to or during their creation and update. Duplicate detection in Oracle Service is critical because customers and agents frequently raise multiple incidents for the same underlying problem, asset, serial number, or contact. The package evaluates a prospective SR against an established set of duplicate-check criteria configured by the administrator, and returns both a duplicate flag and descriptive reasons that can be surfaced to the user. It is classified as a "PVT" (private) API, meaning it is intended for internal consumption by the Service Request validation layer rather than as a public integration interface, though it is referenced by two other packages in the EBS codebase.

Key Procedures and Functions

• DUPLICATE_CHECK — The primary entry point. It accepts a broad set of SR attributes (incident, incident type, customer product, serial numbers, customer, inventory item, extended attributes, and address) and returns a duplicate indicator along with a collection of duplicate records and reason descriptions.
• CHECK_EA_DUPLICATE_SETUP — Verifies whether extended-attribute-based duplicate checking has been configured for the relevant SR type.
• PERFORM_EA_DUPLICATE — Executes the actual comparison against configured extended attributes to identify matches.
• PERFORM_DUP_ON_SR_FIELD — Performs duplicate matching against standard SR fields based on setup.
• CHECK_SR_INSTANCE_DUP, CHECK_SR_SERIALNUM_DUP, CHECK_SR_CUSTPROD_DUP, CHECK_SR_CUSTPRODSERIAL_DUP — Specialized checks that compare a candidate SR against existing SRs by installed instance, serial number, customer product, and the combined customer-product-and-serial key respectively.
• CONSTRUCT_UNIQUE_LIST_DUP_SR — Builds the deduplicated result collection of matching SRs.
• CHECK_DUP_SR_LINK — Determines whether a duplicate SR link already exists to avoid redundant linking.
• CHECK_IF_ALREADY_IN_LIST — Prevents duplicate entries within the result collection itself.
• GET_DUP_MESSAGE — Retrieves the user-facing message describing why an SR was flagged as a duplicate.
• CALCULATE_DUPLICATE_TIME_FRAME — Computes the time window applied to duplicate comparisons, restricting the search to SRs created within a configured recent interval. This is the procedure most commonly sought when tuning duplicate-check behavior.

Tables Accessed

The package reads from CS_INCIDENTS_ALL_B for SR header data and CS_INCIDENT_LINKS for existing duplicate relationships. It consults CSI_ITEM_INSTANCES for installed-base asset details and CUG_SR_TYPE_DUP_CHK_INFO for the administrator-defined duplicate-check configuration keyed by SR type. Address validation draws on HZ_LOCATIONS and HZ_PARTY_SITES, while MTL_UOM_CONVERSIONS supports unit-of-measure normalization. PLITBLM is used for PL/SQL table messaging.

Usage Notes

CS_SR_DUP_CHK_PVT is invoked by the Service Request forms and related validation packages during SR entry, and by the two dependent packages that orchestrate duplicate detection. It relies on AUTHID CURRENT_USER and standard FND_API conventions. Administrators tune behavior through CUG_SR_TYPE_DUP_CHK_INFO, including the timeframe governed by CALCULATE_DUPLICATE_TIME_FRAME. Because it is a private API, customizations should avoid calling it directly and instead extend the supported configuration.