Error in AR_INVOICE_API_PUB.populate distributionsORA-01427: single-row subquery returns more than o
Hi,
When i use ar_invoice_api_pub.create_single_invoice to create ar invoice/debit memo/credit memo, it error out with error "Error in AR_INVOICE_API_PUB.populate distributionsORA-01427: single-row subquery returns more than one row", below is my code, would you pls help me check what is the error?
DECLARE
p_msg_count NUMBER;
p_msg_data VARCHAR2(2000);
p_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;
p_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
p_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
p_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;