July 11, 2011

R12 Migration Check points:

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.......
at
Labels:

No comments:

Post a Comment

Thanks for your comments submitted.,will review and Post soon! by admin.

Subscribe to: Post Comments (Atom)

COALESCE-SQL

Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...

  • FND_CANONICAL
    In HRMS we do use date with timestamp for EIT ans SIT segments. To change the format od the date we can use fnd_date . canonical_to_date ...
  • HRMS API with tables
    Converstion API Table Organization hr_organization_api.create_hr_organization hr_all_organization...
  • Wip Move Transaction Migration
    WIP Migration: Create a job in Work in Process 1.        Create a job with item which is billable on and define routing sequence for the ...