EBS credit check

Source: Internet
Author: User

Credit Logic

This post will more focus on technical part of credit check functionality. You can check the functional part of credir check functionality here.


These are the main tables used for holding credit check functionality.

  • Oe_hold_authorizations
  • Oe_hold_definitions
  • Oe_hold_releases
  • Oe_hold_sources_all
  • Oe_credit_check_rules
  • Oe_credit_summaries
  • Oe_exposure_interface
  • Hz_customer_profiles
  • Hz_cust_profile_amts

Profile options

These Profile options specially meants for controlling credit check functionality.

  • OM: Modify seeded hold
  • OM: preserve external credit balances
  • OM: Prevent booking for line generic hold
  • OM: Schedule line on hold

System Parameter options

  • Apply credit hold on zero value
  • Order credit Hold sequence for Order Lines
  • Initiate credit check at Cancellation


Credit Checking in Oracle quoting allows the user to determine the credit worthiness of a customer while working on a quote. the user can decide if the quote shoshould be submitted for business approvals Credit verification. the profile option Aso: Enable credit check determines if credit checks can be saved med.

There are two types of credit checks available in Oracle quoting:

  • Internal-Internal credit checking is based on transaction data in the quote, and historic transaction data in Oracle order management and Oracle receivables. it pertains to quote header-level billing information. internal credit checks are saved med by the public credit check API oe_external_credit_pub.
  • External-External credit checks are retriable by an application developer and allow users to make callto non-Oracle Applications.

You shoshould be very clear on key differences between internal credit checking and the credit checking functionality in Om, which is:

  • Item category limits are not checked in the public credit check API provided for internal credit checks.
  • Credit Checking is only available at the header level in internal credit checking, while om credit checking supports both header and line level credit checks.
  • There is no holds functionality for internal credit check.

Concurrent program

1. initialize credit summaries (oexinics)

  • This program enables you to periodically rebuild a credit exposure image for all MERs or customer sites for all possible credit rule definitions.
  • When you submit the 'initialize credit summaries 'program, the changes to customer or customer site credit exposure is calculated and updated in oe_credit_summaries table.

Therefore you have to understand the frequency with which you run initialize credit summaries will be based on ones business needs.

If the requirement is to have customer's credit exposure to be close to the online credit exposure calculation, then probally you can run it frequently.

  • Take a note, this program will not delete the externally imported exposure records if profile option OM: preserve external credit balances is set to Yes

2. credit exposure import (oexceimp) & purge imported credit exposure (oexceprg)

Credit exposure Import

  • First Program ie credit exposure import program enables you to import external credit exposure details for sales orders created outsideOracle Applications into ORACLE Order Management. Those who are doing system integration can take advatange of this.
  • External exposure data is imported from interface tableOe_exposure_interfaceIntoOe_credit_summariesTable. Once import is successful, data from oe_exposure_interface is get deleted.
  • All externally imported exposure detail records will have the value 18 for the field balance_type column in 'oe _ credit_summaries '.
  • The credit exposure import program can be submitted in two different modes, update and insert.
    • Insert mode: All credit exposure amounts previusly imported will be overwritten.
    • Update mode: The credit exposure amount within 'oe _ credit_summaries table will either be added (positive amount) or subtracted (negative amount) to any previusly imported amount. if a corresponding exposure amount does not previusly exist, a new exposure amount record will be created.
  • Interface records are processed based upon the mode, which is determined by the value of the column operation_code within the exposure interface table oe_exposure_interface.

Purge imported credit exposure

  • The'Purge imported credit exposure'Program enables you to purge imported external credit exposure records from oe_credit_summaries table.

3. Credit check processor (oexaucrc)

  • Credit check processor can automatically apply or release order or order line credit holds.
  • Best use of this program when you suspect your MERs credit exposure has changed and you want to re-evaluate their sales order status.
  • You can also use credit check processor whenever you change the customer credit profile or credit check rule set up and you want these changes to immediately take affect on your booked sales orders.
  • Credit check processor "always" uses Booking Credit check rule to apply/release the holds.
  • There is limitation for applying the hold through credit check processor it currently only considers exposure of the Order lines which are in 'booked' status.
  • When using pre-calculated exposure in credit check rule, run the 'initialize credit summaries 'concurrent program every time before running the credit check processor.


You can take advantage of these reports.

  • Credit exposure report
  • Credit Limit usage report
  • Lines on credit check hold report
  • Orders on credit check hold report

Credit check Query

You can navigate

Setup => rules => credit

SELECT NAME "Rules",       to_char(start_date_active, 'DD-MON-YYYY') "Effective Dates From",       decode(credit_check_level_code, 'ORDER', 'Sales Order') "Credit Check Level",       decode(credit_hold_level_code, 'ORDER', 'Sales Order') "Credit Hold Level",       days_honor_manual_release "Days To Honor Manual Release",       conversion_type "Conversion Type",       check_item_categories_flag "Check Item Categories",       send_hold_notifications_flag "Send Hold Notifications",       quick_cr_check_flag "Use Pre-Calculated Exposure",       include_external_exposure_flag "Incl External Credit Exposure",       open_ar_balance_flag "Incl Open Receivables Balance",       include_payments_at_risk_flag "Include Payments At Risk",       open_ar_days "OPEN Receivables Days",       uninvoiced_orders_flag "Include Uninvoiced Orders",       incl_freight_charges_flag "Incl Frght And Special Charges",       include_tax_flag "Include Tax",       orders_on_hold_flag "Incl Orders currently On Hold",       shipping_interval "Scheduled Ship Horizon Days",       maximum_days_past_due "Maximum Days Past Due"  FROM apps.oe_credit_check_rules

EBS credit check

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.