Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Credit Check Functionality in Order Management for Techies

Posted on April 9th, 2010 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

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

dgreybarrow TABLES

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

dgreybarrow 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

dgreybarrow SYSTEM PARAMETER OPTIONS

  • Apply credit hold on zero value
  • order Credit Hold Sequence for Order Lines
  • Initiate Credit check at Cancellation

dgreybarrow 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:

  • 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 performed by the public credit check API OE_EXTERNAL_CREDIT_PUB.
  • External — External credit checks are configurable by an application developer and allow users to make calls to non-Oracle applications.

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

  • 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.

dgreybarrow 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.

dgreybarrow 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

dgreybarrow 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.

Posted in Oracle Order Management | No Comments »

Page 1 of 11