Search Results iex_scoreapi_pub




Overview
Explore in AI Chat

Overview

IEX_SCOREAPI_PUB is a public PL/SQL package in the APPS schema that supplies the scoring interface for the Oracle E-Business Suite Collections (Advanced Collections / IEX) application. Its role is to expose a stable, callable API through which both Oracle-owned modules and customer extensions can retrieve score and status information associated with collections-relevant objects. In release 12.1.1 and 12.2.2 the package is documented as VALID, and its API classification is PUB, indicating that the procedures it exposes are intended for supported external invocation rather than internal-only use. The package is registered in the ETRM repository with a package specification and package body, and it is a dependency of at least one other packaged component (LNS_BUS_EVENT_SUB_PVT), reflecting its position as a shared service within the Collections technology stack.

Key Procedures and Functions

The ETRM documentation for IEX_SCOREAPI_PUB records four callable program units. Parameter lists are not enumerated in the available metadata and are therefore not restated here.

  • GETSCORE — Returns the score value determined for a given collections object or context, allowing callers to obtain scoring results without embedding the underlying scoring logic in their own code.
  • GETSTATUS — Returns status information associated with the scoring process or the object being scored, enabling callers to determine the current state of scoring activity.
  • GETSCORESTATUS — Provides a combined or status-oriented view of score processing, exposing score status outcomes through a single entry point.
  • CHECKOBJECT_COMPATIBILITY — Performs a compatibility validation check on the object supplied to the API, allowing callers to confirm that an object is eligible for scoring before requesting score or status data.

These four entry points form a compact, read-oriented API surface: validation, score retrieval, status retrieval, and combined score-status retrieval.

Tables Accessed

The documented table references for this package are IEX_DEL_STATUSES and PLITBLM, accessed through APPS synonyms. IEX_DEL_STATUSES is the Collections delinquency status reference table and supplies status-related data used by the status and score-status procedures. PLITBLM is the standard Oracle PL/SQL integer-indexed table type (a SYS-owned type) commonly used within packaged PL/SQL for passing collections of numeric values between program units; its presence in the dependency list reflects internal data-passing structures rather than a business data table. The package specification and body also reference the SYS.STANDARD package, which is a normal and expected dependency for any compiled PL/SQL unit. No additional application tables are documented as being referenced by this package.

Usage Notes

IEX_SCOREAPI_PUB is designed to be invoked as a server-side API rather than through a dedicated form. In typical deployments it is called from Collections-related concurrent programs, from other packaged business logic, and from customer-written custom code that needs to obtain score or status data for collections objects without duplicating scoring logic. Because the package is classified PUB and is listed in ETRM, its procedures are the supported integration point for this functionality, and custom code should call these entry points instead of querying the underlying Collections tables directly. Implementers should also note the inbound dependency: IEX_SCOREAPI_PUB is referenced by LNS_BUS_EVENT_SUB_PVT, so changes to the package signature can affect that component. When migrating between 12.1.1 and 12.2.2, the package remains VALID and the documented procedures and table references are consistent, so existing calls do not require modification.