APCC - Total Supply & Total Demand Shows blank in the report:
--------------------------------------------------------------------------------
1: Validate the required tables used in the report is getting loaded from the source.
2: Analyse the physical sql of the report for Supply / demand and idenify the query root cause failure
3: If the Fact tables has the data for supply / demand analyse more on the filter criteria
4: Trace back from the Fact table to see how the data population and the dependent objects used by
5: Once the Root cause is found then refresh all the set of objects used to refresh the APCC tables
6: Challenges faced will be between the RBS SSO and OBIEE after serval Trial and Errors finally got it to work
7: RPD Changes for APCC 1: Disables and enabel few initiablock of Transaltion and SSO
8: Change the ocnnection pool and connection scripts for the Db to point to EBS Database.
9: Validate the Database and Database specific features on the RPD to make sure Required features are checked
10: Modify the Instanceconfig and autenicationschema.xml for the SSO to work and hand shake between OBIEE and EBS
11:set the Required profile in EBS for APCC and also the Server name of OBIEE in EBS for Profile.
12: Navitage from EBS supplychain analyst to OBIEE Reports and everyting works as normal and data is visible for Suppply and Demand
13: Challenges faced in finding the right focus area for debug in Database, OBIEE and EBS.
14: Errors Occured - ODBC errors for reports, function not getting called, packages mismatch, RPD database features, Config files, Init blocks etc.
--------------------------------------------------------------------------------
1: Validate the required tables used in the report is getting loaded from the source.
2: Analyse the physical sql of the report for Supply / demand and idenify the query root cause failure
3: If the Fact tables has the data for supply / demand analyse more on the filter criteria
4: Trace back from the Fact table to see how the data population and the dependent objects used by
5: Once the Root cause is found then refresh all the set of objects used to refresh the APCC tables
6: Challenges faced will be between the RBS SSO and OBIEE after serval Trial and Errors finally got it to work
7: RPD Changes for APCC 1: Disables and enabel few initiablock of Transaltion and SSO
8: Change the ocnnection pool and connection scripts for the Db to point to EBS Database.
9: Validate the Database and Database specific features on the RPD to make sure Required features are checked
10: Modify the Instanceconfig and autenicationschema.xml for the SSO to work and hand shake between OBIEE and EBS
11:set the Required profile in EBS for APCC and also the Server name of OBIEE in EBS for Profile.
12: Navitage from EBS supplychain analyst to OBIEE Reports and everyting works as normal and data is visible for Suppply and Demand
13: Challenges faced in finding the right focus area for debug in Database, OBIEE and EBS.
14: Errors Occured - ODBC errors for reports, function not getting called, packages mismatch, RPD database features, Config files, Init blocks etc.
