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 No comments:
Labels:
Subscribe to: Posts (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 ...
  • Interview FAQ's-Oracle Apps Technical and Oracle forms
    Oracle Applications Architecture -           Internet computing Architecture is a framework for 3-tired, distributed computing that ...
  • HRMS API with tables
    Converstion API Table Organization hr_organization_api.create_hr_organization hr_all_organization...