| How to change the preserved flag status on a define set of CodeCombinationIDs [message #172728] |
Wed, 17 May 2006 15:35 |
smulukutla
Messages: 45
Registered: May 2006
|
Member |
|
|
Our company have multiple disabled account combinations, but the segment values for those are enabled. And those combinations are not set as preserved. Therefore if we run the Segment Inherit value program, some of the disabled account combinations may be reenabled. So over come this, we were told that we need to set the preserved flag for all those combinations to Yes. But there are 22,000 combinations like this, and we need to change manually all these combinations.
So Instead Oracle told us to run a script.
Logic of the script is:
If CCID is disabled
AND
ALL segment values are enabled,
then set CCID to preserved.
If you have any idea about this script please feel free to send me an email to sailaja.mulukutla@greenpoint.com
Thanks.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
