EGL9.1+: Journal Edit Sets Journal With VAT Account To Error But Mark Journal as Validated After Second Edit Without Any Changes.

(Doc ID 1627909.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.
****Checked for Currency on 13-Oct-2015****


On :  9.1 version, VAT

9.1 Bundle 12, Global bundle 6.

Running journal edit against an imported journal with at least one line with a VAT applicable account causes the journal to go to error because of missing VAT default setup.

However, the journal goes to Valid during 2nd journal edit without any changes done on the journal.

1) Journal line edit error received when relevant VAT entity has HOME_COUNTRY_FLG = ‘N' ( VAT default is not set up properly)

Field Name Field Long Name Set Msg Message Text
COUNTRY_VAT_RPTG VAT Reporting Country 9060 736 VAT Reporting Country may not be blank

2) Journal line edit error received when ACCOUNT is VAT account and ACCOUNT VAT DEFAULT does not have either Record Input VAT or Record Output VAT flag selected.

Field Name Field Long Name Set Msg Message Text
VAT_RCRD_INPT_FLG Record Input VAT 9060 764 You must specify that you are either recording input VAT or recording output VAT, but not both

Both journal line edit errors are expected because VAT default setup is missing.
However, same journal should fail the 2nd edit with same edit error.

The issue can be reproduced at will with the following steps:
1. Import a journal with at least one line with a vat applicable account ( either through spreadsheet journal import or flat file import without data in PS_JRNL_VAT)
2. Run Journal edit (1st run) and journal edit error returns.
3. Run Journal edit again ( 2nd run) without any change and journal is marked 'V' status.
  - journal re-edit option is not selected.

The issue has the following business impact:
- Lost productivity and user confusion about why a journal is in error then is valid.
- incorrect data created in PS_JRNL_VAT if user didn't investigate and set up missing VAT default but simply run the 2nd journal edit without any change.


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