AP195 Issue Cannot close period
Jobs is in needs recovery with error
tsStoreDBRec error is Record was modified or deleted since your retrieval (131). Additional information is 100. Additional Text is: ModifySqlRec
There are 3 bad invoices in APINVOICE and APPAYMENT with no distribution records in APDISTRIB.
The 3 bad records are as follows
Resolution:
In SQL Manger, query the APINVOICE and APPAYMENT files for any invoices with bad name format as below:
Verify these records do not have any distributions records in APDISTRIB. If not, Delete these bad invoices.
APPAYMENT
APINVOICE
Run commit to commit the changes
Go into lawson and recover the job
Keywords:
Retiring Lawson, PeopleSoft, or Oracle? APIX archives the entire application — every table, every year, attachments and security included — into your own AWS account in about 30 days, so you can decommission the legacy system and keep full access to the history.
Leave a Reply
Want to join the discussion?Feel free to contribute!