R12: Exception: 023 Error Occurred During Tax Calculation When Autocreate Requisition to Purchase Order In Buyer Work Center (Doc ID 1665102.1)

Last updated on JANUARY 20, 2017

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

After applying Patch 18221238, tax errors occur when attempt to autocreate requisition to purchase order in buyer work center .

Tax log shows :

po.plsql.PO_TAX_INTERFACE_PVT.APPEND_ERROR.BEGIN 2 p_message_text = po.plsql.PO_TAX_INTERFACE_PVT.CALCULATE_TAX.#80:-1400ORA-01400: cannot insert NULL into ("ZX"."ZX_TRANSACTION_LINES_GT"."LINE_AMT")
po.plsql.PO_TAX_INTERFACE_PVT.APPEND_ERROR.20 1 l_length= 1
po.plsql.PO_TAX_INTERFACE_PVT.APPEND_ERROR.END 2 End of subprogram.
po.plsql.PO_TAX_INTERFACE_PVT.CALCULATE_TAX.80.EXCEPTION 4 -1400ORA-01400: cannot insert NULL into ("ZX"."ZX_TRANSACTION_LINES_GT"."LINE_AMT");SQLERRM = ORA-01400: cannot insert NULL into ("ZX"."ZX_TRANSACTION_LINES_GT"."LINE_AMT")
po.plsql.PO_TAX_INTERFACE_PVT.CALCULATE_TAX.END 2 x_return_status = U
po.plsql.PO_TAX_INTERFACE_PVT.CALCULATE_TAX_WRAPPER.10 1 PO calculate_tax returned with status U
po.plsql.PO_TAX_INTERFACE_PVT.CALCULATE_TAX_WRAPPER.END 2 End of subprogram.
po.plsql.PO_TAX_INTERFACE_PVT.CALCULATE_TAX_WRAPPER.END 2 x_return_status = U
po.plsql.PO_PDOI_ERR_UTL.add_warning.BEGIN 2 Start of subprogram.
po.plsql.PO_INTERFACE_ERRORS_UTL.add_to_errors_tbl.BEGIN 2 err_name = PO_PDOI_TAX_CALCULATION_ERR

Steps to Reproduce

1. Navigate to Buyer Work Center

2. Select the required requisition

3. From the document builder add it to New Order

 

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