There are no questions along with this diagnostics  so I took a look at the output and following are my findings.

This is a completed CM that was posted in NOV-2014.  The CM is applied to invoice and is closed.  I see no issues with the CM in AR.

I took a look at the XLA tables and there is no XLA information on this CM and that means that this is an upgraded CM where SLA upgrade has not  been completed.

So I assume the question is regarding upgrade on the item.

You can complete Upgrade by either running the Hotpatch upgraded or SLA: Upgrade Historical Subledger Transaction Accounting Program (XLAONDEUPG) (Doc ID 1376752.1).

Regards,

Hanne

DO you think we can run the SLA Hot patch, since the default upgrade of 6 months of data does not exist.

Yes you can run the Hotpatch and be sure to set SLA: Initial Date for Historical Upgrade profile option.

Thanks

Hanne

But what should be the initia date that needs to be set, since

 

SELECT * FROM XLA_UPGRADE_DATES

THIS table has no data,

It is not up to Oracle to determine what the initial date should be for your upgrade, you need to decide how far back you would like to upgrade.  I do recommend starting with a later date so less data is upgraded each time due to performance issues, say you start with 01-JAN-2014 and ugrade all of 2014, then go back and do same for 2013 and so on.

Thanks

Hanne

For Receivables you can run following to see if anything has been upgraded:

SELECT  application_id, min(start_date)

FROM     gl_period_statuses

WHERE   migration_status_code = 'U'

AND      application_id in (222)

group by application_id;

If nothing comes back then nothing was upgraded and you can run Hotpatch.  But even if the last 6 months were upgraded and you run the hotpatch for the last year, then upgrade will only be done to up to the date were upgrade was already completed. Based on what I have reviewed for you so far, nothing in Receivables seems to be upgraded to SLA.

Thanks

Hanne