My Oracle Support Banner

EEX9.2: Period End Accruals for My Wallet is Not Being Loaded into EX_ACCTG_LINE Table (Doc ID 2701432.1)

Last updated on AUGUST 17, 2020

Applies to:

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

Symptoms

Period End accruals for My Wallet is not being loaded to EX_ACCTG_LINE table, while it should be loaded.

Customer is in the process of implementing the period end accruals for the My Wallet transactions. The transactions that are flagged for accrual are not being inserted into the EX_ACCTG_LINE table because the bill code was updated to a blank value as the bill code was not set on the ex user preferences and was not a required field.

REPLICATION STEPS
-----------------------
1. At the Expenses Business Unit definition, set the EX_PACCRUE Journal Generator template - Set Up Financial/ Supply Chain/ Business Unit Related/ Expenses/ Expense Definition page - Business Unit 2 tab.
2. Set the period end accruals for Accrue Wallet Entries - at Business Unit 1 tab.
3. Change Billing Type from Internal (existing setup) for KU0042 to blank Billing Type field.
4. There was no definition, so the page was updated with below details:
Effective Date- 01/01/1900 and below Status Fields:
- BUDGET_HDR_STATUS  - Field Value as V (Valid)
- SHEET_STATUS -  Field Value as PND (Pending) at Set Up Financial/Supply Chain/Product Related/Expenses/Management/Period End accrual Options for Document Type Expense Report
5. Check to have a My Wallet entry from a prior period in an unassigned status (transaction date is 12/17/2019, prior date) for KU0042 under Employee Self-Service/Travel and Expenses/My Wallet.
6. There is a transaction in EX_TRANS with a TXN_STATUS of U in the period that user is trying to accrue for when using:
select * from PS_EX_TRANS where TXN_STATUS='U'and TRANS_DT='17-Dec-19'
7. Under Travel and Expenses > Process Expenses > Period End Accrual Processing run the FS_PEACCRL application engine Select Process All Business Units.
8. Successfully ended.
9. Transaction of 33 USD is not listed in the table:
select * from PS_EX_ACCTG_LINE where EMPLID='KU0042'and MONETARY_AMOUNT='33'
10. When using SQL statement below, BILL_CODE_EX is empty
select * from PS_EX_WALLET_TMP4 where EMPLID='KU0042'
11. If changing setup for KU0042 and populating Billing Type field under Travel and Expenses/ Manage Employee Information/Update Profile- populate Billing Type field as "Billable"
12. Then delete all rows from Period End Accrual Delete path - Travel and Expenses/Process Expenses/ Period End Accrual Delete - Click on Yes Delete button - See that there is no line anymore
13. Transaction is there when checking below SQL statement:
select * from PS_EX_TRANS where TXN_STATUS='U'and TRANS_DT='17-Dec-19'
14. Transaction is not in the table when using below SQL statement:
select * from PS_EX_ACCTG_LINE where EMPLID='KU0042'and MONETARY_AMOUNT='33'
15. Run the process again -  Under Travel and Expenses > Process Expenses > Period End Accrual Processing run the FS_PEACCRL application engine
16. Process is successfully run
17. Now, table has accounting lines generated for the transaction created (because of the setup change)
select * from PS_EX_ACCTG_LINE where EMPLID='KU0042'and MONETARY_AMOUNT='33'

For the replication steps, please review Replication_File.pdf.

NOTE: In the  attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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