June 23, 2011

Table Changes in R12

po_accrual_reconcile_temp_all:- is a temp table in 11i will get populated while running the Accrual Reconciliation report.

In R12 it has been defined as CST_AP_PO_RECONCILIATION,CST_RECONCILIATION_SUMMARY tables...

Kindly leave your comments on this..? if we are using the report in R12 after migartion????

4 comments:

  1. About Changes done in R12 (version 12.1.3) Tables.we have customized Accrual Reconciliation report in 11i.In that report the above metioned temp tables are used.

    Now we are migrating the 11i custom report to R12 Instance..We do face this issue...?

    Do we have any new concept for this report in R12 Instances?

    ReplyDelete
    Replies
    1. Hi Meera

      We are facing now upgrading to r12. Can i have solution if you found it out

      Best Regards
      Mai

      Delete
    2. Created a temp table with same data structure.

      Delete

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

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...