My Oracle Support Banner

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


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