What is the Purpose of Pre-Calculated Exposure in Credit Checking?

The use of Pre-Calculated Exposure was incorporated to improve performance. Previous versions of credit checking calculated customer exposure accessing underlying transactional tables. When a credit check request was executed, underlying transaction tables were summed to generate customer balance information.

Using the pre-calculated exposure option, credit checking will validate exposure against balance information stored in a summary table. The summary table is updated as often as your business practices require, and updates to the table are performed by submitting the Initialize Credit Summaries concurrent program. This program accesses both Oracle Receivables and Order Management transactional tables. It should be scheduled to run periodically, based on your specific business needs. Please refer to Note.293409.1: 'How Often Should Initialize Credit Summaries be Run?'

Pre-calculated exposure amounts can be either:
- Real time transactional data summarized at a specific point in time
- Exposure amounts imported into Oracle Order Management exposure tables
- Real time transactional data summarized at a specific point in time plus exposure amounts imported into Oracle Order Management exposure tables

If Credit Check Rule is set at the Sales Order Level, the use of Pre-Calculated Exposure is not mandatory and you can uncheck the flag. If Credit Check Rule is set at the Sales Order Line Level the Pre-Calculated flag cannot be unchecked.

The Exposure Tag

Use Pre-Calculated Exposure
===========================
This prevents the exposure from being calculated in real time. The Initialize Credit Summaries process must be run on a regular basis to obtain latest account balances from Accounts Receivable.

For Example:

The Initialize Credit Summary Process has been run.

The Credit Exposure Report shows that the Customer has an available balance of <$50> (i.e this amount is owed) and has an overall limit of 100 at site level. Orders booked for this customer will be placed on Hold.

The customer now makes a cash payment of $75 which is recorded and cleared in Receivables.

At this point a new order is created and booked. This order is place on credit check hold, Why ? Running the Credit Check Exposure report for the customer and credit rule shows that no change has been made to the available amount. If at this point you then run the Initialize Credit Summaries report followed by the credit Exposure Report. You will see that the balance Will change and in this example a credit amount of $25 is available. The Initialize Credit Summary process has updated credit tables in Order Management and the newly calculated balance will be used to determine if an order should be placed on hold.

Include Open Receivables Balance and Include Uninvoiced Orders
==============================================================
Either one or both of the attributes must be selected (the application will ensure that at least one of these is chosen).

Include Open Receivables Balance:
---------------------------------
The Open Receivables balance will be used to calculate the credit amount available to the customer. The balance used is the customer balance taking into account any cleared payments. If Pre-Calculated flag is set the receivables balance used will be the balance of the account when the Initialize Credit Summary process was last run.

Include Payments at Risk:
-------------------------
Selecting this attributes will also include in the customer balance payments, that are at Risk, i.e payments that have not yet been cleared.

Include Uninvoiced Orders:
--------------------------
If selected uninvoiced orders will be included in amount of credit that is available. I.e Uninvoiced orders that have been booked will reduce the amount of credit available.

==========================

The following are examples of how credit rule setup impacts exposure as shown in the Credit Exposure Report.

The receivables balance for the Customer is <5.61> - credit
Value of Orders Booked but not invoiced is $405 - this includes a single order for $45 that is on credit check hold. The credit holds have been cleared for the other orders.

EXAMPLE 1.
==========

Do NOT Use Pre-Calculated Exposure
Do Not Include Open Receivables Balances
Include Uninvoiced Orders
Do Not Include Orders Currently On Hold

| |---------------Credit Limit Currency ---------------|
| Overall Limit Exposure Available
--- --------------------- -------------------- -------------------

USD 47.00 360.00 <313.00>

EXAMPLE 2.
==========

Do NOT Use Pre-Calculated Exposure
Include Open Receivables Balances
Include Uninvoiced Orders
Do Not Include Orders Currently On Hold


| |---------------Credit Limit Currency ---------------|
| Overall Limit Exposure Available
--- --------------------- -------------------- -------------------

USD 47.00 354.39 <307.39>

EXAMPLE 3.
==========

Do NOT Use Pre-Calculated Exposure
Include Open Receivables Balances
Include Uninvoiced Orders
Include Orders Currently On Hold


| |---------------Credit Limit Currency ---------------|
| Overall Limit Exposure Available
--- --------------------- -------------------- -------------------

USD 47.00 399.39 <352.39>


EXAMPLE 4.
==========

Use Pre-Calculated Exposure
Include Open Receivables Balances
Include Uninvoiced Orders
Include Orders Currently On Hold

At the point a number of orders have been created and booked in Order Management. The following demonstrates how the Initialize Credit Summary process impacts Credit Exposure.

1. Value of orders created in OM, but not interfaced to AR is $225.
2. Initialize Credit Summary process is executed
3. Credit Exposure report shows exposure as $219.39 ($225 less $5.61 credit balance in AR)
4. New Orders Created in OM to the value of $180
5. Credit Exposure Report re-run and this still shows the credit exposure as $219.39
6. Initialize Credit Summary Process is executed
7. Credit Exposure Report re-run and this now shows the credit exposure as $399.39 ($225 + $180 lesss $5.61 credit balance in AR)


CREDIT EXPOSURE PRIOR to Initialize Credit Summary Process

| |---------------Credit Limit Currency ---------------|
| Overall Limit Exposure Available
--- --------------------- -------------------- -------------------

USD 47.00 219.39 <172.39>


CREDIT EXPOSURE AFTER Initialize Credit Summary Process

| |---------------Credit Limit Currency ---------------|
| Overall Limit Exposure Available
--- --------------------- -------------------- -------------------

USD 47.00 399.39 <352.39>


=============================


REPORTS / PROCESSES:
====================

Initialize Credit Summaries Table Concurrent Program
Order Management enables you to periodically rebuild a credit exposure image

Credit Check Processor Concurrent Program
The Credit Check Processor program can be run on demand to re evaluate Booked orders that have not been shipped yet.

Credit Exposure Report
The Credit Exposure report can be used to analyze your customers total credit exposure.