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 |