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 01, 2022
Applies to:
JD Edwards EnterpriseOne Address Book - Version 9.2 and laterInformation 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 |