Migrating a Report:
1.Check The model query for obsolete tables and view.
2. Replace the obsolete tables and view with corresponding joints.
3.Check the program units for the same as mentioned above.
4.Run the query in sql developer and verify the output in 11i and R12 Instances.
5.Recompile and load to location after changes and compare the application outputs.
Happy Reading !!!
Comments are invited.......
Oracle Technical Experience and Test Cases Shared from different resource and through self leanings.
Subscribe to:
Posts (Atom)
How I Identified 45 Configuration Gaps in an Oracle HCM Implementation — A Structured Approach
During a recent Oracle Fusion HCM implementation, I led a gap analysis that surfaced 45 configuration issues between the client's legacy...
-
While Registering the report to instance we need to make sure od date format: 1.The default type is YYYY/MM/DD HH24:MI:SS go to propert...
-
Order to cash normally refer to the process in which taking customer sale order via different sales channel like email, internet, sales pers...
-
This is easily done with the following command: select to_char(to_date('56789','J'),'JSP') from dual / TO_CHAR...