My Oracle Support Banner

Unable To Create Instance With Backdated Install Date ( Install Date earlier than Creation Date ) (Doc ID 1459314.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Install Base - Version 12.1.3 and later
Information in this document applies to any platform.


When attempting to manually create an Item Instance with Install Date earlier than Creation Date

the following error occurs.


The Instance Party Account id &IP_ACCOUNT_ID, provided does not exists in the Installed Base Party Accounts table% (ACTIVE_START_DATE=2012/MAY/01)

The issue can be reproduced at will with the following steps:

1. Installed Base Agent User >> Item Instance >> Item Instances >> Click on the 'Create button

2. Entered the following data to manually create an Instance

For example:
Item - Item A
Serial -  A0001
Party Number - 1005
Account Number - 1005
Site Number - 12212
Install Date - 2012/May/01 21:12:18
Creation Date - 2012/May/08 21:12:18
Any Flexfield value desired

3. Click on the 'Apply' button and Receive error message


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

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.