Search Results get_score

Overview

AR_CMGT_SCORING_ENGINE is a PL/SQL package in the Oracle E-Business Suite Accounts Receivable module that implements the credit management scoring engine. Its business purpose is to evaluate a credit case folder against a defined score model and to produce a numeric credit score, along with any error or result messages. The package operates within the Oracle Credit Management (OCM) framework, where customer creditworthiness is assessed using configurable score models, data points, and weighted scoring rules. By encapsulating the scoring computation in a single API, the package provides a consistent, reusable mechanism that forms, concurrent programs, and other application modules can call to obtain credit scores. The header comment (ARCMGSES.pls 120.1, dated 2004) indicates the object has been part of the AR credit management codebase across multiple releases and remains documented in ETRM 12.2.2, confirming its relevance in both 12.1.1 and 12.2.2 environments.

Key Procedures and Functions

The ETRM metadata documents three callable entry points, of which two distinct names are exposed: GENERATE_SCORE (in two overloaded forms) and GET_SCORE.

• GENERATE_SCORE (first overload): Accepts a case folder identifier and returns the computed score, an error message, and a result output. This overload allows the scoring engine to infer the applicable score model for the supplied case folder.
• GENERATE_SCORE (second overload): Accepts both a case folder identifier and an explicit score model identifier, returning the score, error message, and result output. This overload permits callers to force scoring against a specific model rather than relying on default model resolution.
• GET_SCORE (function): Returns a NUMBER representing the score for a single data point. Its documented parameters are a score model identifier, a data point identifier, a case folder identifier, and an optional data point value. This function is the object most directly associated with the user's search term "get_score" and is typically used to evaluate an individual scoring criterion rather than the aggregate case score.

All output parameters use the NOCOPY hint, indicating the package was written to avoid unnecessary copying of OUT values for performance.

Tables Accessed

Although the package source excerpt does not list SQL statements, ETRM records the following tables referenced through APPS synonyms:

• AR_CMGT_CASE_FOLDERS — the credit case folder header that identifies the customer and scoring context.
• AR_CMGT_CF_DTLS and AR_CMGT_CF_DNB_DTLS — case folder detail and Dun & Bradstreet detail tables supplying the data points evaluated during scoring.
• AR_CMGT_SCORES and AR_CMGT_SCORE_DTLS — the score header and detail tables where computed scores and per-data-point results are stored.
• AR_CMGT_SCORE_WEIGHTS — the score model weights used to combine individual data point scores into an aggregate result.

Together these tables provide the model definition, input data, and persistence targets for the scoring process.

Usage Notes

AR_CMGT_SCORING_ENGINE is an internal credit management API (ETRM classification OTHER, owner APPS). It is referenced by two other packages, confirming it is called programmatically rather than directly by end users. Typical invocation paths include Oracle Credit Management forms that submit a case folder for scoring, concurrent programs or workflows that batch-score case folders, and custom PL/SQL that needs an individual data point score via GET_SCORE. Because GENERATE_SCORE writes results to AR_CMGT_SCORES and AR_CMGT_SCORE_DTLS, callers should expect the package to commit or manage persistence as part of the scoring transaction. Error handling is returned through the p_error_msg and p_resultout OUT parameters rather than propagated exceptions, so callers must inspect these values after each invocation. In 12.1.1 and 12.2.2, the package signature is unchanged; standard EBS coding conventions (APPS schema, FND-style message handling) apply.