Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- "org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; ERROR: duplicate key value violates unique constraint ""idx_sl_so_balance_invoice_01""
- Detail: Key (tenant_id, ou_id, partner_id, ref_doc_type_id, ref_id, ref_item_id, do_receipt_item_id)=(10, 46, 38402, 311, 382, 831, 194) already exists.
- Where: SQL statement ""WITH insert_balance_invoice AS (
- SELECT B.product_id, D.qty_so,
- -- before
- ROUND(D.gross_sell_price * (D.qty_so)) AS gross_amount_before,
- D.nett_item_amount AS nett_item_amount_before, D.tax_amount AS tax_amount_after_disc_before,
- f_get_gross_amount_after_discount_with_rounding_mode(D.gross_sell_price, D.flg_disc, D.discount_percentage, D.discount_amount,
- D.qty_so, f_get_digit_decimal_doc_curr(vSoDocTypeId, D.curr_code),vRoundingModeNonTax) AS gaad_before,
- -- after
- ROUND(D.gross_sell_price * (D.qty_so - B.qty_return)) AS gross_amount_after,
- f_get_gross_amount_after_discount_with_rounding_mode(D.gross_sell_price, D.flg_disc, D.discount_percentage, D.discount_amount,
- (D.qty_so - B.qty_return), f_get_digit_decimal_doc_curr(vSoDocTypeId, D.curr_code),vRoundingModeNonTax) AS gaad_after,
- f_get_tax_amount_after_discount_with_rounding_mode(f_get_gross_amount_after_discount_with_rounding_mode(D.gross_sell_price, D.flg_disc, D.discount_percentage, D.discount_amount,
- (D.qty_so - B.qty_return), f_get_digit_decimal_doc_curr(vSoDocTypeId, D.curr_code),vRoundingModeNonTax), flg_tax_amount, tax_percentage, f_get_digit_decimal_doc_curr(vSoDocTypeId, D.curr_code),vRoundingModeNonTax) AS tax_amount_after_disc_after,
- -- other data
- A.tenant_id, A.ou_id, E.partner_bill_to_id, C.so_id,
- A.ref_doc_type_id, A.ref_id, F.doc_no, F.doc_date, B.ref_id AS ref_item_id, ROUND(B.qty_return * D.qty_so / D.qty_int) AS qty,
- D.so_uom_id, D.curr_code, D.nett_sell_price, D.flg_tax_amount, D.tax_percentage,
- B.do_receipt_item_id
- FROM in_do_receipt A, in_do_receipt_item B, in_balance_do_item C, sl_so_item D, sl_so E, sl_do F, sl_so_balance_invoice G
- WHERE A.do_receipt_id = vDoReceiptId AND
- A.do_receipt_id = B.do_receipt_id AND
- B.ref_id = C.do_item_id AND
- C.so_item_id = D.so_item_id AND
- D.so_id = E.so_id AND
- A.ref_id = F.do_id AND
- G.ref_id = F.do_id AND
- G.ref_item_id = C.do_item_id AND
- B.qty_return > 0
- ), diff_summary AS (
- SELECT A.product_id, tax_amount_after_disc_before - tax_amount_after_disc_after AS tax_diff,
- f_get_dpp_after_discount(A.gaad_before-A.gaad_after, A.flg_tax_amount, A.tax_amount_after_disc_before - A.tax_amount_after_disc_after) AS dpp_after_disc_diff,
- (gross_amount_before - gaad_before) - (gross_amount_after - gaad_after) AS disc_amount_diff
- FROM insert_balance_invoice A
- )
- INSERT INTO sl_so_balance_invoice
- (tenant_id, ou_id, partner_id, so_id,
- ref_doc_type_id, ref_id, ref_doc_no, ref_doc_date, ref_item_id, qty_dlv_so, so_uom_id,
- curr_code, price_so, item_amount, flg_invoice, invoice_id,
- regular_disc_amount, promo_disc_amount, adj_regular_disc_amount, adj_promo_disc_amount,
- ""version"", create_datetime, create_user_id, update_datetime, update_user_id,
- do_receipt_item_id)
- SELECT tenant_id, ou_id, partner_bill_to_id, so_id,
- ref_doc_type_id, ref_id, doc_no, doc_date, ref_item_id, -1 * qty, so_uom_id,
- curr_code, nett_sell_price,
- -1 * (B.dpp_after_disc_diff + B.disc_amount_diff),
- vFlagInvoice, vEmptyId,
- -1 * B.disc_amount_diff, 0, 0, 0,
- 0, vDatetime, vUserId, vDatetime, vUserId,
- do_receipt_item_id
- FROM insert_balance_invoice A
- JOIN diff_summary B ON A.product_id = B.product_id""
- PL/pgSQL function in_submit_do_receipt(bigint,character varying,character varying) line 192 at SQL statement; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint ""idx_sl_so_balance_invoice_01""
- Detail: Key (tenant_id, ou_id, partner_id, ref_doc_type_id, ref_id, ref_item_id, do_receipt_item_id)=(10, 46, 38402, 311, 382, 831, 194) already exists.
- Where: SQL statement ""WITH insert_balance_invoice AS ("
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement