Project

General

Profile

Task #19742

Task #19672: 暫定eSIM投入ツール

暫定eSIM対応：ES 付き USIM No. を正しい EID に変更する対応

translation missing: en.label_added_absolute_time_by. Updated 09/01/2023 ago.

Status:
Resolved
Priority:
Normal
Assignee:
Makoto Tanaka
Start date:
07/18/2023
Due date:
% Done:

0%

Type:
Category:

Description

誠さん

おつかれさまです。

表題の暫定 eSIM 対応の内、残対応となっていた EID の登録対応について、添付の通りリストをお送りいたします。
顧客番号、回線番号、EID の一覧となりますので、ご確認・登録をいただければと存じます。
また、事前にお伝えさせていただいている内容となりますが、
同一 EID かつ別回線番号の組みが 1 組ありますので、そちらについてもご留意ください。

加えて、本登録対応後、EID の登録を行った回線を持つ顧客について、
portal env マスタの simExchangeEnable の値を enable にし、
再発行を有効化していただきます様、お願いいたします。

対応完了に際しては、営業に連絡し、顧客へ通知する必要がありますので、ご連絡を頂けますと幸いです。
可能であれば、事前に対応完了予定日を追記いただけますと助かります。
　
　
お手数をおかけいたしますが、何卒、よろしくお願いいたします。

Partner_eSIM_20230718.csv View (5.8 KB) Shotaro Sugino, 07/18/2023 08:50 AM

History

#1 Updated by Seongmin Choi 09/01/2023 ago

  • Status changed from New to Resolved

CosmoとjppにES 付き USIM No.のEID対応を完了しました。

#2 Updated by Seongmin Choi 09/01/2023 ago 

