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:
BI Publisher (formerly XML Publisher) - Version 12.2 and laterInformation in this document applies to any platform.
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
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 |