My Oracle Support Banner

ZX_REF_DOC_MISSING Error In Invoice Open Interface Due To Missing Data In ZX Table For the Purchase Order (Doc ID 2643993.1)

Last updated on FEBRUARY 28, 2020

Applies to:

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

Symptoms

Using Payables, Version 12.2

Actual:
Importing the invoices is ending in error via Payable Invoice Import. The error is related to tax.

Expected:
The invoice is expected to import properly.

Error:
ZX_REF_DOC_MISSING Reference document information is
  missing in our ZX repository.

This is per the FND Logging and invoice import logs.

Updated the validation_check_flag to N in zx_trx_headers_gt for 1 trx_ids
ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR(-)
***ERROR*** Application_id : 200
***ERROR*** Entity_code : AP_INVOICES
***ERROR*** Event_class_code : STANDARD INVOICES
***ERROR*** Trx_id : 3650764
***ERROR*** Trx_line_id : 1
***ERROR*** Trx_level_type : LINE
***ERROR*** Message_name : ZX_REF_DOC_MISSING
***ERROR*** Other_doc_application_id : 201
***ERROR*** Other_doc_entity_code : PURCHASE_ORDER
***ERROR*** Other_doc_event_class_code : PO_PA
***ERROR*** Other_doc_trx_id : 5399149
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



Replication Steps:
The issue can be reproduced at will with the following steps:
1. iSupplier is used to conduct and submit the invoice data. (This issue is not specific to iSupplier however)
   - Essentially, data is loaded into the Payables Invoice Open Interface Tables
2. iSupplier based invoice data is loaded into the invoice interface tables.
3. The Payable Invoice import fails and the FND Logging shows that the error is due to the tax.


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
Cause
Solution
References


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