Error running AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE API and Passing Distributions - Populate Either TAX_RATE_ID or TAX_RATE_CODE to Create a Valid Tax Line (Doc ID 1511161.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle E-Business Tax - Version 12 and later
Oracle Receivables - Version 12 and later
Information in this document applies to any platform.

Symptoms

When running ar_invoice_api_pub.create_single_invoice API and passing distributions (p_trx_dist_tbl parameter ), it errors out with message :

Populate either tax_rate_id or tax_rate_code to create a valid tax line.

Debug Log shows :

Validations for ZX_TRX_TAX_LINK_GT
Opening the cursor - get_tax_link_gt_info_csr
Running Line-Tax Link related Validations : ZX_TRX_TAX_LINK_GT
No. of Rows inserted : 0
Updated the validation_check_flag to N in zx_trx_headers_gt for 1 trx_ids
ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR(-)
***ERROR*** Application_id : 222
***ERROR*** Entity_code : TRANSACTIONS
***ERROR*** Event_class_code : INVOICE
***ERROR*** Trx_id : 107195769
***ERROR*** Trx_line_id : 254316565
***ERROR*** Trx_level_type :
***ERROR*** Message_name : ZX_TAX_RATE_ID_CODE_MISSING
***ERROR*** Other_doc_application_id :
***ERROR*** Other_doc_entity_code :
***ERROR*** Other_doc_event_class_code :
***ERROR*** Other_doc_trx_id :
ZX_GLOBAL_STRUCTURES_PKG: delete_trx_line_dist_tbl()+
ZX_GLOBAL_STRUCTURES_PKG: delete_trx_line_dist_tbl()-
x_return_status from Validate_Tax_Attr : S

-- fill distributions
  l_trx_dist_tbl(1).trx_dist_id         := 3011;  
  l_trx_dist_tbl(1).trx_header_id         := 3011;
  l_trx_dist_tbl(1).percent             := 100;
  l_trx_dist_tbl(1).account_class       := 'REC';
  l_trx_dist_tbl(1).code_combination_id := 14260;

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