R12: AP: JAI: Error on Validation of Payables Invoice APP-SQLAP-97731 Tax Calculation Error &TOKEN1, Error in Debug - ORA-01400: cannot insert NULL into ("JA"."JAI_INTERFACE_ERR_LINES"."INTERFACE_SOURCE_LINE_ID")
(Doc ID 3005757.1)
Last updated on FEBRUARY 20, 2024
Applies to:
Oracle Financials for India - Version 12.1.1 and laterInformation in this document applies to any platform.
Symptoms
When attempting to validate a Payables invoice from Invoice Workbench the following error occurs.
ERROR on Invoice Workbench
-----------------------
APP-SQLAP-97731: The system cannot generate distributions
because tax calculation failed due to the following error:
&TOKEN1
ERROR In FND Debug
-----------------------
JA.PLSQL.JAI_OPEN_TAX_DET_PKG.validate_interface_tax_lines INTERFACE_TAX_LINE_ID :
JA.PLSQL.JAI_OPEN_TAX_DET_PKG.validate_interface_tax_lines Validate unique interface tax rate.
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.validate_init_tax_line validate_init_tax_line----begin----()+
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.validate_init_tax_line Error message as:tax rate and tax line num are required. is required
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.validate_init_tax_line validate_init_tax_line----End----()+
JA.PLSQL.JAI_OPEN_TAX_DET_PKG.validate_interface_tax_lines ORA-01400: cannot insert NULL into ("JA"."JAI_INTERFACE_ERR_LINES"."INTERFACE_SOURCE_LINE_ID")
JA.PLSQL.JAI_OPEN_TAX_DET_PKG.determine_tax Non-STANDARD/Tax: Call validate_interface_tax_lines:Encountered an error in JAI_OPEN_TAX_DET_PKG.determine_tax. Encountered an error in JAI_OPEN_TAX_DET_PKG.validate_interface_tax_lines. ORA-01400: cannot insert NULL into ("JA"."JAI_INTERFACE_ERR_LINES"."INTERFACE_SOURCE_LINE_ID")
-----------------------
APP-SQLAP-97731: The system cannot generate distributions
because tax calculation failed due to the following error:
&TOKEN1
ERROR In FND Debug
-----------------------
JA.PLSQL.JAI_OPEN_TAX_DET_PKG.validate_interface_tax_lines INTERFACE_TAX_LINE_ID :
JA.PLSQL.JAI_OPEN_TAX_DET_PKG.validate_interface_tax_lines Validate unique interface tax rate.
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.validate_init_tax_line validate_init_tax_line----begin----()+
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.validate_init_tax_line Error message as:tax rate and tax line num are required. is required
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.validate_init_tax_line validate_init_tax_line----End----()+
JA.PLSQL.JAI_OPEN_TAX_DET_PKG.validate_interface_tax_lines ORA-01400: cannot insert NULL into ("JA"."JAI_INTERFACE_ERR_LINES"."INTERFACE_SOURCE_LINE_ID")
JA.PLSQL.JAI_OPEN_TAX_DET_PKG.determine_tax Non-STANDARD/Tax: Call validate_interface_tax_lines:Encountered an error in JAI_OPEN_TAX_DET_PKG.determine_tax. Encountered an error in JAI_OPEN_TAX_DET_PKG.validate_interface_tax_lines. ORA-01400: cannot insert NULL into ("JA"."JAI_INTERFACE_ERR_LINES"."INTERFACE_SOURCE_LINE_ID")
STEPS
-----------------------
1. Payables Responsibility > Invoices > Entry > Invoices
2. Query invoice and Actions > Validate
3. Error is observed
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |