2026-01-03 11:46:09.0058||DEBUG|AccountManagement.Program|init main function 
2026-01-03 11:46:16.3452|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Amount' on entity type 'WaysMeans'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2026-01-03 11:46:16.3609|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'CurrentBalance' on entity type 'SourceAccountManagements'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2026-01-03 11:46:16.3609|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'OverdraftLimit' on entity type 'SourceAccountManagements'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2026-01-03 11:46:16.3984|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2026-01-03 11:46:17.1701|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (14ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2026-01-03 11:46:17.1935|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (14ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2026-01-03 11:46:17.1992|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2026-01-03 11:46:17.1992|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2026-01-03 11:46:17.2186|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2026-01-03 11:46:17.2336|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2026-01-03 11:46:18.2998||INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|User profile not available. Using 'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ASP.NET\4.0.30319.0\AutoGenKeys\S-1-5-82-636400548-2315632189-4083574877-3698939047-2307078153\DataProtection' as key repository and Windows DPAPI to encrypt keys at rest. 
2026-01-03 11:46:18.5645|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=209   
2026-01-03 11:46:18.5645|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance   
2026-01-03 11:46:18.5645|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current   
2026-01-03 11:46:19.3993|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-03 11:46:19.3993|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-03 11:46:19.3993|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-03 11:46:19.4123|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 848.2134ms 204  
2026-01-03 11:46:19.4123|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 848.2062ms 204  
2026-01-03 11:46:19.4123|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 848.2346ms 204  
2026-01-03 11:46:19.6376|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=209   
2026-01-03 11:46:19.6376|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance   
2026-01-03 11:46:19.6376|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current   
2026-01-03 11:46:19.9952|1|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Failed to validate the token. Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: IDX10223: Lifetime validation failed. The token is expired. ValidTo: 'System.DateTime', Current time: 'System.DateTime'.
   at Microsoft.IdentityModel.Tokens.Validators.ValidateLifetime(Nullable`1 notBefore, Nullable`1 expires, SecurityToken securityToken, TokenValidationParameters validationParameters)
   at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateLifetime(Nullable`1 notBefore, Nullable`1 expires, JwtSecurityToken jwtToken, TokenValidationParameters validationParameters)
   at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateTokenPayload(JwtSecurityToken jwtToken, TokenValidationParameters validationParameters)
   at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateToken(String token, TokenValidationParameters validationParameters, SecurityToken& validatedToken)
   at Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler.HandleAuthenticateAsync()
2026-01-03 11:46:19.9952|1|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Failed to validate the token. Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: IDX10223: Lifetime validation failed. The token is expired. ValidTo: 'System.DateTime', Current time: 'System.DateTime'.
   at Microsoft.IdentityModel.Tokens.Validators.ValidateLifetime(Nullable`1 notBefore, Nullable`1 expires, SecurityToken securityToken, TokenValidationParameters validationParameters)
   at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateLifetime(Nullable`1 notBefore, Nullable`1 expires, JwtSecurityToken jwtToken, TokenValidationParameters validationParameters)
   at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateTokenPayload(JwtSecurityToken jwtToken, TokenValidationParameters validationParameters)
   at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateToken(String token, TokenValidationParameters validationParameters, SecurityToken& validatedToken)
   at Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler.HandleAuthenticateAsync()
2026-01-03 11:46:19.9952|1|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Failed to validate the token. Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: IDX10223: Lifetime validation failed. The token is expired. ValidTo: 'System.DateTime', Current time: 'System.DateTime'.
   at Microsoft.IdentityModel.Tokens.Validators.ValidateLifetime(Nullable`1 notBefore, Nullable`1 expires, SecurityToken securityToken, TokenValidationParameters validationParameters)
   at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateLifetime(Nullable`1 notBefore, Nullable`1 expires, JwtSecurityToken jwtToken, TokenValidationParameters validationParameters)
   at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateTokenPayload(JwtSecurityToken jwtToken, TokenValidationParameters validationParameters)
   at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateToken(String token, TokenValidationParameters validationParameters, SecurityToken& validatedToken)
   at Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler.HandleAuthenticateAsync()
2026-01-03 11:46:20.0205|7|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Bearer was not authenticated. Failure message: IDX10223: Lifetime validation failed. The token is expired. ValidTo: 'System.DateTime', Current time: 'System.DateTime'. 
2026-01-03 11:46:20.0205|7|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Bearer was not authenticated. Failure message: IDX10223: Lifetime validation failed. The token is expired. ValidTo: 'System.DateTime', Current time: 'System.DateTime'. 
2026-01-03 11:46:20.0205|7|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Bearer was not authenticated. Failure message: IDX10223: Lifetime validation failed. The token is expired. ValidTo: 'System.DateTime', Current time: 'System.DateTime'. 
2026-01-03 11:46:20.0282|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-03 11:46:20.0282|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-03 11:46:20.0282|2|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization failed. 
2026-01-03 11:46:20.0282|2|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization failed. 
2026-01-03 11:46:20.0282|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-03 11:46:20.0282|2|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization failed. 
2026-01-03 11:46:20.0282|12|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|AuthenticationScheme: Bearer was challenged. 
2026-01-03 11:46:20.0282|12|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|AuthenticationScheme: Bearer was challenged. 
2026-01-03 11:46:20.0282|12|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|AuthenticationScheme: Bearer was challenged. 
2026-01-03 11:46:20.0448|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 407.7361ms 401  
2026-01-03 11:46:20.0448|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 409.2655ms 401  
2026-01-03 11:46:20.0448|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 410.285ms 401  
2026-01-03 11:47:40.0402|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAllInitiatePaymentSourceAccountsByUserId?userId=574   
2026-01-03 11:47:40.0402|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-03 11:47:40.0402|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 7.2905ms 204  
2026-01-03 11:47:40.0402|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=209   
2026-01-03 11:47:40.0504|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current   
2026-01-03 11:47:40.0504|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-03 11:47:40.0504|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-03 11:47:40.0504|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance   
2026-01-03 11:47:40.0504|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 6.4772ms 204  
2026-01-03 11:47:40.0504|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 5.5236ms 204  
2026-01-03 11:47:40.0504|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-03 11:47:40.0504|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 6.5547ms 204  
2026-01-03 11:47:40.2297|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAllInitiatePaymentSourceAccountsByUserId?userId=574   
2026-01-03 11:47:40.2297|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=209   
2026-01-03 11:47:40.2297|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current   
2026-01-03 11:47:40.2297|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance   
2026-01-03 11:47:40.2716|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2026-01-03 11:47:40.2716|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2026-01-03 11:47:40.2716|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2026-01-03 11:47:40.2716|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2026-01-03 11:47:40.2716|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-03 11:47:40.2716|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-03 11:47:40.2716|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-03 11:47:40.2716|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2026-01-03 11:47:40.2716|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2026-01-03 11:47:40.2716|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2026-01-03 11:47:40.2716|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2026-01-03 11:47:40.2716|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2026-01-03 11:47:40.2716|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.AccountManagementController.GetAllInitiatePaymentSourceAccountsByUserIdAsync (AccountManagement)' 
2026-01-03 11:47:40.2716|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 
2026-01-03 11:47:40.2861|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 
2026-01-03 11:47:40.2861|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 
2026-01-03 11:47:40.3153|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "FetchCurrentWaysMeans", controller = "WaysMeans"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult FetchCurrentWaysMeans() on controller AccountManagement.Controllers.WaysMeansController (AccountManagement). 
2026-01-03 11:47:40.3230|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2026-01-03 11:47:40.3230|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAccountByCorporateId", controller = "AccountManagement"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAccountByCorporateIdAsync(Int64) on controller AccountManagement.Controllers.AccountManagementController (AccountManagement). 
2026-01-03 11:47:40.3230|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "FetchBalance", controller = "TreasuryAccount"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] FetchBalance(System.Nullable`1[CorporatePay.Common.GovernmentAccountType]) on controller AccountManagement.Controllers.TreasuryAccountController (AccountManagement). 
2026-01-03 11:47:40.3230|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllInitiatePaymentSourceAccountsByUserId", controller = "AccountManagement"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllInitiatePaymentSourceAccountsByUserIdAsync(Int64) on controller AccountManagement.Controllers.AccountManagementController (AccountManagement). 
2026-01-03 11:47:40.3547|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2026-01-03 11:47:40.3547|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 
2026-01-03 11:47:40.3547||WARN|AccountManagement.Core.Services.TreasuryAccountService|CorporateId : 209 
2026-01-03 11:47:40.6445|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [w].[Id], [w].[Amount], [w].[Comment], [w].[CreatedBy], [w].[DateCreated], [w].[DateModified], [w].[IsActive], [w].[IsDeleted], [w].[ModifiedBy], [w].[Year]
FROM [WaysMeans] AS [w]
WHERE ([w].[IsDeleted] = CAST(0 AS bit)) AND ([w].[IsActive] = CAST(1 AS bit))
ORDER BY [w].[Id] DESC 
2026-01-03 11:47:40.7003|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (31ms) [Parameters=[@__Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [s].[Id], [s].[AccountName], [s].[AccountNumber], [s].[ApprovalStatus], [s].[ApprovalStatusDate], [s].[ApprovedBy], [s].[BankId], [s].[BankName], [s].[Code], [s].[CreatedBy], [s].[Currency], [s].[CurrentBalance], [s].[CurrentBalanceLastUpdatedTime], [s].[DateCreated], [s].[DateModified], [s].[IsActive], [s].[IsDeleted], [s].[ModifiedBy], [s].[OverdraftLimit], [s].[RejectionComment], [s].[UserType], [s].[UserTypeId]
FROM [SourceAccountManagements] AS [s]
WHERE (([s].[UserTypeId] = @__Id_0) AND ([s].[IsDeleted] = CAST(0 AS bit))) AND ([s].[IsActive] = CAST(1 AS bit)) 
2026-01-03 11:47:40.7003|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (38ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName], [s].[Id], [s].[AccountName], [s].[AccountNumber], [s].[ApprovalStatus], [s].[ApprovalStatusDate], [s].[ApprovedBy], [s].[BankId], [s].[BankName], [s].[Code], [s].[CreatedBy], [s].[Currency], [s].[CurrentBalance], [s].[CurrentBalanceLastUpdatedTime], [s].[DateCreated], [s].[DateModified], [s].[IsActive], [s].[IsDeleted], [s].[ModifiedBy], [s].[OverdraftLimit], [s].[RejectionComment], [s].[UserType], [s].[UserTypeId], [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType]
FROM [AccountPermissions] AS [a]
LEFT JOIN [SourceAccountManagements] AS [s] ON [a].[AccountsId] = [s].[Id]
INNER JOIN [Permissions] AS [p] ON [a].[PermissionId] = [p].[Id]
WHERE ((((([a].[UserId] = @__userId_0) AND ([a].[PermissionName] = N'Can Initiate Payment On Source Account')) AND ([a].[IsActive] = CAST(1 AS bit))) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([s].[IsActive] = CAST(1 AS bit))) AND ([s].[IsDeleted] = CAST(0 AS bit)) 
2026-01-03 11:47:40.7175|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[AccountManagement.Data.Models.WaysMeansModel, AccountManagement.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2026-01-03 11:47:40.7244|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[AccountManagement.Data.Entity.AccountPermission, AccountManagement.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2026-01-03 11:47:40.7404|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.AccountManagementController.GetAllInitiatePaymentSourceAccountsByUserIdAsync (AccountManagement) in 404.1984ms 
2026-01-03 11:47:40.7404|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.AccountManagementController.GetAllInitiatePaymentSourceAccountsByUserIdAsync (AccountManagement)' 
2026-01-03 11:47:40.7404|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 515.3698ms 200 application/json; charset=utf-8 
2026-01-03 11:47:40.7535|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement) in 435.9195ms 
2026-01-03 11:47:40.7535||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 
2026-01-03 11:47:40.7535||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 
2026-01-03 11:47:40.7535|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 
2026-01-03 11:47:40.7535||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/80 
2026-01-03 11:47:40.7535|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 526.9666ms 200 application/json; charset=utf-8 
2026-01-03 11:47:40.7535||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/80 
2026-01-03 11:47:41.1093||WARN|AccountManagement.Core.Services.IntegrationService|Response: {
  "data": [
    {
      "id": 41,
      "name": "T24",
      "transactionType": 1,
      "integrationType": 1,
      "institutionId": 80,
      "routeServices": [
        {
          "routeId": 41,
          "serviceType": 4,
          "endPoint": "/api/SL/CorporatePayApi/V2/FundsTransfer"
        },
        {
          "routeId": 41,
          "serviceType": 5,
          "endPoint": "/api/SL/CorporatePayApi/V2/CheckOverDrawnAccount?accountNumber="
        },
        {
          "routeId": 41,
          "serviceType": 6,
          "endPoint": "/api/SL/CorporatePayApi/V2/TransactionStatusQuery?refNo={Ref}"
        },
        {
          "routeId": 41,
          "serviceType": 1,
          "endPoint": "/api/SL/CorporatePayApi/V2/NameEnquiry?accountNumber="
        },
        {
          "routeId": 41,
          "serviceType": 2,
          "endPoint": "/api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber="
        }
      ],
      "routeParameters": [
        {
          "routeId": 41,
          "name": "Url",
          "value": "https://rcpayapi.mof.gov.sl/CorporatePayApi/"
        },
        {
          "routeId": 41,
          "name": "WebServiceUrl",
          "value": "http://10.117.0.150:9090/TWS/services?wsdl"
        },
        {
          "routeId": 41,
          "name": "UserName",
          "value": "EFTUSER"
        },
        {
          "routeId": 41,
          "name": "Password",
          "value": "FINANCE123456"
        }
      ]
    },
    {
      "id": 42,
      "name": "NotonUs",
      "transactionType": 2,
      "integrationType": 1,
      "institutionId": 80,
      "routeServices": [
        {
          "routeId": 42,
          "serviceType": 1,
          "endPoint": "/api/SL/CorporatePayAPI/V2/NameEnquiry/OtherBank?accountNumber="
        },
        {
          "routeId": 42,
          "serviceType": 4,
          "endPoint": "/api/SL/CorporatePayAPI/V2/FundsTransfer/OtherBank"
        },
        {
          "routeId": 42,
          "serviceType": 6,
          "endPoint": "/api/SL/CorporatePayApi/V2/TransactionStatusQuery?refNo={Ref}"
        }
      ],
      "routeParameters": [
        {
          "routeId": 42,
          "name": "Url",
          "value": "https://rcpayapi.mof.gov.sl/CorporatePayApi/"
        },
        {
          "routeId": 42,
          "name": "WebServiceUrl",
          "value": "http://10.117.0.150:9090/TWS/services?wsdl"
        },
        {
          "routeId": 42,
          "name": "UserName",
          "value": "EFTUSER"
        },
        {
          "routeId": 42,
          "name": "Password",
          "value": "FINANCE123456"
        }
      ]
    }
  ],
  "code": "00",
  "success": true,
  "description": "Success"
}::: OK::: OK 
2026-01-03 11:47:41.1093||WARN|AccountManagement.Core.Services.IntegrationService|Response: {
  "data": [
    {
      "id": 41,
      "name": "T24",
      "transactionType": 1,
      "integrationType": 1,
      "institutionId": 80,
      "routeServices": [
        {
          "routeId": 41,
          "serviceType": 4,
          "endPoint": "/api/SL/CorporatePayApi/V2/FundsTransfer"
        },
        {
          "routeId": 41,
          "serviceType": 5,
          "endPoint": "/api/SL/CorporatePayApi/V2/CheckOverDrawnAccount?accountNumber="
        },
        {
          "routeId": 41,
          "serviceType": 6,
          "endPoint": "/api/SL/CorporatePayApi/V2/TransactionStatusQuery?refNo={Ref}"
        },
        {
          "routeId": 41,
          "serviceType": 1,
          "endPoint": "/api/SL/CorporatePayApi/V2/NameEnquiry?accountNumber="
        },
        {
          "routeId": 41,
          "serviceType": 2,
          "endPoint": "/api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber="
        }
      ],
      "routeParameters": [
        {
          "routeId": 41,
          "name": "Url",
          "value": "https://rcpayapi.mof.gov.sl/CorporatePayApi/"
        },
        {
          "routeId": 41,
          "name": "WebServiceUrl",
          "value": "http://10.117.0.150:9090/TWS/services?wsdl"
        },
        {
          "routeId": 41,
          "name": "UserName",
          "value": "EFTUSER"
        },
        {
          "routeId": 41,
          "name": "Password",
          "value": "FINANCE123456"
        }
      ]
    },
    {
      "id": 42,
      "name": "NotonUs",
      "transactionType": 2,
      "integrationType": 1,
      "institutionId": 80,
      "routeServices": [
        {
          "routeId": 42,
          "serviceType": 1,
          "endPoint": "/api/SL/CorporatePayAPI/V2/NameEnquiry/OtherBank?accountNumber="
        },
        {
          "routeId": 42,
          "serviceType": 4,
          "endPoint": "/api/SL/CorporatePayAPI/V2/FundsTransfer/OtherBank"
        },
        {
          "routeId": 42,
          "serviceType": 6,
          "endPoint": "/api/SL/CorporatePayApi/V2/TransactionStatusQuery?refNo={Ref}"
        }
      ],
      "routeParameters": [
        {
          "routeId": 42,
          "name": "Url",
          "value": "https://rcpayapi.mof.gov.sl/CorporatePayApi/"
        },
        {
          "routeId": 42,
          "name": "WebServiceUrl",
          "value": "http://10.117.0.150:9090/TWS/services?wsdl"
        },
        {
          "routeId": 42,
          "name": "UserName",
          "value": "EFTUSER"
        },
        {
          "routeId": 42,
          "name": "Password",
          "value": "FINANCE123456"
        }
      ]
    }
  ],
  "code": "00",
  "success": true,
  "description": "Success"
}::: OK::: OK 
2026-01-03 11:47:41.1388||WARN|AccountManagement.Core.Services.TreasuryAccountService|About to Fetch Treasury Accounts 
2026-01-03 11:47:41.1388||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2026-01-03 11:47:41.1446||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: api/SL/CorporatePayAPI/V2/Treasury/Accounts/Balance 
2026-01-03 11:47:41.1446||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=0112012335 
2026-01-03 11:47:42.2460||WARN|AccountManagement.Core.Services.IntegrationService|Treasury Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2026-01-03 11:47:42.2460||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2026-01-03 11:47:42.2460||WARN|AccountManagement.Core.Services.TreasuryAccountService|Done Fetching Treasury Accounts 
2026-01-03 11:47:42.2540||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2026-01-03 11:47:42.2540||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2026-01-03 11:47:42.2540|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[System.Object, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 
2026-01-03 11:47:42.2540|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement) in 1933.1593ms 
2026-01-03 11:47:42.2540|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 
2026-01-03 11:47:42.2689|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2032.7184ms 200 application/json; charset=utf-8 
2026-01-03 11:47:42.2864||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2026-01-03 11:47:42.2864||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 
2026-01-03 11:47:42.2864||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011201233545 
2026-01-03 11:47:43.3804||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response ["No connection could be made because the target machine actively refused it."] 
2026-01-03 11:47:43.3804||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 
2026-01-03 11:47:43.3804||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 
2026-01-03 11:47:43.4163||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 
2026-01-03 11:47:43.5174|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (6ms) [Parameters=[@p3='?' (DbType = Int64), @p0='?' (DbType = DateTime2), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p0, [DateModified] = @p1, [ModifiedBy] = @p2
WHERE [Id] = @p3;
SELECT @@ROWCOUNT; 
2026-01-03 11:47:43.5229|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p3='?' (DbType = Int64), @p0='?' (DbType = DateTime2), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p0, [DateModified] = @p1, [ModifiedBy] = @p2
WHERE [Id] = @p3;
SELECT @@ROWCOUNT; 
2026-01-03 11:47:43.5486|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [s].[Id], [s].[AccountName], [s].[AccountNumber], [s].[ApprovalStatus], [s].[ApprovalStatusDate], [s].[ApprovedBy], [s].[BankId], [s].[BankName], [s].[Code], [s].[CreatedBy], [s].[Currency], [s].[CurrentBalance], [s].[CurrentBalanceLastUpdatedTime], [s].[DateCreated], [s].[DateModified], [s].[IsActive], [s].[IsDeleted], [s].[ModifiedBy], [s].[OverdraftLimit], [s].[RejectionComment], [s].[UserType], [s].[UserTypeId]
FROM [SourceAccountManagements] AS [s]
WHERE (([s].[UserTypeId] = @__Id_0) AND ([s].[IsDeleted] = CAST(0 AS bit))) AND ([s].[IsActive] = CAST(1 AS bit))
ORDER BY [s].[DateCreated] DESC 
2026-01-03 11:47:43.5600|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType]
FROM [Permissions] AS [p]
WHERE [p].[Code] = N'CVAB' 
2026-01-03 11:47:43.5846|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName]
FROM [AccountPermissions] AS [a]
WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 
2026-01-03 11:47:43.6125|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType]
FROM [Permissions] AS [p]
WHERE [p].[Code] = N'CVAB' 
2026-01-03 11:47:43.6125|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName]
FROM [AccountPermissions] AS [a]
WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 
2026-01-03 11:47:43.7989|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[SourceAccountManagement.Data.Models.SourceAccountManagementViewModel, AccountManagement.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2026-01-03 11:47:43.8180|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement) in 3487.3768ms 
2026-01-03 11:47:43.8180|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 
2026-01-03 11:47:43.8180|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3592.3573ms 200 application/json; charset=utf-8 
2026-01-03 12:08:05.8001|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:46930/ACCOUNTSERVICES/iisintegration  0 
2026-01-03 12:08:05.8001|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 5.2051ms 202