My Oracle Support Banner

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 DECEMBER 03, 2019

Applies to:

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


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
***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*** 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;


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.