When Two Sets of Multiple Sheets (Summary and Detail) are configured on Excel Template, Only One has Multiple Sheets on The Generated Report. (Doc ID 2696854.1)

Last updated on AUGUST 09, 2020

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Using Excel Template, there is a requirement to create two sets of multiple tabs (sheets). One for "Summary" (Summary1, Summary2, Summary3) and another for "Detail" (Detail1, Detail2, Detail3).
When just one of them is configured for multiple sheets, it works fine. When both of them are configured for multiple sheets, only one of them works then another has everything on one sheet.
- Summary1, Summary2, Summary, Detail
or
- Summary, Detail1, Detail2, Detail3


EXPECTED BEHAVIOR
-----------------------
Both "Summary" and "Detail" should have multiple sheets. (Summary1, Summary2, Summary3, Detail1, Detail2, Detail3)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an Excel template.
2. On the XDO_METADATA sheet, set the followings.

XDO_SHEET_? <?.//On_Address_Number_S29?>
XDO_SHEET_NAME_? <?.//AddressNumber_ID5?> <?Summary?>

XDO_SHEET_? <?.//On_Business_Unit_S36?>
XDO_SHEET_NAME_? <?.//_5_Job_Number_No_Spaces_ID50?> <?Detail?>

3. Run the report.
4. Generated report has multiple sheets for "Detail" only.

Changes

Cause

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