データベースGodizillaDB_STGに接続中です。
BEGIN: IN_SALES_YM=[2023/06], IN_FROM_WHERE=[1], IN_GROUP_ID=[20619]
STEP01: IN_GROUP_ID=[20619], num_COMPANY_ID=[29]
STEP02: dat_INVOICE_DATE=[2023-06-30]
STEP03: dat_RANGE_FROM/TO=[2023-06-01/2023-06-30]
STEP04: num_FINANCIAL_ID=[22282]
STEP05: UPDATE T_ORDER_DETAILS_ADDRESSES
STEP06-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[0]
STEP06-02: PKG_CREATE_MON_INVOICE:num_INVOICE_NUMBER=[15791611]
STEP06-04: PKG_CREATE_MON_INVOICE_DTL:num_INVOICE_NUMBER=[15791611], dtl.NETWORK_CONTRACT_ID=[19722], dtl.TRF_PRODUCT_CODE=[MS-LINEV-INI], dtl.QTY=[2], num_OUT_NUM=[-1], var_OUT_MSG=[起算日関連の情報取得に失敗しました。ORA-01403: no data found]
STEP06-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[15791611]
STEP06-04: PKG_CREATE_MON_INVOICE_DTL:num_INVOICE_NUMBER=[15791611], dtl.NETWORK_CONTRACT_ID=[19722], dtl.TRF_PRODUCT_CODE=[MS-LINEV-INI], dtl.QTY=[3], num_OUT_NUM=[-1], var_OUT_MSG=[起算日関連の情報取得に失敗しました。ORA-01403: no data found]
STEP06-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[15791611]
STEP06-04: PKG_CREATE_MON_INVOICE_DTL:num_INVOICE_NUMBER=[15791611], dtl.NETWORK_CONTRACT_ID=[19722], dtl.TRF_PRODUCT_CODE=[MS-LINEV-INI], dtl.QTY=[6], num_OUT_NUM=[-1], var_OUT_MSG=[起算日関連の情報取得に失敗しました。ORA-01403: no data found]
STEP06-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[15791611]
STEP06-04: PKG_CREATE_MON_INVOICE_DTL:num_INVOICE_NUMBER=[15791611], dtl.NETWORK_CONTRACT_ID=[19722], dtl.TRF_PRODUCT_CODE=[MS-LINEV-INI], dtl.QTY=[1], num_OUT_NUM=[-1], var_OUT_MSG=[起算日関連の情報取得に失敗しました。ORA-01403: no data found]
STEP06-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[15791611]
STEP06-04: PKG_CREATE_MON_INVOICE_DTL:num_INVOICE_NUMBER=[15791611], dtl.NETWORK_CONTRACT_ID=[19722], dtl.TRF_PRODUCT_CODE=[MS-LINEV-INI], dtl.QTY=[3], num_OUT_NUM=[-1], var_OUT_MSG=[起算日関連の情報取得に失敗しました。ORA-01403: no data found]
STEP06-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[15791611]
STEP06-04: PKG_CREATE_MON_INVOICE_DTL:num_INVOICE_NUMBER=[15791611], dtl.NETWORK_CONTRACT_ID=[19722], dtl.TRF_PRODUCT_CODE=[MS-LINEV-INI], dtl.QTY=[5], num_OUT_NUM=[-1], var_OUT_MSG=[起算日関連の情報取得に失敗しました。ORA-01403: no data found]
STEP06-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[15791611]
STEP06-04: PKG_CREATE_MON_INVOICE_DTL:num_INVOICE_NUMBER=[15791611], dtl.NETWORK_CONTRACT_ID=[19722], dtl.TRF_PRODUCT_CODE=[MS-LINEV-INI], dtl.QTY=[3], num_OUT_NUM=[-1], var_OUT_MSG=[起算日関連の情報取得に失敗しました。ORA-01403: no data found]
STEP07-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[0]
STEP07-02: PKG_CREATE_MON_INVOICE:num_INVOICE_NUMBER=[15791612]
STEP07-04: PKG_CREATE_MON_INVOICE_DTL:num_INVOICE_NUMBER=[15791612], fixdtl.NETWORK_CONTRACT_ID=[17392], fixdtl.TRF_PRODUCT_CODE=[MS-PORTAL-FEE], fixdtl.QTY=[1], num_OUT_NUM=[838070971], var_OUT_MSG=[請求明細情報生成に成功しました。]
STEP07-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[15791612]
STEP07-03: FIND-INVOICE-DTLS:num_LINE_NUMBER=[838070971], num_INV_DTL_QTY=[1]
STEP07-05: UPDATE-QTY:num_INVOICE_NUMBER=[15791612], num_LINE_NUMBER=[838070971], fixdtl.NETWORK_CONTRACT_ID=[17430], fixdtl.TRF_PRODUCT_CODE=[MS-PORTAL-FEE], fixdtl.QTY=[1]
STEP07-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[15791612]
STEP07-03: FIND-INVOICE-DTLS:num_LINE_NUMBER=[838070971], num_INV_DTL_QTY=[1]
STEP07-05: UPDATE-QTY:num_INVOICE_NUMBER=[15791612], num_LINE_NUMBER=[838070971], fixdtl.NETWORK_CONTRACT_ID=[17614], fixdtl.TRF_PRODUCT_CODE=[MS-PORTAL-FEE], fixdtl.QTY=[1]
STEP07-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[15791612]
STEP07-03: FIND-INVOICE-DTLS:num_LINE_NUMBER=[838070971], num_INV_DTL_QTY=[1]
STEP07-05: UPDATE-QTY:num_INVOICE_NUMBER=[15791612], num_LINE_NUMBER=[838070971], fixdtl.NETWORK_CONTRACT_ID=[18147], fixdtl.TRF_PRODUCT_CODE=[MS-PORTAL-FEE], fixdtl.QTY=[1]
STEP07-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[15791612]
STEP07-03: FIND-INVOICE-DTLS:num_LINE_NUMBER=[838070971], num_INV_DTL_QTY=[1]
STEP07-05: UPDATE-QTY:num_INVOICE_NUMBER=[15791612], num_LINE_NUMBER=[838070971], fixdtl.NETWORK_CONTRACT_ID=[20187], fixdtl.TRF_PRODUCT_CODE=[MS-PORTAL-FEE], fixdtl.QTY=[1]
STEP08: PKG_STORE_INVOICE_TOTAL: START.
PRC_STORE_INVOICE_TOTAL: numClaimColGuarantee=[0].
PRC_STORE_INVOICE_TOTAL: AMOUNT=[-1].
PRC_STORE_INVOICE_TOTAL: TAXABLE_AMOUNT=[-1].
PRC_STORE_INVOICE_TOTAL: NON_TAXABLE_AMOUNT=[-1].
PRC_STORE_INVOICE_TOTAL: TAX_AMOUNT=[-1].
STEP08: PKG_STORE_INVOICE_TOTAL:num_INVOICE_NUMBER=[15791611],num_OUT_NUM=[15791611], var_OUT_MSG=[]
STEP08: PKG_STORE_INVOICE_TOTAL: END.
END: IN_SALES_YM=[2023/06], IN_FROM_WHERE=[1], IN_GROUP_ID=[20619]
プロセスが終了しました。
データベースGodizillaDB_STGから切断中です。