My Oracle Support Banner

E1: 01: Request to Create a Report Listing Groups of Grandparent, Parent, and Child Address Book Records as Set Up in the Address Organization Structure Master table (F0150) (Doc ID 2826796.1)

Last updated on DECEMBER 07, 2021

Applies to:

JD Edwards EnterpriseOne Address Book - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Address Book (F0101) records can be set up as the parent or child of other A/B records in the Address Organization Structure Master (F0150) table. There can even be strings and groups of grandparent, parent, and child records.

Clients may have the need to show these lists or strings of A/B records on a report. For example if in the F0150 there is the following setup:

 

Parent

Child

10

20

20

22

20

23

22

24

22

25

23

26

 

The report that is needed would show the following:

 

Level 1

Level 2

Level 3

Level 4

10

20

 

 

 

20

22

 

 

 

22

24

 

 

22

25

 

20

23

 

 

 

23

26

 

Currently there is no report showing this kind of grouping per the information of the F0150 table. 

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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