VAT Transaction Loader (FS_VATUPDFS) Does Not Process AP Lines When GL BU is Different From AP BU (Doc ID 2008711.1)

Last updated on DECEMBER 23, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ENVIRONMENT
------------
9.2 PUM image 10
PTools 8.54.06


ACTUAL BEHAVIOR  
---------------
Transactions are not being loaded by VAT Transaction Load process when the distribution BU is different

EXPECTED BEHAVIOR
-----------------------
Process should load all transactions as per request

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Using delivered GL BUs FRA01, FRA03 and FRAE1; and AP BU FRA01
2. Link BUs FRA01 and FRAE1 to VAT Entity FRA01V, and FRA03 to FRA03V (Set Up Financials/Supply Chain > Common Definitions > VAT and Intrastat > Value Added Tax > VAT Entity)
3. Set VAT Defaults VAT Apportionment Control to Distribution GL Business Unit (Set Up Financials/Supply Chain > Business Unit Related > General Ledger > VAT Defaults tab > Click on VAT Defaults link)
4. Set Business Unit InterUnit option (SHARE SetId) to Distribution Line GL Business Unit (Set Up Financials/Supply Chain > Common Definitions > VAT and
Intrastat > Value Added Tax > Business Unit Interunit Option)
5. Create about 3 vouchers using AP BU FRA01 and each with one distribution line distributed to GL BU FRA01, FRA03 and FRAE1, respectively.
6. Post Vouchers
7. VCHR_ACCTG_LINE is updated with lines from above marked for distribution (VAT Dstrb Status = 'N')
8. Run VAT Transaction Loader for VAT Entity FRA01V and FRA03V
9. Only line distributed (VAT Dstrb Status = 'D') is the line where AP and GL BU are the same (FRA01)

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