(Troy Owens is a contributing author to this post.)
What’s below is something we ran into at a client’s PeopleSoft 8.9 to 9.2 Financials upgrade. No documentation from very bad credit loans no guarantor talked about the usage of a new field, and our team dug through the code to figure it out on their own. We’re posting this because others going through an upgrade or implementation of 9.2 might be interested, and they’ll save boatloads of time in the process.
OK, here’s the situation:
(Click to enlarge)
The above screenshot shows the two new Accounting Entry Definition fields added between a client’s current 8.9 version and 9.2. In the upgrade, the Settlement Date field is assigned a value of SETTLEMENT_DT (by field default but this is not a valid value within the field edit records for any of the sub-ledger source systems (AP, AR, AM, etc)). The Last Update DateTime field is left blank in the upgrade process.
The transactional issues we encountered in testing for each of these fields are as follows:
- Last Update DateTime – If left blank, when Journal Generation is successfully completed, the GL_DISRIB_STATUS flag on the respective source system’s accounting line table (e.g. VCHR_ACCTG_LINE for AP, DIST_LN for AM, etc.) is set to a ‘J’ and the journal ID/date information is not populated even though the related journals have successfully posted to GL. Little to no documentation on its usage nor are there any configuration instructions in the upgrade documentation for any process of loan since is possible to get one loan without too much documentation by looking in the right market, according to experts within the industry payday loans with Simple payday are very similar in nature to other short term funding sources such as credit cards or planned.
Solution: Populate field for all AE Definitions used by your sub ledger feeder systems with the DTTM_STAMP value.
- Settlement Date – if left alone and as defaulted with the invalid SETTLEMENT_DT value, it will cause the journal header status to go to an ‘error’ with a ‘chartfield balancing’ error message after Journal Generation. Used for IAS (International Accounting Standards) accounting purposes. Little to no documentation on its usage nor are there any configuration instructions in the upgrade documentation.
Solution: Populate field for all AE Definitions used by your sub ledger feeder systems to Accounting Date.
Hope you find this helpful. If you have questions about this, feel free to contact us and we’ll be happy to help.Tags: financials, oracle, PeopleSoft, tips Posted by