• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
  • New? Start Here
  • About Us
  • Hire me
  • Contact Us

Logical view of the data model in R12.2

August 7, 2015 by techgoeasy Leave a Comment

Logical view of the data model in R12.2

1) All the code should access the tables through APPS synonym

2) Editioning view are created over physical tables and APPS synonym are created to editioning view as shown in below figure

WF_ITEMS: Physical table

WF_ITEMS#: Editioning view

APPS.WF_ITEMS : APPS synonym to Editioning views

3)  All the custom code should access the apps synonym only else it risks seeing the old data

4) Existing column are never changes in R12, Data model changes are implemented using new column.

Suppose we change to column from 20 characters to 50 characters. Then new column having 50 character is created

5) Running application does not see the new column added as it referencing the table through editioning views.

Logical view of the data model

The above logical model has been implemented  to achieve Online patching in R12.2 . We should not be writing custom mode which directly accesses the table as then user may be seeing wrong data.

Hope you understand the flow of Logical view of the data model in R12.2. Please do provide the feedback

Related articles

forward cross edition triggers R12.2

Handling of seed data in R12.2 online patching

R12.2 Edition determination and setup

R12.2 Online Patching Readiness Report

 

Filed Under: Oracle Tagged With: oracle, R12.2

Reader Interactions

Leave a Reply Cancel reply

Primary Sidebar

Top Posts & Pages

  • Top 40 oracle dba interview questions and answers
  • Oracle Indexes and types of indexes in oracle with example
  • 40 Important Weblogic Interview questions
  • Top 30 Most Useful Concurrent Manager Queries
  • 21 awk command in Unix/Linux




Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • Top 40 Oracle RAC interview Questions
  • How to change date format in oracle database
  • How to Create SSH Tunneling or Port Forwarding in Linux to connect with Oracle database on Cloud
  • How to give oracle kill own session privilege to Developers
  • How to download Patch from Oracle using Wget

ORA-errors

  1. ORA-06512
  2. ORA-00911
  3. ORA-03113
  4. ORA-29913
  5. ORA-00257
  6. ORA-00054
  7. ORA-27154
  8. ORA-29285
  9. ORA-29280
  10. ORA-29283
  11. ORA-01017
  12. ORA-00900
  13. ORA-00001
  14. ORA-00936
  • Privacy Policy

Copyright © 2019 : TechGoEasy