My Oracle Support Banner

VENDINVC Aborts with ORA-01405 for Deals Created with Partners (Doc ID 2829680.1)

Last updated on MAY 16, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.


Vendinvc doesn't post invoice details into STAGE_COMPLEX_DEAL_HEAD and STAGE_COMPLEX_DEAL_DETAIL for partner(wholesaler) deal. Note: it works fine if the deal is raised for supplier parent.

Error :

Steps to replicate:

1 Create wholesaler and associate with the supplier sites in Item/Supplier/Country level
2 Create bill back deal with Vendor as a Wholesaler based on the value of receptions for a partner with the invoice to be generated to a supplier site.
3 In the finance section select a supplier site and the bill back method Debit Note.
4 Add Component
5 Include item/location.
6 Add threshold.
7 Submit and approve the deal.
8 Create a purchase Order for the supplier sites associated to the wholesaler and receive it.
9 Make sure the deal is exploded into deal_item_loc_explode
10 Run salstage process.
11 Run prepost dealact_sales pre.
12 Run dealact process.
13 Change vdate for the last day of the week, since the Deal reporting and invoicing period is set to weekly
14 Run prepost dealinc pre and dealinc
15 See the actual income calculated in deal_actuals_item_loc
16 Run dealfct pre , dealfct and dealfct post
17 Make sure the deal income is updated to daily data by running dealday.
18 Run prepost vendinvc pre and vendinvc and notice the error.


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

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