/* Formatted on 2012/05/24 12:16 (Formatter Plus v4.8.8) */
DECLARE
x NUMBER;
CURSOR c1
IS
SELECT user_name, user_id
FROM fnd_user
WHERE user_id IN
(2522, 2584, 2286, 3430, 4067, 4193, 2360, 4171, 3896, 1818,
2544, 2533, 1165, 1569, 1571, 2416, 2649, 3136, 2620, 5682,
2872, 1210, 2912, 1384, 2514, 2540, 5382, 3322, 1313, 2735,
1389, 1719, 2671, 2321, 4451, 4151, 3429, 5762, 5662, 2437,
2290, 2436, 2498, 2419, 2580, 1010, 3995, 4172, 2784, 4552,
2412, 2318, 1839, 2481, 2483, 2313, 1390, 3990, 2602, 3997,
2851, 4456, 4300, 2489, 1977, 2017, 2018, 5130, 4654, 5279,
5522, 2876, 4148, 2840, 2398, 2179, 2357, 2524, 3034, 2675,
1796, 4365, 2623, 1841, 4026, 5174, 2410, 1493, 1492, 1491,
1490, 1620, 1621, 2277, 4301, 3977, 3590, 3199, 1183, 2260,
2465, 2753, 3202, 2608, 4000, 5320, 2534, 2507, 4815, 2607,
2933, 2307, 4736, 3174, 3937, 2890, 5220, 2601, 2508, 3434,
1669, 2340, 1160, 2510, 3894, 2509, 1195, 2309, 3898, 1172,
4859, 1418, 2515, 4695, 5422, 5088, 3074, 3913, 1009, 1008,
2777, 4152, 2344, 1013, 1012, 1937, 3425, 2757, 4674, 2771,
1594, 1595, 5259, 4347, 5542, 2305, 2291, 2535, 3198, 2355,
5239, 3469, 2467, 1284, 1957, 2358, 1648, 1649, 2266, 2249,
4532, 5196, 4714, 4386, 1141, 4169, 2384, 2241, 2606, 2774,
4068, 2468, 5217, 4066, 2302, 2755, 2270, 3916, 1185, 1176,
1259, 2611, 5281, 2572, 3988, 4472, 2479, 2411, 5460, 5129,
1170, 1164, 2354, 2256, 4492, 1512, 4634, 5221, 3751, 5300,
1187, 3261, 2141, 2325, 4961, 2758, 4454, 2617, 2622, 2873,
2528, 2624, 2633, 1623, 1624, 3428, 2557, 3014, 2493, 3016,
1169, 2387, 2369, 2836, 5216, 2263, 2314, 2835, 1239, 2596,
2676, 5401, 1154, 2376, 1395, 2292, 2590, 2597, 5046, 2841,
2750, 2331, 2589, 2595, 2571, 2461, 2362, 4257, 5002, 1715,
4363, 2932, 2631, 1319, 3651, 1112, 3472, 1711, 2177, 3491,
4237, 2677, 2322, 1191, 2621, 2303, 1216, 1917, 5154, 2795,
1781, 3989, 1347, 2775, 5502, 2284, 4614, 3015, 2577, 1396,
2367, 2770, 2381, 2603, 5218, 2272, 2440, 4345, 5260, 1148,
4346, 4429, 2549, 2265, 3987, 3235, 2752, 2393, 3181, 2471,
1718, 2605, 5642, 1619, 1157, 4410, 2530, 3214, 2538, 4876,
2448, 2432, 2733, 2330, 2878, 1159, 3652, 2769, 2751, 4959,
2261, 2138, 2388, 4406, 2377, 2057, 1714, 5003, 1211, 5299,
1242, 2504, 2581, 3405, 1432, 1385, 1150, 1757, 2594, 2403,
4407, 2574, 2674, 1294, 2327, 2059, 4411, 4457, 3570, 2673,
3447, 2294, 2474, 2567, 1194, 2838, 2555, 4342, 1113, 5340,
2793, 4633, 3431, 4214, 1753, 2477, 3999, 2454, 3234, 2599,
2337, 2257, 3096, 2276, 3983, 2593, 1423, 4006, 4007, 1219,
1011, 1568, 1570, 1565, 1567, 1562, 1563, 1574, 1575, 1449,
1448, 5742, 5622, 5702, 5603, 5602, 5623, 5604, 1419, 1420,
1838, 1188, 1519, 1518, 1189, 1429, 1428, 1424, 1576, 1577,
1517, 5151, 5006, 1559, 1558, 1495, 1494, 1468, 1469, 1572,
1573, 3194, 2366, 2060, 1939, 4857, 2798, 1421, 1422, 1497,
1496, 2460, 2444, 2425, 1564, 1566, 1509, 1508, 2335, 1561,
1560, 1515, 1514, 5380, 3195, 2815, 1713, 4960, 2275, 3367,
1314, 2782, 3897, 4572, 2781, 2392, 2954, 5087, 3076, 2879,
2779, 2501, 1760, 2995, 4001, 2364, 2297, 2041, 2842, 3017,
1616, 1840, 4086, 4919, 2299, 1208, 5109, 4734, 2797, 3488,
3178, 4362, 2521, 3530, 5195, 3991, 2421, 2346, 4449, 4147,
2604, 1180, 4858, 5066, 4455, 2614, 2884, 1346, 2455, 3550,
1212, 4592, 2473, 3445, 2259, 3098, 1179, 2847, 3077, 1196,
1510, 1857, 1178, 2636, 4939, 2434, 2634, 2729, 1325, 2628,
2445, 5219, 2281, 2503, 1342, 2543, 2794, 3054, 3571, 5400,
2300, 2560, 4862, 2178, 2258, 2478, 5111, 2462, 2569, 2295,
1712, 1143, 1387, 2470, 5381, 1218, 2568, 3984, 3992, 2780,
2887, 2487, 4453, 4344, 5261, 2433, 1668, 2626, 2315, 1716,
5005, 3134, 3115, 4898, 2279, 3259, 3985, 1289, 3432, 1625,
1626, 1513, 2139, 2273, 2500, 4298, 2502, 2469, 2536, 2352,
2582, 2356, 3982, 3433, 4899, 1198, 2365, 1115, 1204, 1776,
2289, 2516, 4735, 2476, 2495, 3094, 4635, 2552, 3981, 1240,
3471, 3179, 1244, 1427, 1193, 2525, 2037, 2304, 2672, 2457,
2488, 4302, 2852, 2396, 5441, 1140, 2888, 2891, 2609, 2527,
2532, 4836, 2881, 3154, 2042, 3260, 4755, 2550, 2482, 1166,
2301, 4694, 3914, 1386, 4107, 2242, 3342, 2418, 2570, 2576,
2306, 5026, 4452, 4408, 4106, 2252, 3895, 3467, 2407, 4150,
3510, 2618, 4127, 4233, 4512, 4174, 2934, 1612, 2320, 5360,
2670, 2844, 2288, 3468, 2563, 1135, 3998, 4715, 3262, 2439,
4450, 2378, 2458, 2556, 2615, 2218, 3771, 2383, 2254, 5722,
3078, 2610, 3986, 2404, 2913, 3490, 2787, 1281, 5004, 4860,
4856, 4897, 1614, 3470, 2813, 2592, 2785, 2405, 3257, 2280,
2619, 4364, 2632, 1184, 1322, 3980, 2408, 2385, 2449, 2443,
2140, 2341, 1192, 2370, 1393, 4005, 2523, 2773, 3255, 2217,
1381, 3893, 2039, 1897, 3917, 4775, 2776, 4385, 3101, 4297,
2077, 1425, 5110, 2267, 2453, 3427, 1006, 2359, 4003, 2484,
2466, 2247, 4277, 5480, 5481, 4612, 4409, 2880, 2541, 4236,
1756, 2494, 4170, 2463, 3993, 2342, 2583, 4149, 4981, 3095,
2038, 4002, 5001, 5131, 1326, 5562, 1592, 1593, 5301, 1241,
3691, 2539, 2395, 5482, 1511, 3075, 5222, 1538, 2417, 1199,
2627, 2237, 2409, 2250, 5440, 1489, 1488, 2848, 4613, 4861,
4835, 1344, 5503, 5582, 2564, 2450, 2248, 2519, 1092, 5683,
2565, 3978, 2850, 2573, 4235, 3979, 2711, 2877, 2464, 4234,
5089, 4920, 5302, 2022, 2019, 2021, 2023, 2020, 2406, 1316,
4299, 1168, 2391, 2397, 2559, 2548, 1147, 2814, 5421, 2239,
1394, 2058, 1200, 2431, 1280, 2977, 1397, 2886, 2400, 2496,
2490, 3446, 2379, 3631, 2475, 5194, 3344, 1283, 1731, 2348,
4795, 2441, 2380, 1324, 1426, 1822, 2274, 3142, 4343, 1138,
3489, 2754, 4896, 4046, 1618, 1139, 2587, 2996, 2157, 3813,
2849, 2883, 7, 1156, 1181);
BEGIN
FOR x1 IN c1
LOOP
BEGIN
fnd_user_pkg.updateuser (x_user_name => x1.user_name,
x_owner => 'CUST',
x_end_date => SYSDATE
);
x := x + 1;
DBMS_OUTPUT.put_line ( 'User disabled , User Name: '
|| x1.user_name
|| ' User_id: '
|| x1.user_id
);
EXCEPTION
WHEN OTHERS
THEN
NULL;
END;
END LOOP;
DBMS_OUTPUT.put_line ('No of Users disabled : ' || x);
EXCEPTION
WHEN OTHERS
THEN
NULL;
END;
Instructions to Solve Oracle Database Error 1839 through Remote DBA Services
ReplyDeleteThe Oracle database mistake 1839 is connected with Oracle date arranges which does not coordinate the scene design. When you over and over attempt to enter a date esteem however you determined an invalid day esteem. To determine this issue you need to check your DD esteem and this esteem must be in the vicinity of 1 and the quantity of days in the month. I trust your concern will tackle yet of not then don't delay to contact Database Administration for Oracle or Online Oracle DB Support for brisk and solid help.
For More Info: https://cognegicsystems.com/
Contact Number: 1-800-450-8670
Email Address- info@cognegicsystems.com
Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801