EAP: Voucher Build Does Not Check Business Unit Security For Vouchers Loaded Using the ExcelUploadforVoucher.xlsm File (Doc ID 2907227.1)

Last updated on FEBRUARY 22, 2024

Applies to:

Symptoms

Users are able to load an ExcelUploadforVoucher.xlsm file containing Business Units they don't have security access to. Voucher Build, run by the same User, is creating these Vouchers with no errors in a Postable status. Users are unable to add vouchers online for Business Units they don't have security for. The logic should be the same for vouchers created through Voucher Build.
 

STEPS
--------

1. Setup Financials/Supply Chain > Security > Activate Row-level Security > Type of Security = User ID Level Security

2. Setup Financials/Supply Chain > Security > Unit by User ID 
    a. User ID = VP1 has access to BU = US001 but not US003
    b. User ID = VP2 does has access to BU = US001 and US003

3. Values in ExcelUploadforVoucher.xlsm file > Business Unit = US001, UserID = VP2, GL Business Unit = US003

4. VP1 clicks the Generate XML and Post button in the ExcelUploadforVoucher.xlsm file to load > Note, VP1 does not have security access for GL Unit = US003 > OK

5. Message from load: Imported 1 vouchers > OK

6. VP1 runs Voucher Build > Accounts Payable > Batch Processes > Vouchers > Voucher Build

7. Voucher is created successfully and the Voucher Entry Status = Postable

Changes

Cause

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