Search Results hz_credit_request_pvt




Overview
Explore in AI Chat

Overview

HZ_CREDIT_REQUEST_PVT is an Oracle E-Business Suite private PL/SQL package owned by the APPS schema. The "PVT" suffix designates it as a private package within Oracle's naming convention, indicating that it is intended for internal use by the Oracle Credit Management (OCM) subsystem rather than as a public extension API. Its principal business role is to evaluate and apply credit recommendation rules that drive automated credit decisions for customers and orders. In practice, the package encapsulates the logic that assesses whether a credit request should result in a hold, a recommendation, or an approval based on configured credit management criteria.

The package operates in the credit-to-order management flow. When a credit analyst or an automated process submits a credit request, the recommendation engine must compare the request against rules, order data, payment terms, and hold definitions before returning a recommendation. HZ_CREDIT_REQUEST_PVT provides the private implementation behind that evaluation, complementing the public HZ_CREDIT_REQUEST APIs and the Oracle Credit Management workbench.

Key Procedures and Functions

The ETRM documentation records a single documented routine for this package:

  • RULE_CREDIT_RECCO_IMPL — The core implementation routine supporting credit recommendation rule processing. It encapsulates the logic invoked when a credit recommendation must be derived for a credit request. The name ("RECCO" for recommendation, "IMPL" for implementation) indicates that a public wrapper in the HZ_CREDIT_REQUEST package family delegates the substantive work to this private routine. No parameter list is documented in the ETRM metadata; parameters should not be assumed and must be confirmed against the deployed package specification for a given instance.

No other procedures or functions are documented for this package. Any additional internal helpers are not part of the documented interface surface.

Tables Accessed

The package references the following tables through APPS synonyms, each serving a defined purpose in the credit recommendation flow:

  • WF_EVENT_T — The Oracle Workflow event table. The package raises or consumes workflow events so that credit decisions can trigger downstream notifications and business event subscriptions.
  • AR_CMGT_CF_RECOMMENDS — Stores credit recommendation records generated by the credit management rule engine; the package writes or reads recommendations here.
  • AR_CMGT_CREDIT_REQUESTS — Holds the credit request header data being evaluated, including the customer, amount, and status context.
  • OE_HOLD_DEFINITIONS — Defines order holds. The recommendation logic consults hold definitions to determine whether an order should be placed on credit hold.
  • OE_ORDER_LINES_ALL — Supplies order line detail (items, quantities, values) required to evaluate credit exposure against the request.
  • RA_TERMS_B — Payment terms. Terms influence credit worthiness and due-date calculations used in the recommendation.

Usage Notes

Because this is a private package, direct invocation from custom code is discouraged. The supported pattern is to call the public Oracle Credit Management APIs, which in turn invoke HZ_CREDIT_REQUEST_PVT.RULE_CREDIT_RECCO_IMPL. The package is typically triggered in three contexts: through the Oracle Credit Management forms and workbench when an analyst requests a recommendation; through concurrent programs that batch-process credit requests; and through workflow or business event subscriptions that respond to order or credit events.

The ETRM metadata records no dependent packages referencing this object and confirms it is referenced by no other packages, reinforcing its terminal, private position in the call stack. The package was validated and remains VALID. Signature changes between 12.1.1 and 12.2.2 are not documented in the ETRM extract, so version-specific behavior should be verified against the instance.