credit rule- Is the “Open Receivable Days“ Condition Based On Payment Due Dates Or The Invoice Date?

摘自：Document 1121193.1 (oracle.com)

Is the "Open Receivable Days" Condition Based On Payment "Due Dates" Or The Invoice Date? (Doc ID 1121193.1)

To Bottom

---

In this Document   Goal   Solution   References   APPLIES TO: Oracle Order Management - Version 11.5.9-11.5.10 to 12.2.2 [Release 11.5 to 12.2] Information in this document applies to any platform. Checked for relevance on 21-OCT-2013 GOAL Is the "Open Receivable Days" on the Credit Check Rules, Exposure tab based on the invoice date or due date? SOLUTION The "Open Receivable Days" is based on payment schedule "due dates" and not the actual invoice date. The below code/cursor extract highlights the usage of this "Open Receivables Days" setting in deriving the exposure element for "Include Open Receivables Balance" - if flagged "Y" (checked) in the Credit Check Rule. NOTE: extraction from the AR_PAYMENT_SCHEDULES table   Cursor ar_balance_in_ar_days IS   SELECT NVL(SUM(AMOUNT_DUE_REMAINING), 0)      FROM AR_PAYMENT_SCHEDULES    WHERE .....         AND .....         AND .....         AND SYSDATE - TRX_DATE > l_open_ar_days; REFERENCES NOTE:436479.1 - Credit Check Rule: 'Open Receivables Days' Field Functionality NOTE:365866.1 - Credit Checking Limits Hierarchy