EAP: Voucher Build abends at Step APVEDTMOVE.FUNDPCT.Step01 if 2 Quick Invoices are built for the same Vendor with multiple TAS's (Doc ID 2081315.1)

Last updated on FEBRUARY 16, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

Voucher Build is abending at Step APVEDTMOVE.FUNDPCT.Step01 (SQL) with an error. The issue occurs if 2 Quick Invoices are built for the same vendor with multiple TAS's.

ERROR
SQL Error: ORA-00001: unique constraint (EMDBO.PS_VCHR_FUND_PCT) violated

STEPS
1. Navigate to Set Up Financials/Supply Chain > Install > Installation Options > Payables page
2. Check the box for Enable Federal Payment
3. Navigate to Set Up Financials/Supply Chain > Common Definitions > Agency Location Codes > Agency Location
3. Set up Agency Location Code = 06180701
4. On the Agency Location > GWA Reporting Options page:
a. Business Activity = IPAC, AR and AP Pymnts
b. Reporter Category = AP Payments Only
5. Navigate to Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > Define Values > ChartField Values > Fund Code
6. Display SetID = FEDRL, Fund Code = F110
a. Click the Attributes hyperlink
b. ChartField Attribute = TSYMBOL
c. ChartField Attribute Value = 02X0105
7. Display SetID = FEDRL, Fund Code = F112
a. Click the Attributes hyperlink
b. ChartField Attribute = TSYMBOL
c. ChartField Attribute Value = 06010100
8. Navigate to General Ledger > Federal Reports > TAS/BETC > Define Agency ID
9. Agency Identifier = 011
10. Navigate to General Ledger > Federal Reports > TAS/BETC > Define Main Accounts
11. Main Account = 0100
12. Navigate to General Ledger > Federal Reports > TAS/BETC > Define TAS
13. Display Agency Identifier = 011, Main Account = 0100
a. Begin Period of Availability = 2014
b. End Period of Availability = 2014
c. Sub Account = 000
d. Check the box for Internal TAS
14. Attributes tab, click BETC hyperlink
15. Business Event Type Code setup
a. BETC = DISB
b. Description = Payment
c. Payment Or Collection = Payment
d. Active / Inactive = Active
16. Attributes tab, click Fund Code hyperlink
17. Fund Code setup
a. SetID = FEDRL, Fund Code = G100
b. SetID = FEDRL, Fund Code = G200
18. Attributes tab, click TAS Formats hyperlink
19. TAS Formats setup
a. String = 1140100
b. GWA TAS = 1140100
c. Partial 224 = 1120140100
20. Navigate to General Ledger > Federal Reports > TAS/BETC > Define TAS
21. Display Agency Identifier = 011, Main Account = 3800
a. Sub Account = 000
b. Check the box for Internal TAS
22. Attributes tab, click BETC hyperlink
23. Business Event Type Code setup
a. BETC = DISB
b. Description = Payment
c. Payment Or Collection = Payment
d. Active / Inactive = Active
24. Attributes tab, click Fund Code hyperlink
25. Fund Code setup
a. SetID = FEDRL, Fund Code = G300
26. Attributes tab, click TAS Formats hyperlink
27. TAS Formats setup
a. String = 11X3800
b. GWA TAS = 11X3800
c. Partial 224 = 11X3800
28. Navigate to Banking > Banks and Branches > Bank Information
29. Display Bank = USBNK
a. Agency Location Code = 06180701
30. Navigate to Vendors > Vendor Information > Add/Update > Vendor
31. Display Vendor ID = USA0000001
32. On the Location page, click the Payables hyperlink
33. On the Payables Options page, under the Bank section
a. Bank = USBNK
b. Account = CHCK
34. Under the Additional Payment Information section
a. Payment Method = EFT
35. Under Treasury Payment section
a. Check the box for Treasury Payment
b. Enclosure Code = Name Only
36. Populate the Vendor Bank Accounts section
37. On the Vendor > Federal page setup
a. Check the box for Federal Vendor
b. Agency Location Code = 06180701
38. Create 1st Quick Invoice
a. Business Unit = FED01
b. Vendor ID = USA0000001
c. Invoice Number = HOUSETEST1
d. Add 1 Invoice Line
e. 1st line, Merchandise Amount = $20
f. Click Distribution
39. Distribution Lines page setup
a. For Voucher Line 1:
b. Account = 1000
c. Fund Code = G100
d. Dept = ADM100
e. Bud Ref = B2015
40. Create 2nd Quick Invoice
a. Business Unit = FED01
b. Vendor ID = USA0000001
c. Invoice Number = HOUSETEST2
d. Add 1 Invoice Line
e. 1st line, Merchandise Amount = $30
f. Click Distribution
41. Distribution Lines page setup
a. For Voucher Line 1:
b. Account = 1000
c. Fund Code = G300
d. Dept = ADM100
e. Bud Ref = B2015
42. Run Voucher Build
43. Voucher Build abends at Step APVEDTMOVE.FUNDPCT.Step01 with the above error

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms