Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Custom Schema Returns stale data

Veerendra Kodalli6 days ago — edited 6 days ago

We have created XX_Data_V on Query which uses XX_PACKAGE1 to calculate amount.. XX_PACKAGE1 internally refers to XX_PACKAGE_INT … Below are steps we face issues,

XX_Data_V Editioning View created in apps schema and Grant/Synonym to Custom Schema

XX_PACKAGE1 created in APPS schema with Synonym in Custom Schema

Custom Schema:

Step1: INVALIDATE XX_PACKAGE_INT package..

Step2: Query XX_Data_V which results in wrong value say 100 because we handled exception in XX_PACKAGE1 and returned 100

Step3: Now make XX_PACKAGE_INT package VALID.

Step4: Query XX_Data_V which results in same 100 Value

APPS Schema:

Above behavior do not exist in APPS schema..

Comments
Post Details
Added 6 days ago
2 comments
63 views