Page 1 of 2 1 2 LastLast
Results 1 to 10 of 12

Thread: Batch Error

  1. #1
    Member
    Join Date
    Jan 2012
    Location
    Kerala, India
    Posts
    660

    Batch Error

    I have voided two payment batches and while posting I'm receiving the attached errors, which do not give a specific error, it says "record invalid"

    No F0911 records exist in this Batch.
    Error: Batch 528481 M In Error.
    Error: Payment 00242325 16966 18112103 In Error.
    Error: Record Invalid
    One or more batches had errors.
    Attached Images Attached Images
    RAUF MUHAMMED K
    JDE Professional
    JDE E1 8.12 | TR 8.96.40 | Windows XP SP 3
    http://www.raufnicole.com

  2. #2
    Senior Member peterbruce's Avatar
    Join Date
    Jan 2004
    Location
    NSW Australia
    Posts
    2,134
    Rauf,

    Was there a R09801E produced? Was there anything in the work centre?
    Thanks, Peter

    "Give a person a fish, feed them for a day, teach them how to fish, feed them for a lifetime."

    E9.1 TR9.1.2.1, Enterprise Server: Sun, Database Server: Sun, Oracle DB: 11g, Weblogic.
    Create!form 7

  3. #3
    Member
    Join Date
    Jan 2012
    Location
    Kerala, India
    Posts
    660
    Hi Peter,

    R09801E is generated with a blank page.
    I have attached the work center message too, but there is also no clue. It just says "Record Invalid"

    I thought it was due to security. But I tried with SYSADMIN and still getting the same issue.
    RAUF MUHAMMED K
    JDE Professional
    JDE E1 8.12 | TR 8.96.40 | Windows XP SP 3
    http://www.raufnicole.com

  4. #4
    Member
    Join Date
    Jan 2012
    Location
    Kerala, India
    Posts
    660
    Hi Peter,

    Some technical information,

    In an initial debugging, I have found the error is set by F0911 Write Cash Account business function.
    I'm continuing to find out more.
    RAUF MUHAMMED K
    JDE Professional
    JDE E1 8.12 | TR 8.96.40 | Windows XP SP 3
    http://www.raufnicole.com

  5. #5
    Member
    Join Date
    Jan 2012
    Location
    Kerala, India
    Posts
    660
    Hi Peter,

    The Oracle document have some clue too. But we don't have access to support right now.

    E1: 04: Payment Batch Error: No F0911
    Records Exist in This Batch (Doc ID
    2250475.1)
    Last updated on MARCH 31, 2017
    APPLIES TO:
    JD Edwards EnterpriseOne Accounts Payable - Version
    9.1 and later
    Information in this document applies to any platform.
    SYMPTOMS
    A payment batch may fail due to an AP PrePayment
    BSFN function (B000062) comparing the corresponding
    paid voucher (F0411) table data and payment voucher
    (F0414) table data by the follow fields: DOC, DCT, KCO,
    SFX and SFXE. If there is a failure to match any one of
    the fields the following error (error number 0002) will
    occur on the R09801E error report: 'No F0911 Records
    exist in this Batch'. In addition, the work center
    message displays a message 'Payment 0 0 in Error'
    *
    Change the error messaging to provide a better error
    description to help the user to determine and quickly
    correct the matching process so that the payment batch
    can post.
    RAUF MUHAMMED K
    JDE Professional
    JDE E1 8.12 | TR 8.96.40 | Windows XP SP 3
    http://www.raufnicole.com

  6. #6
    Member
    Join Date
    Jan 2012
    Location
    Kerala, India
    Posts
    660
    Hi Peter,

    I also compared the F0411 and F0414 and I could get two records, so it is matching with all the 5 fields.

    Code:
    select * from proddta.f0411
    join proddta.f0414 
    on RPDOC = RNDOC
    and RPDCT = RNDCT
    and RPKCO = RNKCO
    and RPSFX = RNSFX
    and RPSFXE = RNSFXE
    where RPDOC = 187
    RAUF MUHAMMED K
    JDE Professional
    JDE E1 8.12 | TR 8.96.40 | Windows XP SP 3
    http://www.raufnicole.com

  7. #7
    Senior Member peterbruce's Avatar
    Join Date
    Jan 2004
    Location
    NSW Australia
    Posts
    2,134
    Rauf,

    I have just returned from the end-of-year break.

    Did the void create all the appropriate lines? When the payments were voided, were the vouchers voided too?
    Thanks, Peter

    "Give a person a fish, feed them for a day, teach them how to fish, feed them for a lifetime."

    E9.1 TR9.1.2.1, Enterprise Server: Sun, Database Server: Sun, Oracle DB: 11g, Weblogic.
    Create!form 7

  8. #8
    Member
    Join Date
    Jan 2012
    Location
    Kerala, India
    Posts
    660
    Hi Peter.

    Welcome back.

    We were also in year-end hassle, that is why we caught this batch in our analysis. The void created proper entries in the payment module, and also the voucher were voided.

    As we had no time to spend on this during year-end process, we just replicated the payment entry and void operation in the test environment. Then removed all entries of the said batch from production. Copied the test environment entries to production and posted. It worked very well. We also re-posted the affected accounts to ensure the balance is correct.
    RAUF MUHAMMED K
    JDE Professional
    JDE E1 8.12 | TR 8.96.40 | Windows XP SP 3
    http://www.raufnicole.com

  9. #9
    Member
    Join Date
    Jan 2012
    Location
    Kerala, India
    Posts
    660
    Hi Peter,

    The issue is recurring now.
    And it happens from the same user and for same supplier.

    I'm trying to find the root cause. It's very hard to replicate all the batches in test.
    I guess it is something related with security. But your valuable suggestions are welcomed.
    RAUF MUHAMMED K
    JDE Professional
    JDE E1 8.12 | TR 8.96.40 | Windows XP SP 3
    http://www.raufnicole.com

  10. #10
    Senior Member peterbruce's Avatar
    Join Date
    Jan 2004
    Location
    NSW Australia
    Posts
    2,134
    Rauf,

    Are the vouchers involved related to purchase orders?
    Thanks, Peter

    "Give a person a fish, feed them for a day, teach them how to fish, feed them for a lifetime."

    E9.1 TR9.1.2.1, Enterprise Server: Sun, Database Server: Sun, Oracle DB: 11g, Weblogic.
    Create!form 7

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.