R12: APXIIMPT Payables Open Interface Import Fails on ORA-01422 on PO_LINE_LOCATION_ID
(Doc ID 1470941.1)
Last updated on MARCH 12, 2019
Applies to:
Oracle Payables - Version 12.0.0 to 12.2 [Release 12.0 to 12.2]Information in this document applies to any platform.
Symptoms
APXIIMPT module: Payables Open Interface Import fails on
...
(Check_lines 9) Call v_check_po_info only for ITEM Lines
(Check_lines 9.1) This is an ITEM Line
(v_check_line_po_info 1) Validate po_header_id
(v_check_line_po_info 4) Validate po_line_id
(v_check_line_po_info 16) Validate po_line_location_id
(v_check_line_po_info 25) Validate p_po_distribution_id
(v_check_line_po_info 29.1) Get po number from po_header_id
(v_check_line_po_info 31) Get po_line_id
(v_check_line_po_info 32) Get po_line_location_id
(v_check_line_po_info 32) Get po_line_location_id
ORA-01422: exact fetch returns more than requested number of rows
the invoice has rejected status, but no rejection in AP_INTERFACE_REJECTIONS,
the output file does not show the invoice either.
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 |