My Oracle Support Banner

E1: 74H: R7430030 ( Legal Document Print Process) Ends in Error (Fetch from table F0018 failed) When It Runs For Hungary Localization (Doc ID 2436013.1)

Last updated on AUGUST 16, 2018

Applies to:

JD Edwards EnterpriseOne Sales Order Processing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

After an invoice is created in F03B11 for a sales order, the UBE R7430030 Legal Document Print Process - COMM - 03B is run to generate the electronic document in accordance with Hungarian Localization.
R7430030 crashes with an error related to fetch from tax table F0018.

Steps to replicate
---------------------
1.Activate the Hungary localization at the User Profile. Sign out . Sign in.
2.Set H1 as Legal Document Type in P7400002 (Legal Document Type) application .
3.Set in P7400003, the relation between Doc. Type <RI> and Hungarian Legal Doc. Type <H1> .
4.Set P7430021 Print Template Definition for Invoice
5.Set in P7430023, the relation between invoice template and Hungarian Legal Doc. Type.
6.Set in P7400004, Issue place for Hungarian localization
7.Set in P7400001 Next legal doc. Number for Hungarian legal doc. Type <H1> .
8.Set in P7430024, the relation between Hungarian legal doc <H1> and UBE R7430040 (Print Legal Document - COMM - 03B)
9.Place a sales order P4210
10.Run the classic Print Pick Slip R42520 for the order .
11.Shipment Confirmation P4205 for the order.
12.Run Print invoice R42565. Print invoice R42565 call R7430040 Print Legal Document for Hungary localization .
13. Run Sales Update for the order .
14. Post the batch for the order.
This invoice is into F03B11 and the GL post processed is into F0018.
15. Run R7430030. It ends in error: Fetch from table F0018 failed.
It seems like the process is trying to find line number 0 (TDLNID = 0.000000) for the invoice but there is not LIND = 0 for any invoice in F0018.


R7430030 should run successfully for sales order invoice in Hungary Localization Application as well.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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