R12 Sub Ledger Upgrade Note

We upgraded to R12.1.3 in July of 2011.  We have since been running the XLA upgrade hotpatch (5584908) in batches of fiscal years.  Our data goes back to 1995.  Don't ask why, it just does.  We found an interesting anomally that I want to share with the community.  After we ran the last batch back to FY2003 we found that when we queried the XLA_AE_HEADERS tables for counts of records based on the period names for records that related to PA transactions we were getting counts that didn't match counts that we would get from querying PA tables.

What I found was that there were a lot of records in the XLA_AE_HEADERS table starting with July 2003 and earlier that had NULL value in teh PERIOD_NAME column.  Oracle Support and Development said that the  XLA upgrade script copies the value in the GL_PERIOD_NAME column of the PA CDL table and puts it in PERIOD_NAME column of the XLA_AE_HEADER table.  We then found that the values for PA_PERIOD_NAME and the GL_PERIOD_NAME columns in the PA_COST_DISTRIBUTION_LINES_ALL and PA_DRAFT_REVENUES_ALL tables were NULL.  With Oracle Development we created a data fix script to populate these columns and and the PERIOD_NAME in the XLA_AE_HEADERS table.