Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

UBE has Data Sequencing defined but the report does not sort according to sequencing

edited Aug 5, 2019 5:07AM in Design Tools & Output Technologies - JDE1 (MOSC) 4 commentsAnswered

We have a custom UBE report uses a custom view which joining F0092 and F0101. It is developed in 9.1 and merged to 9.2 during upgrade spec merge.

The report has Data Sequencing defined that sorts by F0101.AC24 ASC and then F0092.USER ASC. It runs correctly in 9.1 but not in 9.2. The report results seems correct but are not sorted by this order. The Execution Detail > SQL Statement shows even wrong table which the view should be fetching. Any idea what could be the possible cause(s)?

9.1 Execution Detail

Data Sequencing:

CategoryCodeAddressBk24 (F0101)(AC24)  ASCENDING

UserId (F0092)(USER)  ASCENDING

SQL Statement:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

E1 Tools & Output Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center