Search Results g_child_process_issue

Overview

OKI_LOAD_TERR_PVT is a private (PVT-classified) PL/SQL package body owned by APPS that supports the loading of territory definitions into the Oracle EBS Territory Management (OKI/OKC) data model. Its core purpose is to populate the JTF territory tables and the associated OKI_JTF_TERRITORIES structures that drive territory-based assignment of parties, organizations, and contract resources. The package provides both a full (initial) load path and an incremental (incremental/incremental-load) path, and it delegates the bulk of worker processing to a set of spawned concurrent requests. Because it is classified PVT, it is intended for internal consumption by the territories load framework rather than as a public integration API.

Key Procedures and Functions

• LOAD_JTF_TERR: The primary driver that loads JTF territory records, coordinating the reading of staged territory data and the insertion or update of the target territory tables.
• INITIAL_LOAD: Performs the full territory load, typically executed the first time a territory set is established or when a complete rebuild is required.
• INCR_LOAD: Performs an incremental territory load, reprocessing only changed or newly added territory records since the last successful run.
• WORKER: Contains the per-worker processing logic invoked by concurrent worker requests, handling a subset of the load workload in parallel.

Supporting helper routines include rlog, which writes indented log messages to the concurrent request log via FND_FILE and handles logging exceptions, and launch_worker, which submits OKI_TERR_WORKER concurrent requests using FND_REQUEST.SUBMIT_REQUEST and sets the CONC_SINGLE_THREAD profile option to 'N'. The package also declares the exception G_CHILD_PROCESS_ISSUE, raised when a spawned child process encounters a problem.

Tables Accessed

• OKI_JTF_TERRITORIES_STG: Staging table holding territory data to be processed.
• OKI_JTF_TERRITORIES: The main territory table populated by the load.
• OKI_DBI_WORKER_STATUS: Tracks the status of each parallel worker spawned by the package.
• HR_ALL_ORGANIZATION_UNITS: Source of organization/territory ownership information.
• HZ_PARTIES: Source of party records associated with territories.
• OKC_K_HEADERS_ALL_B, OKC_K_PARTY_ROLES_B, OKC_K_VERS_NUMBERS, OKC_STATUSES_B: Contract and party-role tables used to relate territories to contracts and statuses.
• DBMS_LOCK: Used for concurrency control during parallel worker execution.
• PLITBLM: Used as an index-by/associative array helper for in-memory batch processing.

Usage Notes

OKI_LOAD_TERR_PVT is not a public API and is referenced by no other packages in the documented metadata. It is typically invoked from the Oracle Territory Management setup flows or from custom concurrent programs that manage territory loading. Because the package spawns child processes through FND_REQUEST, the G_CHILD_PROCESS_ISSUE exception is the relevant diagnostic anchor when a worker fails to complete or returns an unexpected status — this maps directly to the "g_child_process_issue" search term. When troubleshooting in 12.1.1 or 12.2.2, inspect the concurrent request log emitted by rlog, confirm the CONC_SINGLE_THREAD profile value, and verify OKI_DBI_WORKER_STATUS rows to determine whether the initial or incremental load was interrupted.