GL199 Company Values changing

 2 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Austin
New Member
Posts: 3
New Member
    We have come into an interesting issue when some of our companies are running their GL199 closing. The issue is sporadic & not consistent across other companies. What we are seeing is that the company value is changing somehow from a numerical value (eg. 3201) to an 'otoc' value somehow. Has anyone ever come across this? here is an excerpt from the exam log of the job below. What makes this more interesting is when we actually recover the job, it completes successfully. Infor has added slight revisions to the GL199PD which is why the fields are prefixed differently. Please take note of the 3rd line which is holding the correct value, however the very same call to this value on lines 7 & 8 has the value of 'otoc'. Anyone ever encounter anything like this?


    1 MPJ-050-PRM-COMPANY 3201
    2 MPJ-050-PRM-COMPANY-GROUP
    3 MPJ-105-PRM-COMPANY 3201 :)
    4 Closing company 3201
    5 MPJ-105-PHASE-5-CLOSE-OPTION L
    6 MPJ-450-UPDATE-PARAMETERS
    7 MPJ-450-PRM-COMPANY otoc :crazy:
    8 MPJ-450-DB-COMPANY otoc :crazy:
    9 MPJ-450-GLSYSTEM-SW 1
    10 MPJ-450-GLSYSTEM-NOT-FOUND
    11 MPJ-450A-GLSYSTEM-SW 1
    12 MPJ-450A-GLSYSTEM-NOT-FOUND
    13 MPJ-450-CREATE-GLCLSAUDIT
    14 MPJ-450-GCA-COMPANY XXXX
    15 MPJ-450-STORE-GLCLSAUDIT
    16 File PROD/GLCLSAUDIT.
    17 tsStoreDBRec error is Bad data in field(s) (82).
    18 Additional information is 1722.
    19 Additional Text is:
    20 StoreSqlRec(LAWPROD."GLCLSAUDIT")
    21 OCIStmtExecute() returned OCI_ERROR code 1722 parse offset 9240576 (
    22 ORA-01722: invalid number
    23 )
    John Henley
    Posts: 3353
      Usually this happens when a job was saved and then the screen definition changes so the parameters no longer map. Sometimes this happens in very subtle ways. Delete the job and re-enter the params and save as new job.
      Thanks for using the LawsonGuru.com forums!
      John
      Austin
      New Member
      Posts: 3
      New Member
        John,

        I appreciate you responding so quickly. We had actually done that 3x already (it's usually the first step Infor asks to be done). Each time it seems to result in the same issue. Thanks John