Receivables - EBS (MOSC)

MOSC Banner

Error in AR_INVOICE_API_PUB.populate distributionsORA-01427: single-row subquery returns more than o

edited Mar 8, 2018 9:07AM in Receivables - EBS (MOSC) 9 commentsAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center