My Oracle Support Banner

N:Credit Management - Open Authorization And Receivables Balance (Doc ID 2718755.1)

Last updated on OCTOBER 17, 2020

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.13.20.04.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
N:Credit Management - Open Authorization and Receivables Balance

Users are trying to use credit management and they need to understand on what the open authorization amount actually comprises of.

Receivables Balance:
For example, Customer xxx has the following values on the case folder data points (attached);
Receivables Balance : 137,550.94
Open Auth : 143,175.39

However the Custom Account Summary shows 111K
There is no recent activity to suggest timing differences

Open Authorization:
Case Folder amount: 143,175.39
Open Sales Orders Fufilment lines : 32K.

Customer Credit Limit 240,000 :

Additional Reports:
for this same reason. users was recommended this SQL;
Open Authorization amount: £112,853.53 (export attached)

select * from FUSION.AR_CUST_CREDIT_AUTHORIZATION where
AUTHORIZATION_STATUS = 'OPEN' and CUST_ACCOUNT_ID = (select Cust_Account_Id from
FUSION.Hz_Cust_Accounts where Account_Number='<account_number>');

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.