My Oracle Support Banner

R12: CANNOT RUN THE SLA HOTPATCH DUE TO MIGRATION_STATUS_CODE='P' (Doc ID 1289186.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Payables - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

On 12.0.6
Unable to run SLA Hotpatch because there are lines in GL_PERIOD_STATUSES with migration_status_code='P'.

***

Please review Note 604893.1



Point #4. What are the different status codes in the GL_PERIOD STATUSES table?

The MIGRATION_STATUS_CODE column indicates the status of the record in the GL_PERIOD_STATUSES table.

* P = Pending Upgrade
The system is preparing to upgrade the accounting periods in this table that have a status P. The accounting transactions in these corresponding accounting periods will be upgraded from 11i to R12 by the Subledger products (i.e, AR, AP etc).
* U = Upgraded
The accounting records have been upgraded from 11i to R12
* N = New-Only used by GL
* <blank> = These records do not meet any of the criterion mentioned in Ques 6 and will therefore not be considered in the upgrade.

Point #13. Are there any restrictions when running the SLA Hot Patch?

Yes, there are some restrictions. They are as follows:

(b) You cannot run the SLA Hot Patch if any period is pending upgrade, even if it only affects one of many applications. See Ques 4 above for an explanation on the different status codes.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.