My Oracle Support Banner

R12: AP: "APP-SQLAP-97734" Error Occurs When Clicking All Distribution Button in Invoice Workbench (Doc ID 2399339.1)

Last updated on MAY 22, 2023

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.


When clicking "All Distributions" button for an invoice in the Invoice Workbench (APXINWKB.fmb), the following error occurs:

APP-SQLAP-97734: The system cannot generate distributions for line 5 because &TOKEN2

The invoice has been imported and the problem line 5 is a non-match item line.

The diagnostic script ap_gdf_detect_pkg.sql (Doc ID 1360390.1) detected no related data issues.

There is only "Could not Generate the Taxable Distributions" in the debug log as below:

AP.PLSQL.AP_GENERATE_DISTRIBUTIONS_PKG.Generate_Dists_For_Invoice Check if sufficient data is provided to generate candidate distributions
AP.PLSQL.AP_APPROVAL_PKG.Check_Insufficient_Line_Data processing info for line number: 5 l_alloc_rule_type: project_id: generate_dists: Y
AP.PLSQL.AP_GENERATE_DISTRIBUTIONS_PKG.Generate_Dists_For_Invoice Generating Candidate Distributions for Taxable Line
AP.PLSQL.AP_APPROVAL_PKG.Execute_Dist_Generation_Check Input Parameters: invoice id: xxxxxxx line_number: 5 generate_dists: Y distribution_set_id: accouting_date: 28-FEB-18 period_name: 2018/02
AP.PLSQL.AP_APPROVAL_PKG.Execute_Dist_Generation_Check Execute_Dist_Generation_Check - Insert_Single_Dist_From_Line
AP.PLSQL.AP_GENERATE_DISTRIBUTIONS_PKG.Generate_Dists_For_Invoice Could not Generate the Taxable Distributions




To view full details, 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 a vibrant support community of peers and Oracle experts.