Install Base and Asset Tracking - EBS (MOSC)

MOSC Banner

Update Instance Status to Expired

edited Sep 19, 2019 5:05AM in Install Base and Asset Tracking - EBS (MOSC) 2 commentsAnswered

We are using below script to update the Instance status to 'Expired' instead of through Update API.

Steps:

These instances are created through data migration using Csi_item_instance_pub.Create_item_instance  API.

1. First we are creating instances in 'Latest' status

2. Updating instance status to 'Expired' using update script.

Update Script:

UPDATE  Csi.Csi_item_instances

   SET  Instance_status_id = 1 --EXPIRED

WHERE  1 = 1

    AND Instance_id = 30652

Please suggest.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center