Fusion Applications - BI Publisher - RESET AT LEVEL (Reset Repetitive Sequence Number) Do Not Work In ETEXT Template
(Doc ID 2532605.1)
Last updated on FEBRUARY 18, 2020
Applies to:
Oracle Fusion Global Human Resources Cloud Service - Version 11.13.18.10.0 and laterInformation in this document applies to any platform.
Symptoms
BI Publisher Template - Etext Template
Format Setup:
Hint: Define formatting options....
| <TEMPLATE TYPE> | DELIMITER_BASED |
| <OUTPUT CHARACTER SET> | iso-8859-1 |
| <NEW RECORD CHARACTER> | Carriage Return |
Sequence:
Hint: Define sequence generator
| <DEFINE SEQUENCE> | Seq_Details |
| <RESET AT LEVEL> | Person_Details |
| <START AT> | 1 |
| <INCREMENT BASIS> | RECORD |
| <END DEFINE SEQUENCE> | Seq_Details |
| <LEVEL> | G_1 | |||
| <MAXIMUM LENGTH> | <FORMAT> | <DATA> | <TAG> | <COMMENTS> |
| <NEW RECORD> | New_Record | |||
| 1 | Alpha | 'H' | ||
| <LEVEL> | PERSON_DETAILS | |||
| <NEW RECORD> | New_Record1 | |||
| <LEVEL> | Dependent_Details | |||
| <NEW RECORD> | New_Record2 | |||
| 2 | Alpha | SEQUENCE_NUMBER(Seq_Details) | ||
| <END LEVEL> | Dependent_Details | |||
| <END LEVEL> | PERSON_DETAILS | |||
| <END LEVEL> | G_1 | |||
Actual Behavior
<RESET AT LEVEL> is not resetting at Dependent_Details.
Prints Below Output
1
2
3
4
5
6
Expected Behavior
The sequence should reset at Dependent_Details for the required set based on the data in Sample XML
Should Print the Below Output
1
2
3
1
2
1
2
3
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 |