Is there OTBI report for available credit balance
Summary:
How to calculate Customer Available Credit Balance — is there an OOTB OTBI report, or is a custom report required?
Content (please ensure you mask any confidential information):
We need to determine each customer's available credit balance (Credit Limit minus current exposure/outstanding balance).
Questions:
- Is there an out-of-the-box OTBI subject area/report that calculates or exposes this value directly?
- If not, what is Oracle's recommended best practice for calculating available credit balance?
- If a custom-developed report is the only option, could you confirm the correct source tables/views and logic (e.g., credit limit source, exposure calculation) so we can build an accurate SQL query?
0