BEGIN
CREATE VIEW
INFO:  1,(21903,07026805205,89049032005008882600051410579309)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07026805205, log_id=12738491
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  2,(22505,07028133145,89049032004008882600006716047082)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07028133145, log_id=12738492
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  3,(21394,07028207546,89049032007008882600125314662315)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07028207546, log_id=12738493
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  4,(21184,07028226836,89049032006008882600109618078134)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07028226836, log_id=12738494
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  5,(16787,07040274614,89049032007008882600118241334627)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07040274614, log_id=12738495
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  6,(21218,07040782537,89043051202200005222000500506391)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07040782537, log_id=12738496
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  7,(21266,07040895771,89049032007008882600124831020994)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07040895771, log_id=12738497
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  8,(21903,07040935422,89049032005008882600044293324104)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07040935422, log_id=12738498
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  9,(21759,07041962103,89049032006008882600068829137851)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07041962103, log_id=12738499
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  10,(20949,07042056601,89049032007008882600116290642123)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07042056601, log_id=12738500
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  11,(20995,07042071506,89049032004008882600013446882223)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07042071506, log_id=12738501
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  12,(21395,07042388607,89049032006008882600063277355267)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07042388607, log_id=12738502
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  13,(21395,07042388687,89049032007008882600092164111677)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07042388687, log_id=12738503
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  14,(22234,07043362165,89049032007008882600092235573226)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07043362165, log_id=12738504
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  15,(21759,07043456070,89049032005008882600048326817680)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07043456070, log_id=12738505
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  16,(21309,07043811302,89049032005008882600055173575775)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07043811302, log_id=12738506
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  17,(21325,07044207032,89049032000001000000117139002722)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07044207032, log_id=12738507
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  18,(22472,07044303697,89033023426120000000013712146174)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07044303697, log_id=12738508
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  19,(21830,07044807096,89049032007008882600124978840943)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07044807096, log_id=12738509
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  20,(22472,07044818802,89033023426120000000013712092921)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07044818802, log_id=12738510
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  21,(22015,07044839604,89049032007008882600091625518789)
NOTICE:  service_order_receipts got updated
NOTICE:  No line_profiles is updated
NOTICE:  service_order_requests_items got updated
INFO:  22,(21208,07044861426,89033023425110000000007218117783)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07044861426, log_id=12738511
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  23,(20833,07048104231,89033023425110000000007232037865)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07048104231, log_id=12738512
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  24,(21965,07048124322,89049032006008882600070553953342)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07048124322, log_id=12738513
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  25,(22792,08010369449,89033023427100000000009896020366)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08010369449, log_id=12738514
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  26,(22407,08010408411,89033023426100000000012570191107)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08010408411, log_id=12738515
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  27,(22837,08010873049,89049032006008882600105848196220)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08010873049, log_id=12738516
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  28,(21827,08011802666,89049032005008882600056980796743)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08011802666, log_id=12738517
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  29,(21266,08013523321,89049032007008882600124903232450)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08013523321, log_id=12738518
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  30,(20649,08014665529,89049032007008882600098852475174)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08014665529, log_id=12738519
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  31,(22265,08016515293,89049032007008882600093403825415)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08016515293, log_id=12738520
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  32,(22704,08019811164,89049032007008882600127492311733)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08019811164, log_id=12738521
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  33,(22369,08020422081,89049032005008882600044647246743)
NOTICE:  service_order_receipts got updated
NOTICE:  No line_profiles is updated
NOTICE:  service_order_requests_items got updated
INFO:  34,(22064,08020748013,89049032005008882600057720094271)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08020748013, log_id=12738522
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  35,(22472,08020776066,89033023426120000000015081054212)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08020776066, log_id=12738523
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  36,(22111,08021527344,89049032006008882600062845290980)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08021527344, log_id=12738524
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  37,(22529,08023037454,89033023425110000000007025719059)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08023037454, log_id=12738525
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  38,(20949,08023731352,89049032007008882600118901599077)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08023731352, log_id=12738526
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  39,(21363,08023932415,89049032007008882600116058010612)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08023932415, log_id=12738527
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  40,(21184,08023993231,89049032006008882600105056464275)
NOTICE:  service_order_receipts got updated
NOTICE:  No line_profiles is updated
NOTICE:  service_order_requests_items got updated
INFO:  41,(20902,08025726341,89049032006008882600112334202488)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08025726341, log_id=12738528
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  42,(22505,08025874471,89049032005008882600049504237727)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08025874471, log_id=12738529
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  43,(22111,08025999128,89049032005008882600056349542374)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08025999128, log_id=12738530
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  44,(21759,08026701236,89049032004008882600016344705910)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08026701236, log_id=12738531
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  45,(21759,08026701271,89049032005008882600053999259825)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08026701271, log_id=12738532
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  46,(21992,08028954014,89033023426100000000012640405042)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08028954014, log_id=12738533
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  47,(21992,08028957669,89033023426100000000001827194339)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08028957669, log_id=12738534
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  48,(22885,08043613222,89033023427100000000010816674914)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08043613222, log_id=12738535
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  49,(22824,08060125035,89049032005008882600036253766321)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08060125035, log_id=12738536
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  50,(22476,08061280796,89043051202200005221004031494815)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08061280796, log_id=12738537
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  51,(21725,08069605826,89049032005008882600047526757897)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08069605826, log_id=12738538
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  52,(21680,08074367799,89049032007008882600090000566835)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08074367799, log_id=12738539
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  53,(21266,08077147745,89049032007008882600124831236043)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08077147745, log_id=12738540
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  54,(21266,08077148067,89049032007008882600124905075159)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08077148067, log_id=12738541
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  55,(21672,08078174365,89043051202200005222001315420075)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08078174365, log_id=12738542
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  56,(21120,08078584037,89049032007008882600118343104020)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08078584037, log_id=12738543
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  57,(22111,08078935560,89049032007008882600125151496772)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08078935560, log_id=12738544
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  58,(16224,08080199294,89049032007008882600090255997323)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08080199294, log_id=12738545
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  59,(21903,08080296284,89049032005008882600040820102043)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08080296284, log_id=12738546
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  60,(21903,08080296401,89049032005008882600033419266077)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08080296401, log_id=12738547
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  61,(21266,08081294119,89049032007008882600124904913751)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08081294119, log_id=12738548
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  62,(22282,08082101321,89033023426100000000012713527910)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08082101321, log_id=12738549
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  63,(22293,08082133077,89049032006008882600101243242276)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08082133077, log_id=12738550
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  64,(21184,08084255027,89049032005008882600049298386170)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08084255027, log_id=12738551
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  65,(21184,08084255114,89049032007008882600098469137479)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08084255114, log_id=12738552
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  66,(21184,08084255141,89049032007108882600136217949667)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08084255141, log_id=12738553
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  67,(22186,08084794065,89049032007008882600119004603959)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08084794065, log_id=12738554
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  68,(21266,08084930809,89049032007008882600124948115417)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08084930809, log_id=12738555
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  69,(21307,08087315343,89049032006008882600104869691066)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08087315343, log_id=12738556
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  70,(21184,08087405468,89033023426200000000006023165170)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08087405468, log_id=12738557
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  71,(22628,08087567186,89049032000001000000045180822646)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08087567186, log_id=12738558
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  72,(20914,08087644086,89049032005008882600058418919713)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08087644086, log_id=12738559
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  73,(19893,08088375114,89033023426120000000013367973102)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08088375114, log_id=12738560
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  74,(21395,08088413667,89049032006008882600115093018676)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08088413667, log_id=12738561
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  75,(16543,08088644163,89049032007008882600125657224605)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08088644163, log_id=12738562
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  76,(22064,08092786594,89049032005008882600048672856159)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08092786594, log_id=12738563
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  77,(20669,08095121117,89033023427100000000008485830486)
NOTICE:  service_order_receipts got updated
NOTICE:  No line_profiles is updated
NOTICE:  service_order_requests_items got updated
INFO:  78,(21830,08095463351,89049032007008882600124978840943)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08095463351, log_id=12738564
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  79,(20947,08095638031,89049032007108882600136331602045)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08095638031, log_id=12738565
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  80,(21830,08095659418,89049032007008882600098965926374)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08095659418, log_id=12738566
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  81,(22064,08095777566,89049032005008882600057627417658)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08095777566, log_id=12738567
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  82,(22015,08099934007,89043051202200005221003385223876)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08099934007, log_id=12738568
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  83,(22015,08099934346,89049032006008882600102696544582)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08099934346, log_id=12738569
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  84,(21748,09019762216,89049032006008882600111192765173)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09019762216, log_id=12738570
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  85,(21582,09022829621,89049032006008882600103046982981)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09022829621, log_id=12738571
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  86,(22369,09023696761,89049032006008882600115226307637)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09023696761, log_id=12738572
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  87,(21672,09024156398,89043051202200005222001313726843)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09024156398, log_id=12738573
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  88,(19980,09026787103,89033023427100000000008970218222)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09026787103, log_id=12738574
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  89,(16787,09027282847,89049032007008882600095953792261)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09027282847, log_id=12738575
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  90,(22407,09027627513,89033023426100000000001824935306)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09027627513, log_id=12738576
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  91,(22747,09030466121,89049032007108882600137101807556)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09030466121, log_id=12738577
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  92,(21993,09040766245,89049032007008882600088857320955)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09040766245, log_id=12738578
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  93,(22015,09041301074,89049032005008882600054756538922)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09041301074, log_id=12738579
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  94,(21032,09043761164,89049032006008882600110869671947)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09043761164, log_id=12738580
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  95,(21267,09043784294,89033023426120000000015499480105)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09043784294, log_id=12738581
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  96,(20616,09045826238,89049032007008882600118344219520)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09045826238, log_id=12738582
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  97,(22149,09048368135,89049032007008882600125722371551)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09048368135, log_id=12738583
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  98,(21273,09049455061,89049032004008882600004807584110)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09049455061, log_id=12738584
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  99,(19940,09049482747,89049032007108882600136562696397)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09049482747, log_id=12738585
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  100,(22570,09049598237,89049032007008882600125836344320)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09049598237, log_id=12738586
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  101,(21267,09052090186,89049032006008882600070056721642)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09052090186, log_id=12738587
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  102,(21032,09054951483,89049032006008882600109118822820)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09054951483, log_id=12738588
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  103,(21123,09055880181,89033023426100000000013119725498)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09055880181, log_id=12738589
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  104,(22015,09069492648,89033023427100000000008601140594)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09069492648, log_id=12738590
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  105,(20649,09070345633,89049032007008882600118866799454)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09070345633, log_id=12738591
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  106,(21266,09072106079,89049032007008882600124906431607)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09072106079, log_id=12738592
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  107,(22101,09072808641,89033023426120000000015497109425)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09072808641, log_id=12738593
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  108,(21992,09073607549,89033023424110000000000927529706)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09073607549, log_id=12738594
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  109,(19940,09078449575,89049032004008882600006106848379)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09078449575, log_id=12738595
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  110,(21185,09079087067,89033023426100000000012952964941)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09079087067, log_id=12738596
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  111,(21663,09079410175,89049032006008882600108856746571)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09079410175, log_id=12738597
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  112,(22476,09083492343,89033023426120000000015503579422)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09083492343, log_id=12738598
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  113,(21992,09090589984,89033023426100000000012637413562)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09090589984, log_id=12738599
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
INFO:  114,(22792,09097639463,89049032004008882600006450710081)
NOTICE:  service_order_receipts got updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=09097639463, log_id=12738600
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4' and ins_user like 'BULK-eSIM-ACT%'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  service_order_requests_items got updated
DO
DROP VIEW
COMMIT

