My Oracle Support Banner

E1: SEC: Receive Errors "Fetch from table F0006 failed" and "Account Number is .. Invalid" in P0411 After Implementing Row Security on MCU (Doc ID 2698650.1)

Last updated on JULY 07, 2021

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
JD Edwards EnterpriseOne Accounts Payable - Version 9.2 and later
Information in this document applies to any platform.


After implementing row security to prevent users from viewing certain information from a range of Business Units (MCU), while entering a voucher in P0411 the following error appears on screen:

Fetch from table F0006 failed
A form level error has occurred.
CAUSE: The record to be fetched from table F0006 does not exist or you
               do not have authority to fetch records from this table.
RESOLUTION: Verify that the record being fetched exists and that you have
               proper authority.  Check the JDE.LOG and JDEDEBUG.LOG for
               additional information.
Account Number .. is Invalid 
A form level error has occurred.
CAUSE: .. does not exist in the Account Master file (F0901) NOTE:
               If you get this error message on a discount amount, it is
               indicating that the account numbers set up in the Automatic
               Accounting Instructions are invalid.  The AAI records being
               validated against are PKD/PKL for Accounts Payable and RKD for
               Accounts Receivable.  If business unit is not defined in the
               AAI accounts, the program will use the business unit from the
               voucher/invoice.  If the error message is on adjustment reason
               in cash receipts, the same holds true about the AAI account
               number being invalid for the adjustment reason entered. If you
               get this error message on a job being closed, it is indicating
               that the AAI account JCPB (Prior Year End Balance in Closed
               Jobs), JCR (Job Revenue),or JCC (Job Costs) is not set up.
RESOLUTION. .  Enter the correct account number.



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

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