1 Reply Latest reply: Oct 23, 2013 3:30 PM by Hussein Sawwan-Oracle RSS

    How do we complete the PRE-UPGRADE PROGRAM ran in DBS 11i instance after upgrade to 12.1.3

    user558643

      Hello EBS specialists,


      We are in process of doing the R12.1 financial upgrade from 11i.

       

      I have just finished upgrading EBS 11i to 12.1.3 and there is some complain that some of the data is not in place. On the 11i instance I applied the necessary patches and executed the "SLA PRE-UPGRADE PROGRAM" successfull. What am I suppose to do in EBS 12.1.3 to ensure that all the historical data is converted after I executed the "SLA PRE-UPGRADE PROGRAM" in 11i ?

       

      select application_id, set_of_books_id,

      min(start_date), max(end_date)

      from gl_period_statuses

      where migration_status_code = 'P'

      and adjustment_period_flag = 'N'

      group by application_id, set_of_books_id;

      APPLICATION_ID SET_OF_BOOKS_ID MIN(START MAX(END_D

      -------------- --------------- --------- ---------

      200 1001 01-JAN-04 31-DEC-13

      101 1001 01-JAN-04 31-DEC-13

      201 1001 01-JAN-04 31-DEC-13

      222 1001 01-JAN-04 31-DEC-13

      401 1001 01-JAN-04 31-DEC-13

      8721 1001 01-JAN-04 31-DEC-13

      6 rows selected.

       

      After upgrade, in 12.1.3

      select application_id, set_of_books_id,

      min(start_date), max(end_date)

      from gl_period_statuses

      where migration_status_code = 'U'

      and adjustment_period_flag = 'N'

      group by application_id, set_of_books_id;

       

      APPLICATION_ID SET_OF_BOOKS_ID MIN(START MAX(END_D

      -------------- --------------- --------- ---------

      201 1001 01-JAN-04 31-DEC-13

      222 1001 01-JAN-04 31-DEC-13

      8721 1001 01-JAN-04 31-DEC-13

      200 1001 01-JAN-04 31-DEC-13

      401 1001 01-JAN-04 31-DEC-13

      5 rows selected.

      From above, the results is short of one row after upgrade:

      101 1001 01-JAN-04 31-DEC-13


      Why do I get 5 rows instead of 6 in 12i? Could this be the problem? Am I suppose t run some program (SLA post Upgrade)  or scripts to complete the upgrade?


      Thanks

      Mathias