Distributor test scenarios - AUC

ACT environment

Watch here

Distributor test scenarios

Test ID	Test scenario	Expected result	Apex Utilities Inc. test files	ATCO Gas test files	Pre-condition
1	Test CLE transaction processing
1.1	Receive a CLE from the retailer of record. Formatting is correct. Exemption flag is yes. Exemption reason code is 001.	CLE is processed. CLN is produced with correct effective date, next calendar day. Exemption flag is set to Yes. Reason Code is stored.	CLN_0007_999999999_20161110165144	CLN_0003_888888888_20161005063140	Site is enrolled with the retailer in the CLE.
1.2	Receive a CLE from a retailer that is not the retailer of record.	CLN is produced with a failure code of 2608 Invalid Retailer ID for site.	CLN_0007_999999999_20161110165155	CLN_0001_999999999_20160930063137	AG: Site is not enrolled with retailer in the CLE, No SRR is sent with CLE.
1.3	Receive a CLE from the retailer of record. Formatting of the CLE is incorrect (invalid retailer ID, distributor ID, format or length).	CLN is produced with corresponding failure code.	CLN_0007_999999999_20161109165154	CLN_0001_888888888_20161004063135	AUI: Site is enrolled with the retailer in the CLE. AG: Site is enrolled with the retailer in the CLE. Test scenarios for each of the automated rejects, manual review and failures
1.4	Receive a CLE from the retailer of record. Formatting is correct Exemption flag is No.	CLE is processed. CLN is produced with correct effective date, next calendar day. Exemption flag is set No.	CLN_0007_999999999_20161109155124	CLN_0003_888888888_20161006063134	Site ID in test file is already flagged as exempt. Site is enrolled with the retailer in the CLE.
1.5	Receive multiple CLE’s for the same site on the same day: 1. ROR, exemption flag to yes, reason code is 001 2. Not ROR, exemption flag NO 3. ROR, set exemption flag to NO 4. ROR, sets exemption flag to yes, reason code is 002.	CLN’s are produced for all CLE’s 1. CLN is successful, exemption flag is Yes 2. CLN is unsuccessful, no change to exemption flag 3. CLN is successful, exemption flag is No 4. CLN is successful, exemption flag is Yes. The last processed CLE will set exemption status for next calendar day.	CLN_0007_999999999_20161109155454 CLN_0007_999999999_20161109155954 CLN_0007_999999999_20161109160344 CLN_0007_999999999_20161109160824	Results 1, 3, and 4: CLN_0003_888888888_20161007063139 Results 2: CLN_0003_999999999_20161007063139	AUI: Site is enrolled with the retailer is sequence 1,3,4. AG: Site is enrolled with the retailer is sequence 1,3,4.
1.6	Receive a SRR and CLE for a site that is not currently enrolled with retailer of record. Exemption flag is Y.	SRR is processed and site enrolled. Successful SRN is sent out. CLE is processed. CLN is produced with correct effective date, next calendar day. Exemption flag is set to Yes. Reason code is stored.	CLN_0007_999999999_20161109165124	CLN_0001_999999999_20160930063137	AUI: Site is NOT currently enrolled with retailer of record. Previous retailer/customer exempt status ‘Y’. AG: Site is enrolled with the retailer is sequence 1,3,4.
1.7	Receive a SRR and CLE for a site that is not currently enrolled with retailer of record. Exemption flag is N.	SRR is processed and site enrolled. CLE is processed. CLN is produced with correct effective date, next calendar day. Exemption flag is set to No.	CLN_0007_999999999_20161110164154	CLN_0003_777777777_20161007063139	Site is NOT currently enrolled with retailer of record. Previous retailer/customer exempt status ‘Y’.
1.8	Receive a SRR w/o CLE for a site that is not currently enrolled with retailer of record. Previous customer at site is exempt.	SRR is processed and site enrolled. Successful SRN is sent out. Exemption flag is defaulted to No.	AUI has tested and passed this scenario, defaulted exemption flag to No.	Test was passed. Exemption flag defaulted to No.	Site is NOT currently enrolled with retailer of record. Previous retailer/customer exempt status ‘Y’.
1.9	Receive a SRR w/o CLE for a site that is not currently enrolled with retailer of record. Previous customer at site is NOT exempt.	SRR is processed and site enrolled. Successful SRN is sent out. Exemption flag is defaulted & maintained @ ‘No’.		Test was passed. Exemption flag defaulted to No.	Site is NOT currently enrolled with retailer of record. Previous retailer/customer exempt status ‘N’.
2	Test tariff billing code production
2.1	Produce a TBF with the new charge component of 5008.	TBF is produced with the new CH record, charge amount is correct, TBF is formatted correctly.	TBF_0007_999999999_20161108152014	TBF_0001_555555555_20161110002802 Refer to site ID 1111111111111	Site is actively billing and is not exempt in system.
2.2	Produce a TBF for a site that is exempt from carbon levy.	TBF is produced without the new CH record, charge amount is correct, TBF is formatted correctly.	TBF_0007_999999999_20161110115748	TBF_0001_555555555_20161104002514 Refer to site ID 3333333333333	Site is actively billing and is exempt in the system.
2.3	Produce a TBF that has had an exemption flag change from Yes to No during the calendar month.	TBF is produced TH, DU and CH splits are created CH has the 5008 on the correct TH,DU,CH set.	AUI will provide 2 TBF as we will charge to the effective date and TBF, perform the rate change and then the next TBF will be produced on cycle. TBF_0007_999999999_20161110130635 TBF_0007_999999999_20161110141123	TBF_0003_555555555_20161117003232 Refer to site ID 2222222222222	ATCO Gas specific scenario
2.4	Produce a TBF that has had an exemption flag change from No to Yes during the calendar month.	TBF is produced TH, DU and CH splits are created CH has the 5008 on the correct TH,DU,CH set.	AUI will provide 2 TBF as we will charge to the effective date and TBF, perform the rate change and then the next TBF will be produced on cycle. TBF_0007_999999999_20161110143247 TBF_0007_999999999_20161110144437	TBF_0003_555555555_20161117003232 Refer to site ID 3333333333333	ATCO Gas specific scenario
3	Test TBD transaction processing
3.1	Receive a valid TBD with the dispute reason of 7015.	The TBD is processed. Cancel/Replacement TBF is produced Exemption flag is updated.	TBF_0007_999999999_20161110160823 TBF_0007_999999999_20161110162151	TBF_0001_555555555_20161029002939 Refer to site ID 1111111111111	AG: Could be either situation, charging and shouldn’t be or vice versa. In theory it means we received a CLE and sent a CLN, however didn’t update our flag. Just makes sure the TBD process can handle the new reason code and our business processes are set up correctly to handle this one.

Apex Utilities Inc. testing related information:

Apex Utilities Inc. created the original carbon levy rate effective Aug 1, 2016.
Apex Utilities Inc. simulated a rate change to test the January 1, 2018 carbon levy rate change in our test systems effective October 1, 2016.
Test results will have both the January 1, 2017 and January 1, 2018 rates.

Retailer test scenarios

ATCO Energy test files
DERS and DEP CLE test files
Encor by EPCOR test files
ENMAX Energy test files (Non-Exempt to Exempt)
ENMAX Energy test files (Exempt to Non-Exempt)
ENMAX Energy test files (Non-Exempt)