Search Results sync_all_index

Overview

The APPS.CS_SR_ADDR_CP_SYNC_INDEX_PKG package body is a thin wrapper within the Oracle EBS Service (CS) module that manages index synchronization for the service request address tables. Its sole purpose is to expose a callable interface for synchronizing the Oracle Text / interMedia indexes associated with the service request address schema. In the Oracle EBS 12.1.1 and 12.2.2 architectures, service request addresses are stored in the CS_SR (Service Request) schema objects, and full-text or functional indexes on those address records must be refreshed whenever the underlying data structures change — for example after bulk address updates, patches, or structural DDL.

The package carries a source header dated 2003/12/10 (version 115.0), indicating it is a legacy, stable component that has survived largely unchanged into the R12 release family. Its classification in ETRM is "OTHER," meaning it is not an exposed public API but an internal utility called by other service modules or administrative scripts. The CP in its name denotes "concurrent program," signalling that it is designed to be invoked from an Oracle EBS concurrent program or from a request-set driven batch job rather than from an interactive form.

Key Procedures and Functions

• SYNC_ALL_INDEX — The single documented procedure in this package. It accepts an error buffer, a return code, and a mode parameter, and delegates the actual work to CS_SR_ADDR_SYNC_INDEX_PKG.SYNC_ALL_INDEX. The wrapper exists so that the underlying sync routine can be driven from a concurrent program interface (which requires the ERRBUF/RETCODE signature) without altering the core package. The mode parameter selects the optimization strategy: "S" for synchronize, "OFAST" for optimize-fast, and "OFULL" for optimize-full. The return code follows the standard concurrent program convention: 0 for success, 1 for warning, and 2 for error.

Tables Accessed

The documented metadata does not list any directly referenced tables via APPS synonyms for this package body. This is consistent with its design: it is a pass-through wrapper that performs no SQL of its own. All table access — including any base address tables and the Oracle Text index objects — is performed inside the delegated procedure CS_SR_ADDR_SYNC_INDEX_PKG.SYNC_ALL_INDEX. Consumers investigating actual table dependencies should inspect that core package rather than this wrapper.

Usage Notes

This package is typically invoked through an Oracle EBS concurrent program (the "CP" designation) or from a request set, supplying the standard errbuf and retcode OUT parameters together with an appropriate bmode value. It may also be called from custom PL/SQL code or installation/upgrade scripts where a full index resynchronization is required. Because ETRM records zero other packages referencing it, the exposure surface is narrow; it is effectively an administrative entry point. When troubleshooting index synchronization in Service, verify the mode argument and confirm that CS_SR_ADDR_SYNC_INDEX_PKG exists and is valid, since a compilation failure there will surface as an error in this wrapper. Given its R12-era provenance, no changes to the signature should be expected between 12.1.1 and 12.2.2 beyond standard environment differences.