0 Replies Latest reply: Aug 30, 2012 7:02 PM by 958483 RSS

    Po Accrual Reconciliation report

    958483
      Hi Sir

      Hope you are doing well and good.

      I am new to R12 PO. For my client in 11.5.10.2 they have customized Po Accrual Reconciliation report. I came to know that in R11 they use view:PO_ACCRUAL_RECONCILE_TEMP and temporary table used in that view is PO_ACCRUAL_RECONCILE_TEMP_ALL.

      Now we are migrating this report to R12 and the above view was obsolete synonym in R12.

      1) After checking thoroughly i came to that temporary table was replaced with CST_AP_PO_RECONCILIATION & CST_RECONCILIATION_SUMMARY in R12. And i am unable to found view:PO_ACCRUAL_RECONCILE_TEMP replacement in R12. Can you please help me in this regard.

      2) Using the two new tables:CST_AP_PO_
      RECONCILIATION & CST_RECONCILIATION_SUMMARY, can we modify the query to get the same output as like R11

      This is very very urgent request.

      Best Regards
      Mani