Oracle Fusion AI Data Platform Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Inactive records in GL Account Hirearchy not filtering by status

Needs Votes
11
Views
0
Comments
Sreekumar_Analytics_Ambassador
Sreekumar_Analytics_Ambassador Rank 5 - Community Champion

In Source Fusion Apps ERP, Mayo has inactive records:

image.png

These in active records are filtered by Status in OTBI:

image.png

FAW is showing inactive records also, whereas customer is expecting it to be filtered by status column and show active records only.

image.png


Refer : SR 3-35856510781 : Inactive records in GL Account Hierarchy not filtering by status


The Business Case for this ER

Backup copies of the Oracle segment hierarchies are not currently being maintained and should not be used by end users. Any time that an end user is reporting on one of the segments that has a hierarchy they need to filter for the tree version ending in " C" otherwise data would be invalid. Eliminating the backup copies from FAW would eliminate this risk while also potentially improving FAW performance by removing unnecessary data.

3
3 votes

Needs Votes · Last Updated