EAP: Voucher Build abends at Step APVEDTMOVE.FUNDPCT.Step01 for Fund Code / TAS (Doc ID 2033583.1)

Last updated on NOVEMBER 01, 2015

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.1 to 9.2 [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 due if 2 Fund Codes are mapped to the same TAS.

ERROR
Return: 805 - ORA-00001: unique constraint (EMDBO.PS_VCHR_FUND_PCT) violated

Process 13045 ABENDED at Step APVEDTMOVE.FUNDPCT.Step01 (SQL) -- RC = 805

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 = 2015
b. End Period of Availability = 2017
c. Sub Account = 000
d. Start Date = 10/01/2014
e. End Date = 12/31/2016
f. 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 = F110
b. SetID = FEDRL, Fund Code = F112
18. Attributes tab, click TAS Formats hyperlink
19. TAS Formats setup
a. String = 115/70100
b. GWA TAS = 1115/170100
c. Partial 224 = 112015/20170100
20. Navigate to Banking > Banks and Branches > Bank Information
21. Display Bank = FDBNK
a. Agency Location Code = 06180701
22. Navigate to Banking > Bank Accounts > External Account
23. Payment Methods page setup
a. Setup Bank = FDBNK
b. Payment Method = EFT
c. Settle By = Pay Cycle
d. Layout = SPSCHK
24. Navigate to Vendors > Vendor Information > Add/Update > Vendor
25. Display Vendor ID = 1FEDRLVNDR
26. On the Location page, click the Payables hyperlink
27. On the Payables Options page, under the Bank section
a. Bank = FDBNK
b. Account = SCHK
28. Under the Additional Payment Information section
a. Payment Method = EFT
b. Layout = SPSCHK
29. Under Treasury Payment section
a. Check the box for Treasury Payment
b. Enclosure Code = Name Only
30. Populate the Vendor Bank Accounts section
31. On the Vendor > Federal page setup
a. Check the box for Federal Vendor
b. Agency Location Code = 06180701
32. Create a Quick Invoice
a. Business Unit = FED01
b. Vendor ID = 1FEDRLVNDR
c. Add 2 Invoice Lines
d. 1st line, Merchandise Amount = $200
e. 2nd line, Merchandise Amount = $300
f. Click Distribution for each line
33. Distribution Lines page setup
a. For Voucher Line 1:
b. Account = 1000
c. Fund Code = F110
d. For Voucher Line 2:
e. Account = 1001
f. Fund Code = F112
34. Run Voucher Build
35. 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