After Applying Percentage-Based Or Amount-Based Allocation On Credit Freight Line, Click Distributions, Get Error APP-SQLAP-97734: The system cannot generate distributions for line 2 because: NO_APPLICABLE_DISTS (Doc ID 1468904.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

In the AP invoice workbench, process a credit memo. Enter a credit freight line, use the Allocations button and click Distributions on the Freight line. The following error is thrown:

Error message
APP-SQLAP-97734: The system cannot generate distributions for line 2 because: NO_APPLICABLE_DISTS


Steps to reproduce (example)
1 - Enter invoice header info
2 - Click the 'Corrections' button. Select 'Price Correction' and enter the original invoice number
3 - Click Find, one line returned.
4 - Select the line and enter this info:
- Correction Qty 1
- Unit Price : -80.00
Click Correct
5 - Go to Lines tab. One Item line already exists (matched to a PO line)
6 - Enter credit freight line. Enter line 2 as type = freight, amount = -22.00
7 - Click 'Allocations' button to display Allocation Rules window, one line returned
8 - Select the line, click Ok.
9 - On Lines tab, the Freight Line is shown along with a Tax line of amount (8.00)
10 - While on the Freight Line, click Distributions and get the error message

Additional info - Validate the invoice, a distribution variance hold is applied.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms