INSERT INTO APL_KYC_DATA.KYC_TEST (
    TEST_DATE,
    USER_ROLE,
    SUBJECT_AREA,
    USER_REQUEST,
    USER_REQUEST_PROCESSED,
    SQL_QUERY,
    CUSTOMER_REGISTRY_ID,
    BASE_CASE
) VALUES (
    TO_DATE('2026-04-01', 'YYYY-MM-DD'),
    q'~FINANCE~',
    q'~INVOICE~',
    q'~which region does the TD SYNNEX Corporation's belong to and also show the order numbers~',
    q'~which region does customer TD SYNNEX Corporation (registry ID A4WFCY3) belong to and also show the order numbers~',
    q'~SELECT c_dim.REGION,
       inv_dim.ORDER_NUMBER
FROM APL_KYC.INVOICE_FACT inv_fact
INNER JOIN APL_KYC.CUSTOMER_DIM c_dim ON inv_fact.CUSTOMER_REGISTRY_ID = c_dim.CUSTOMER_REGISTRY_ID
INNER JOIN APL_KYC.INVOICE_DIM inv_dim ON inv_fact.INVOICE_WID = inv_dim.INVOICE_WID
WHERE c_dim.CUSTOMER_REGISTRY_ID = 'A4WFCY3'~',
    q'~A4WFCY3~'
   ,q'~Y~'
);
);

Caused by: liquibase.exception.DatabaseException: ORA-03405: End of query reached; no additional text should follow.
https://docs.oracle.com/error-help/db/ora-03405/ [Failed SQL: (3405) INSERT INTO APL_KYC_DATA.KYC_TEST (

--liquibase formatted sql

--changeset adizquie:0 context:aiwat,aiwbt,aiwap splitStatements:true endDelimiter:; runOnChange:true labels:kyc,KYC_TEST,INVOICE
DELETE FROM APL_KYC_DATA.KYC_TEST WHERE SUBJECT_AREA = 'INVOICE';

INSERT INTO APL_KYC_DATA.KYC_TEST (
    TEST_DATE,
    USER_ROLE,
    SUBJECT_AREA,
    USER_REQUEST,
    USER_REQUEST_PROCESSED,
    SQL_QUERY,
    CUSTOMER_REGISTRY_ID,
    BASE_CASE
) VALUES (
    TO_DATE('2026-04-01', 'YYYY-MM-DD'),
    q'~FINANCE~',
    q'~INVOICE~',
    q'~Show The Coca-Cola Company's outstanding exposure: total balance and aging-bucket distribution~',
    q'~Show customer The Coca-Cola Company (registry ID 11629422) outstanding exposure: total balance and aging-bucket distribution~',
    q'~WITH BUCKET_ORD(BUCKET_NAME, RNK) AS
  (SELECT 'Current',
          1
   FROM dual
   UNION SELECT '1-30 days overdue',
                2
   FROM dual
   UNION SELECT '31-60 days overdue',
                3
   FROM dual
   UNION SELECT '61-90 days overdue',
                4
   FROM dual
   UNION SELECT '91-180 days overdue',
                5
   FROM dual
   UNION SELECT '181-360 days overdue',
                6
   FROM dual
   UNION SELECT '361+ days overdue',
                7
   FROM dual)
SELECT c_dim.CUSTOMER_NAME,
       c_dim.CUSTOMER_REGISTRY_ID,
       inv_dim.AGING_BUCKET_NAME,
       ROUND(SUM(inv_fact.INVOICE_NET_OUTSTANDING_AMOUNT_CD) / NULLIF(SUM(SUM(inv_fact.INVOICE_NET_OUTSTANDING_AMOUNT_CD)) OVER (PARTITION BY c_dim.CUSTOMER_REGISTRY_ID), 0), 4) * 100 AS BUCKET_PCT,
       ROUND(SUM(SUM(inv_fact.INVOICE_NET_OUTSTANDING_AMOUNT_CD)) OVER (PARTITION BY c_dim.CUSTOMER_REGISTRY_ID), 2) AS TOTAL_NET_OUTSTANDING_AMOUNT_CD,
       ROUND(SUM(inv_fact.INVOICE_NET_OUTSTANDING_AMOUNT_CD), 2) AS BUCKET_NET_OUTSTANDING_AMOUNT_CD
FROM APL_KYC.INVOICE_FACT inv_fact
INNER JOIN APL_KYC.INVOICE_DIM inv_dim ON inv_fact.INVOICE_WID = inv_dim.INVOICE_WID
INNER JOIN APL_KYC.CUSTOMER_DIM c_dim ON inv_fact.CUSTOMER_REGISTRY_ID = c_dim.CUSTOMER_REGISTRY_ID
INNER JOIN BUCKET_ORD ON inv_dim.AGING_BUCKET_NAME = BUCKET_ORD.BUCKET_NAME
WHERE c_dim.CUSTOMER_REGISTRY_ID = '11629422'
GROUP BY c_dim.CUSTOMER_NAME,
         c_dim.CUSTOMER_REGISTRY_ID,
         inv_dim.AGING_BUCKET_NAME,
         BUCKET_ORD.RNK
ORDER BY BUCKET_ORD.RNK~',
    q'~11629422~'
   ,q'~Y~'
);

INSERT INTO APL_KYC_DATA.KYC_TEST (
    TEST_DATE,
    USER_ROLE,
    SUBJECT_AREA,
    USER_REQUEST,
    USER_REQUEST_PROCESSED,
    SQL_QUERY,
    CUSTOMER_REGISTRY_ID,
    BASE_CASE
) VALUES (
    TO_DATE('2026-04-01', 'YYYY-MM-DD'),
    q'~FINANCE~',
    q'~INVOICE~',
    q'~which region does the TD SYNNEX Corporation's belong to and also show the order numbers~',
    q'~which region does customer TD SYNNEX Corporation (registry ID A4WFCY3) belong to and also show the order numbers~',
    q'~SELECT c_dim.REGION,
       inv_dim.ORDER_NUMBER
FROM APL_KYC.INVOICE_FACT inv_fact
INNER JOIN APL_KYC.CUSTOMER_DIM c_dim ON inv_fact.CUSTOMER_REGISTRY_ID = c_dim.CUSTOMER_REGISTRY_ID
INNER JOIN APL_KYC.INVOICE_DIM inv_dim ON inv_fact.INVOICE_WID = inv_dim.INVOICE_WID
WHERE c_dim.CUSTOMER_REGISTRY_ID = 'A4WFCY3'~',
    q'~A4WFCY3~'
   ,q'~Y~'
);