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 JULY 13, 2022
Applies to:Oracle Purchasing - Version 12.2 and later
Oracle Payables - Version 12.2 and later
Information in this document applies to any platform.
Using Payables, Version 12.2
Importing the invoices is ending in error via Payable Invoice Import. The error is related to tax.
The invoice is expected to import properly.
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
***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
x_return_status from Validate_Tax_Attr : S
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.
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