Understanding Subsection Joins

Subsection joins provide you with an alternative to creating new business views when existing business views do not meet your business requirement. You can use subsection joins to join two detail sections, each using a different business view, within a report template. This enables you to present additional data in the report using fields that are not included in a single business view.

The two subsection join sections are referred to as the parent section (generally accessing a master table) and the child section (generally accessing a secondary table). The parent section regulates the processing of the report. After each field in the parent section is processed, all of the corresponding records in the child section are processed.

See Understanding Report Processing.

Within a report template in Oracle's JD Edwards EnterpriseOne Report Design Aid (RDA), you can:

• Create subsection joins.

  Two methods are available for creating subsection joins.

  • Add the second detail section as a subsection join section.

  • Join two existing detail sections within a report template.

• Modify and sever subsection joins.

  After you create a subsection join, some modification might be required. For example, you can modify section and field properties for subsection join sections. You can also change the fields on which the sections are joined and sever the join between the two sections.

You can create a subsection join between two columnar sections, two group sections, or a columnar and a group section. The subsection join option is not available for tabular sections.

Subsection join reports take longer to process than a report using a joined table business view. For this reason, subsection joins are a great alternative to creating a custom business view when the report is not a frequently processed report.