Search Results get_process_id

Overview

FTE_BULKLOAD_PKG is an APPS-owned PL/SQL package that supports bulk loading of data into the Oracle E-Business Suite architecture. Its documented purpose centers on populating QP interface tables — the intermediate staging structures used by Oracle Advanced Pricing and related modules — by reading flat files from a server directory and writing rows into the FTE_BULKLOAD_DATA and related tables. The package header carries the CVS header identifier $Header: FTEBKLDS.pls 120.3 2005/08/24 06:33:35 pkaliyam ship $, indicating a long-stable component delivered under the FTE product family (Fuel Tax and Transportation / logistics-related functionality). Internally, the package relies on a process/load identifier concept — frequently referred to as the load_id — that correlates each bulk load request with rows created in QP interface tables. The GET_PROCESS_ID function explicitly exists to return the process id used by the qp_interface tables, which is why a search for "qp_interface" surfaces this package in ETRM documentation. The package is referenced by 13 other packages, confirming it functions as a shared utility rather than a standalone application entry point.

Key Procedures and Functions

The package exposes seven documented program units:

• GET_PROCESS_ID — Returns the process identifier (load_id) associated with the QP interface tables, establishing the batch identity under which a bulk load is executed.
• SUBMIT_DATA — Creates a new row in FTE_BULKLOAD_DATA using caller-supplied parameters, representing a new bulk-loading request to the concurrent manager. It was designed for the local-file option, where the user supplies a file name, load id, file type, and load type. The request id is returned to the caller.
• UPDATE_RID — Updates the request id associated with a bulk load record, reconciling the FTE_BULKLOAD_DATA row with the concurrent request that processes it.
• UPLOAD_FILE — Handles the physical movement of the source file, working with the upload directory configuration maintained by the package (g_upload_dirname, g_upload_dir_set).
• PROCESS_DATA — Parses and processes the staged content, mapping delimited or fixed records into the appropriate interface structures.
• LOAD_FILE — Performs the file-level load operation, coordinating reading of the file with insertion into the target tables.
• GET_UPLOAD_DIR — Returns the configured upload directory path used for file retrieval.

Tables Accessed

The package reads and writes the following database objects through APPS synonyms:

• FTE_BULKLOAD_DATA — The central control table holding bulk load requests, file metadata, load ids, and request ids. SUBMIT_DATA inserts here; UPDATE_RID modifies it.
• FTE_MILE_DOWNLOAD_FILES — Supports file-tracking for downloaded or staged mileage-related files.
• QP_PROCESS_ID_S — The sequence used to generate the process/load identifier for QP interface processing.
• DBMS_LOB, UTL_FILE, and UTL_RAW — Used for LOB handling, directory-based file I/O, and raw conversion during load operations.
• DUAL and PLITBLM — Used for single-row selection and PL/SQL table manipulation respectively.

Usage Notes

FTE_BULKLOAD_PKG is typically invoked from concurrent programs and supporting forms that let users submit bulk-load requests against a server-side file. Because it is referenced by 13 other packages, it also serves as a programmatic dependency for downstream FTE and pricing-related processing. The presence of a debug flag (g_debug_on) and configurable directory variables allows the package to be diagnosed in test environments. In Oracle EBS 12.1.1 and 12.2.2, the package should be treated as an internal, supported component — customizations should call its documented procedures rather than modifying the package body, and any bulk-load operation should ensure the upload directory is registered and accessible to the APPS schema through the appropriate database directory object.