BEGIN
CREATE VIEW
INFO:  1,(22015,07044839604,89049032007008882600091625518789)
NOTICE:  No service_order_receipts is updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=07044839604, log_id=12748065
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  No service_order_requests_items is updated
INFO:  2,(22369,08020422081,89049032005008882600044647246743)
NOTICE:  No service_order_receipts is updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08020422081, log_id=12748066
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  No service_order_requests_items is updated
INFO:  3,(21184,08023993231,89049032006008882600105056464275)
NOTICE:  No service_order_receipts is updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08023993231, log_id=12748067
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  No service_order_requests_items is updated
INFO:  4,(20669,08095121117,89033023427100000000008485830486)
NOTICE:  No service_order_receipts is updated
NOTICE:  provisioning.line_profiles UPDATE: phone_number=08095121117, log_id=12748068
CONTEXT:  SQL statement "update provisioning.line_profiles set psid = 'EID:'||v_row_data.usim_number, model_name = 'DCVSIM-E'
where phone_number = v_row_data.phone_number
and psid like 'ES%' and model_name = 'DCVSIM-4'"
PL/pgSQL function inline_code_block line 35 at SQL statement
NOTICE:  line_profiles got updated
NOTICE:  No service_order_requests_items is updated
DO
DROP VIEW
COMMIT

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 10 MB)