R12: AP: "APP-SQLAP-97734" Error Occurs When Clicking All Distribution Button in Invoice Workbench
(Doc ID 2399339.1)
Last updated on DECEMBER 07, 2020
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!