- OracleApps Epicenter - http://www.oracleappshub.com -

Credit Check Functionality in Order Management for Techies

This post will more focus on Technical part of credit check Functionality. You can check the functional [1] part of credir check functionality here [1].

TABLES

These are the main tables used for holding Credit Check functionality.

PROFILE OPTIONS

These Profile options specially meants for controlling credit check functionality.

SYSTEM PARAMETER OPTIONS

API

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 should be submitted for business approvals credit verification. The profile option ASO: Enable Credit Check determines if credit checks can be performed.

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

You should be very clear on key differences between internal credit checking and the credit checking functionality in OM, which is as:

CONCURRENT PROGRAM

1. Initialize Credit Summaries (OEXINICS)

  • This Program enables you to periodically rebuild a credit exposure image for all customers 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 outside of Oracle Applications into Oracle Order Management.Those who are doing system integration can take advatange of this.
  • External exposure data is imported from interface table OE_EXPOSURE_INTERFACE into OE_CREDIT_SUMMARIES table. 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 previously 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 previously imported amount. If a corresponding exposure amount does not previously 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 customers 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.

REPORTS

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 as

Setup => Rules => Credit

  1.  
  2. SELECT
  3. NAME "Rules",
  4. TO_CHAR (START_DATE_ACTIVE, 'DD-MON-YYYY') "Effective Dates From",
  5. DECODE (CREDIT_CHECK_LEVEL_CODE, 'ORDER', 'Sales Order') "Credit Check Level",
  6. DECODE (CREDIT_HOLD_LEVEL_CODE, 'ORDER', 'Sales Order') "Credit Hold Level",
  7. DAYS_HONOR_MANUAL_RELEASE "Days To Honor Manual Release",
  8. CONVERSION_TYPE "Conversion Type",
  9. CHECK_ITEM_CATEGORIES_FLAG "Check Item Categories",
  10. SEND_HOLD_NOTIFICATIONS_FLAG "Send Hold Notifications",
  11. QUICK_CR_CHECK_FLAG "Use Pre-Calculated Exposure",
  12. INCLUDE_EXTERNAL_EXPOSURE_FLAG "Incl External Credit Exposure",
  13. OPEN_AR_BALANCE_FLAG "Incl Open Receivables Balance",
  14. INCLUDE_PAYMENTS_AT_RISK_FLAG "Include Payments At Risk",
  15. OPEN_AR_DAYS "OPEN Receivables Days",
  16. UNINVOICED_ORDERS_FLAG "Include Uninvoiced Orders",
  17. INCL_FREIGHT_CHARGES_FLAG "Incl Frght And Special Charges",
  18. INCLUDE_TAX_FLAG "Include Tax",
  19. ORDERS_ON_HOLD_FLAG "Incl Orders currently On Hold",
  20. SHIPPING_INTERVAL "Scheduled Ship Horizon Days",
  21. MAXIMUM_DAYS_PAST_DUE "Maximum Days Past Due"
  22. FROM apps.OE_CREDIT_CHECK_RULES
  23.  
  24.  
  25.  

Hope this will helps.