Results for “is_previous_synch_successful”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ASG_CONS_QPKG is the consolidated callback package body in the Oracle E-Business Suite Field Service / TeleService mobile synchronization infrastructure. Its stated purpose, per the embedded header comment, is to contain callbacks registered with Oracle Lite. In practical terms, the package supplies the server-side PL/SQL entry points that the Oracle Lite (consolidated) client invokes during synchronization of a mobile device: download initialization, upload completion, conflict detection, purge handling, and login validation. The header history dates the bulk of the logic to the 11.5.x to 12.1 transition (2002–2008), with the header revision noted as 12.1 and a last change date of 21-May-2008 (12.1 Auto Sync), so the object is present and functionally stable in both 12.1.1 and 12.2.2.

The package is classified as "OTHER" in ETRM, which reflects that it is a callback/utility package rather than a formal Open Interface or public API. It is referenced by one other package, consistent with its role as a lower-level synchronization engine invoked by a controlling sync driver.

Key Procedures and Functions

The 23 documented procedures and functions group into four functional areas:

• Session lifecycle: UPLOAD_COMPLETE, DOWNLOAD_INIT, DOWNLOAD_COMPLETE, SET_SYNCH_COMPLETED, SET_COMPLETE_REFRESH, and DELETE_ROW manage the boundaries of a synchronization session and the completion-refresh state.
• Validation and status: VALIDATE_LOGIN authenticates the synchronizing user; IS_PREVIOUS_SYNCH_SUCCESSFUL and FIND_LAST_SYNCH_DATE report prior sync outcome and timing; SET_USER_HWM_TRANID maintains the high-water-mark transaction ID for download consistency.
• Conflict detection and resolution: IS_CONFLICT_DETECTION_NEEDED, CONFLICT_PUB_ITEMS_EXIST, GET_CONF_PUB_ITEMS_LIST, PROCESS_PUBITEM_CONFLICTS, PROCESS_CONFLICTS, and GET_PK_PREDICATE implement the conflict workflow, with GET_PK_PREDICATE supplying the key predicate used to identify conflicting rows.
• Data population and maintenance: POPULATE_Q_REC_COUNT, PROCESS_COMPREF_TABLE, PROCESS_CUSTOM_PUB_ITEMS, and PROCESS_PURGE_SDQ handle record counting, comprehension processing, custom public-item upgrade, and system dirty-queue purging.

Tables Accessed

The package operates against APPS synonyms for the Mobile Server synchronization schema:

• ASG_USER — user validation, sync status, sync timestamps, and error logging.
• ASG_AUTO_SYNC_TRANIDS and ASG_COMPLETE_REFRESH — tracking auto-sync transaction IDs and complete-refresh cycles.
• ASG_CONF_INFO, ASG_PUB, ASG_PUB_ITEM — conflict information plus the published-item definitions and custom public items.
• ASG_SYSTEM_DIRTY_QUEUE and ASG_PURGE_SDQ — queue and purge processing.
• DBMS_SQL and PLITBLM — dynamic SQL execution and PL/SQL index-by-table plumbing used internally.

Usage Notes

ASG_CONS_QPKG is not intended for direct invocation by end users or custom code. It is called as a callback by the Oracle Lite consolidated synchronization mechanism, which registers these procedures so the server executes them at defined points in the sync cycle (download init, download complete, upload complete). Administrators may observe its activity indirectly through concurrent programs and mobile administration forms that manage user synchronization and conflict resolution. Customizations should avoid modifying this package; extension points lie in the published-item and conflict metadata rather than in the callback body. Because the header revision remains at 12.1, behavior is identical in 12.1.1 and 12.2.2, and any diagnostic review should begin with the ASG_USER sync-status and sync-error columns updated by VALIDATE_LOGIN and UPLOAD_COMPLETE.