Siebel Log - Part 18
WF StepValidation Process
Executing step: Errors ExistStep branchpassedYes
passed.WF StepValidation Process
Executing step: EndWorkflowEndValidation Process
🗁 Buscomp SQL :FILE Products Operations
🗁 Buscomp SQL :Position
| # | Process Name | Num Processed | Total Time For Process |
|---|---|---|---|
| 1194805 | Validation Process | 1 | 1819 |
🗁 List of Steps: Process Flow Diagram
| Name | Count | |
|---|---|---|
| Start | 1 | |
| Query Account Id | 1 | |
| Query FINS cBanking Request Borrower | 1 | |
| Query Request Input | 1 | |
| Borrowers Exist | 2 | |
| Check TEST COVID Nr Emp | 1 | |
| Borrower Name | 1 | |
| Borrower Enrollment Date | 1 | |
| Borrower Registration Date | 1 | |
| Borrower Company Premises Type | 1 | |
| Borrower Number of Employees | 1 | |
| Borrower Total JK Exposure | 1 | |
| Call Report | 1 | |
| Check Legal Opinion | 1 | |
| Legal opinion | 1 | |
| Borrower Max Debt Year | 1 | |
| Check Borrower GRC | 1 | |
| Income Norm Flag | 1 | |
| Income Amount | 1 | |
| Gross Annualized Income | 1 | |
| Net Annualized Income | 1 | |
| Gross Income Previous Year | 1 | |
| Gross Income Previous Year Err | 1 | |
| Errors Exist 2 | 1 | |
| Get NY Years | 1 | |
| Create Dates | 1 | |
| Calc Bal Sheet Error | 1 | |
| Wrong Date 1 | 1 | |
| Query Borrower Industry Codes | 1 | |
| Codes Exist | 5 | |
| Source Code | 4 | |
| Industr Code | 4 | |
| Percent | 4 | |
| Risk Cd | 4 | |
| Sector | 4 | |
| Real Act Flg | 4 | |
| Real Act Flg Err | 4 | |
| Ind Codes Errors Exist | 4 | |
| Required Err Msg3 | 4 | |
| Next Borrower Industry Codes | 4 | |
| Next FINS cBanking Request Borrower | 1 | |
| End 0 | 1 | |
| Errors Exist | 1 | |
| End | 1 |
Process Flow Diagram :📕 Validation Process
Section titled “📕 Validation Process”
🗁 Output
Business ServiceEndWorkflow Process Manager
invoke method: RunProcess🗁 Buscomp SQL :FINS cBanking Request
🗁 Buscomp SQL :Collaterals Pools Unassociated Products
🗁 Buscomp SQL :cBanking Status History
🗁 Buscomp SQL :FINS cBanking Request Borrower
🗁 Buscomp SQL :Request Input
🗁 Buscomp SQL :Request Output
🗁 Buscomp SQL :Collaterals
🗁 Buscomp SQL :cBanking Etape FILE History
Business ServiceStartError Logging
invoke method: ErrorLog🗁 Buscomp SQL :Error Log
Business ServiceEndError Logging
invoke method: ErrorLog🗁 Buscomp SQL :cBanking Product Operations
Business ServiceStartWorkflow Process Manager
invoke method: RunProcess🗁 Input
Executing process definition1-3ATZ0-B9JU
WorkflowStart📘 FILE Applicants Transform Xml
Section titled “📘 FILE Applicants Transform Xml”| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1199404 | Str | String | |
| 1199406 | File | String | /u01/oracle/siebelfs/Astro_ConfigTEST_XSLT.xsl |
WF StepFILE Applicants Transform Xml
Executing step: StartWF StepFILE Applicants Transform Xml
Executing step: Str is not null?Step branchnot passY
did not pass.WF StepFILE Applicants Transform Xml
Executing step: End 0WorkflowEndFILE Applicants Transform Xml
| # | Process Name | Num Processed | Total Time For Process |
|---|---|---|---|
| 1199425 | FILE Applicants Transform Xml | 1 | 1 |
🗁 List of Steps: Process Flow Diagram
| Name | Count | |
|---|---|---|
| Start | 1 | |
| Str is not null? | 1 | |
| End 0 | 1 |
Process Flow Diagram :📕 FILE Applicants Transform Xml
Section titled “📕 FILE Applicants Transform Xml”
🗁 Output
Business ServiceEndWorkflow Process Manager
invoke method: RunProcessView📚 FILE Borrower Details View
Section titled “📚 FILE Borrower Details View”🗁 Buscomp SQL :FINS cBanking Request
🗁 Buscomp SQL :Collaterals Pools Unassociated Products
🗁 Buscomp SQL :FINS cBanking Request Borrower
🗁 Buscomp SQL :Borrower Industry Codes
🗁 Buscomp SQL :FINS cBanking Request Borrower
🗁 Buscomp SQL :Borrower Industry Codes
🗁 Buscomp SQL :FILE People - Beneficiaries
🗁 Buscomp SQL :FILE People - Beneficiaries
| # | Invoke Method | Object Type | Object Name |
|---|---|---|---|
| 1212116 | Applet`ObjectName`FINS cBanking Request Header Form Applet - Header |
🗁 Browser Script :function FINS cBanking Request Header Form Applet Header Applet PreInvokeMethod (name, inputPropSet)
Row IdSWERowId1-2VJ13970
Applet Action📗 Borrower Industry Codes List Applet (PostChanges)
Section titled “📗 Borrower Industry Codes List Applet (PostChanges)”Row IdSWERowId1-2VJ13970
Applet Action📗 Borrower Industry Codes List Applet (WriteRecord)
Section titled “📗 Borrower Industry Codes List Applet (WriteRecord)”Row IdSWERowId1-2VJ13971
Applet Action📗 Borrower Industry Codes List Applet (PositionOnRow)
Section titled “📗 Borrower Industry Codes List Applet (PositionOnRow)”Row IdSWERowId1-2VJ13971
Applet Action📗 Borrower Industry Codes List Applet (PostChanges)
Section titled “📗 Borrower Industry Codes List Applet (PostChanges)”Row IdSWERowId1-2VJ13971
Applet Action📗 Borrower Industry Codes List Applet (WriteRecord)
Section titled “📗 Borrower Industry Codes List Applet (WriteRecord)”Row IdSWERowId1-2VJ1396Z
Applet Action📗 Borrower Industry Codes List Applet (PositionOnRow)
Section titled “📗 Borrower Industry Codes List Applet (PositionOnRow)”Row IdSWERowId1-2VJ1396Z
Applet Action📗 Borrower Industry Codes List Applet (PostChanges)
Section titled “📗 Borrower Industry Codes List Applet (PostChanges)”Row IdSWERowId1-2VJ1396Z
Applet Action📗 Borrower Industry Codes List Applet (WriteRecord)
Section titled “📗 Borrower Industry Codes List Applet (WriteRecord)”Row IdSWERowId1-2VJ13972
Applet Action📗 Borrower Industry Codes List Applet (PositionOnRow)
Section titled “📗 Borrower Industry Codes List Applet (PositionOnRow)”Row IdSWERowId1-2VJ13972
Applet Action📗 Borrower Industry Codes List Applet (PostChanges)
Section titled “📗 Borrower Industry Codes List Applet (PostChanges)”Row IdSWERowId1-2VJ13972
Applet Action📗 Borrower Industry Codes List Applet (WriteRecord)
Section titled “📗 Borrower Industry Codes List Applet (WriteRecord)”View📚 Request View
Section titled “📚 Request View”🗁 Buscomp SQL :FINS cBanking Request
🗁 Buscomp SQL :Collaterals Pools Unassociated Products
🗁 Buscomp SQL :Request Input
🗁 Buscomp SQL :Request Input
🗁 Buscomp SQL :Request Input
Business ServiceStartError Logging
invoke method: ErrorLog🗁 Buscomp SQL :Error Log
Business ServiceEndError Logging
invoke method: ErrorLog🗁 Buscomp SQL :FILE Products Operations
🗁 Buscomp SQL :cBanking Product Operations
🗁 Buscomp SQL :Request Input
🗁 Buscomp SQL :Request Output
🗁 Buscomp SQL :Collaterals
Business ServiceStartWorkflow Process Manager
invoke method: RunProcess🗁 Input
Executing process definition1-3ATZ0-B9JU
WorkflowStart📘 FILE Applicants Transform Xml
Section titled “📘 FILE Applicants Transform Xml”| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1276757 | Str | String | |
| 1276759 | File | String | /u01/oracle/siebelfs/Astro_ConfigTEST_XSLT.xsl |
WF StepFILE Applicants Transform Xml
Executing step: StartWF StepFILE Applicants Transform Xml
Executing step: Str is not null?Step branchnot passY
did not pass.WF StepFILE Applicants Transform Xml
Executing step: End 0WorkflowEndFILE Applicants Transform Xml
| # | Process Name | Num Processed | Total Time For Process |
|---|---|---|---|
| 1276778 | FILE Applicants Transform Xml | 1 | 1 |
🗁 List of Steps: Process Flow Diagram
| Name | Count | |
|---|---|---|
| Start | 1 | |
| Str is not null? | 1 | |
| End 0 | 1 |
Process Flow Diagram :📕 FILE Applicants Transform Xml
Section titled “📕 FILE Applicants Transform Xml”
🗁 Output
Business ServiceEndWorkflow Process Manager
invoke method: RunProcess🗁 Buscomp SQL :cBanking Product Operations
🗁 Buscomp SQL :FINS cBanking Request
🗁 Buscomp SQL :Collaterals Pools Unassociated Products
🗁 Buscomp SQL :Request Input
🗁 Buscomp SQL :Request Input
🗁 Buscomp SQL :Request Input
🗁 Buscomp SQL :FILE Products Operations
🗁 Buscomp SQL :cBanking Product Operations
| # | Invoke Method | Object Type | Object Name |
|---|---|---|---|
| 1285692 | Applet`ObjectName`FINS cBanking Request Header Form Applet - Header |
🗁 Browser Script :function FINS cBanking Request Header Form Applet Header Applet PreInvokeMethod (name, inputPropSet)
Row IdSWERowId1-2VJ139A0
Applet Action📗 Requested Product Input Form Applet (Decision)
Section titled “📗 Requested Product Input Form Applet (Decision)”Business ServiceStartWorkflow Process Manager
invoke method: RunProcess🗁 Input
Executing process definition1-3ATZ0-B9BG
WorkflowStart📘 Validare Decision TEST Ager Request Workflow
Section titled “📘 Validare Decision TEST Ager Request Workflow”| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1297874 | Sub Event | String | Decision |
| 1297876 | RTESupressInactiveWFerror | String | Y |
| 1297878 | Event Name | String | PreInvokeMethod |
| 1297880 | Triggering Event | String | 1-1W7TFU33 |
WF StepValidare Decision TEST Ager Request Workflow
Executing step: StartWF StepValidare Decision TEST Ager Request Workflow
Executing step: Invoke Decision TEST Ager Validation🗁 Input
🗁 Buscomp SQL :FINS Validation Rule Set
🗁 Buscomp SQL :FINS Validation Rule
🗁 Buscomp SQL :FINS Validation Action
🗁 Buscomp SQL :FINS Validation Action
🗁 Buscomp SQL :FINS Validation Rule Set Arguments
Business ServiceData Validation Manager
invoke method: Validate Execute Time: 0.011 seconds.Business ServiceEndData Validation Manager
invoke method: ValidateStep branchpassedConnector 0
passed.WF StepValidare Decision TEST Ager Request Workflow
Executing step: ReQuery Borrower🗁 Input
🗁 Buscomp SQL :FINS cBanking Request Borrower
Business ServiceWorkflow Siebel Operation
invoke method: QueryBiDirectional Execute Time: 0.157 seconds.Business ServiceEndWorkflow Siebel Operation
invoke method: QueryBiDirectional🗁 Output
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1299137 | Siebel Operation Object Id | String | 1-2VJ1391W |
WF StepValidare Decision TEST Ager Request Workflow
Executing step: Error ?Step branchnot passYes
did not pass.WF StepValidare Decision TEST Ager Request Workflow
Executing step: End 0WorkflowEndValidare Decision TEST Ager Request Workflow
| # | Process Name | Num Processed | Total Time For Process |
|---|---|---|---|
| 1299159 | Validare Decision TEST Ager Request Workflow | 1 | 169 |
🗁 List of Steps: Process Flow Diagram
| Name | Count | |
|---|---|---|
| Start | 1 | |
| Invoke Decision TEST Ager Validation | 1 | |
| ReQuery Borrower | 1 | |
| Error ? | 1 | |
| End 0 | 1 |
Process Flow Diagram :📕 Validare Decision TEST Ager Request Workflow
Section titled “📕 Validare Decision TEST Ager Request Workflow”
🗁 Output
Business ServiceEndWorkflow Process Manager
invoke method: RunProcessBusiness ServiceStartData Validation Manager
invoke method: Validate🗁 Buscomp SQL :FINS Validation Rule Set
🗁 Buscomp SQL :FINS Validation Rule
🗁 Buscomp SQL :FINS Validation Action
🗁 Buscomp SQL :FINS Validation Rule Set Arguments
🗁 Buscomp SQL :Person Risk Group Valid Records
🗁 Buscomp SQL :FINS Validation Instance
Business ServiceData Validation Manager
invoke method: Validate Execute Time: 0.326 seconds.Business ServiceEndData Validation Manager
invoke method: Validate🗁 Buscomp SQL :Average Market Interest
Business ServiceStartWorkflow Process Manager
invoke method: RunProcess🗁 Input
Executing process definition1-3ATZ0-BB25
WorkflowStart📘 Validation Process
Section titled “📘 Validation Process”| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1300248 | Toggle | String | 1 |
| 1300250 | 1 Error Count Validity Expired | Number | 0 |
| 1300252 | 6 Error Count | Number | 0 |
| 1300254 | CondirmTEST | String | Cancel |
| 1300256 | Error Count Total | Number | 0 |
| 1300258 | Check Validity | String | N |
| 1300260 | 3 Error Count | Number | 0 |
| 1300262 | Current STAGE | String | Branch Analysis |
| 1300264 | 2 Error Count | Number | 0 |
| 1300266 | Error Count | Number | 1 |
| 1300268 | 9 Error Count | Number | 0 |
| 1300270 | 5 Error Count | Number | 0 |
| 1300272 | 1 Error Count Validity Required | Number | 0 |
| 1300274 | 4 Error Count | Number | 0 |
| 1300276 | Error Message Total | String | . |
| 1300278 | 7 Error Count | Number | 0 |
| 1300280 | Error Code | String | %1 |
| 1300282 | 11 Error Count | Number | 0 |
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1300298 | Toggle | String | 1 |
| 1300300 | Request Id | String | 1-2VJ139A0 |
| 1300302 | Current STAGE | String | Simulation |
| 1300304 | Next STAGE Integration | String | Simulation TEST |
| 1300306 | AvgProdInt | String | 7.83 |
WF StepValidation Process
Executing step: Start🗁 Buscomp SQL :FINS cBanking Request
🗁 Buscomp SQL :Collaterals Pools Unassociated Products
WF StepValidation Process
Executing step: Identify Next STAGEStep branchpassedCurSTAGE=Analysis or Simulation
passed.WF StepValidation Process
Executing step: Query Borrower🗁 Input
🗁 Buscomp SQL :FINS cBanking Request Borrower
Business ServiceWorkflow Siebel Operation
invoke method: Query Execute Time: 0.028 seconds.Business ServiceEndWorkflow Siebel Operation
invoke method: Query🗁 Output
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1302067 | Siebel Operation Object Id | String | 1-2VJ1391W |
| 1302069 | TipANALIZ | String | PFA |
| 1302073 | NormaDeCreditareNAMEric | Number | 4 |
| 1302075 | Borrower Id | String | 1-2VJ1391W |
| 1302079 | Flow | String | TEST |
WF StepValidation Process
Executing step: Query CDS UpToDate🗁 Input
Business ServiceStartBS Compare Strings
invoke method: GetBeforeSubtringFromStringBusiness ServiceEndBS Compare Strings
invoke method: GetBeforeSubtringFromString🗁 Buscomp SQL :Borrower CDS UpToDate
Business ServiceWorkflow Siebel Operation
invoke method: Query Execute Time: 0.008 seconds.Business ServiceEndWorkflow Siebel Operation
invoke method: Query🗁 Output
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1302136 | Siebel Operation Object Id | String | 25483482 |
| 1302138 | CDS UpToDate | String | Y |
WF StepValidation Process
Executing step: Set Next STAGEBusiness ServiceStartWorkflow Utilities
invoke method: EchoBusiness ServiceEndWorkflow Utilities
invoke method: Echo| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1302152 | Check Validity | String | N |
| 1302154 | Next STAGE | String | Simulated |
WF StepValidation Process
Executing step: 6.Borrower Details Validation🗁 Input
🗁 Input
Executing process definition1-3ATZ0-B9J7
WorkflowStart📘 Borrower Details Validation
Section titled “📘 Borrower Details Validation”| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1302223 | Ind Codes Left | Number | 0 |
| 1302225 | Ind Codes Count | Number | 0 |
| 1302227 | Borrower Left | Number | 0 |
| 1302229 | Error Count Total | Number | 0 |
| 1302231 | Borrower Count | Number | 0 |
| 1302233 | STAGE | String | Scored |
| 1302235 | Error Count | Number | 0 |
🗁 Buscomp SQL :FINS cBanking Request
🗁 Buscomp SQL :Collaterals Pools Unassociated Products
🗁 Buscomp SQL :FINS cBanking Request Borrower
Business ServiceStartBS Compare Strings
invoke method: GetBeforeSubtringFromStringBusiness ServiceEndBS Compare Strings
invoke method: GetBeforeSubtringFromString🗁 Buscomp SQL :Borrower CDS UpToDate
🗁 Buscomp SQL :FINS cBanking Request Borrower
Business ServiceStartBS Compare Strings
invoke method: GetBeforeSubtringFromStringBusiness ServiceEndBS Compare Strings
invoke method: GetBeforeSubtringFromString🗁 Buscomp SQL :Borrower CDS UpToDate
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1305315 | Parent Current Step | String | 6.Borrower Details Validation |
| 1305317 | STAGE | String | Simulation |
WF StepBorrower Details Validation
Executing step: StartWF StepBorrower Details Validation
Executing step: Query Account IdBusiness ServiceStartWorkflow Utilities
invoke method: EchoBusiness ServiceEndWorkflow Utilities
invoke method: Echo| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1305330 | Account Id | String | 1-1D1J-6258 |
WF StepBorrower Details Validation
Executing step: Query FINS cBanking Request Borrower🗁 Buscomp SQL :FINS cBanking Request Borrower
Business ServiceStartBS Compare Strings
invoke method: GetBeforeSubtringFromStringBusiness ServiceEndBS Compare Strings
invoke method: GetBeforeSubtringFromString🗁 Buscomp SQL :Borrower CDS UpToDate
🗁 Buscomp SQL :Borrower CDS UpToDate
🗁 Input
🗁 Buscomp SQL :FINS cBanking Request Borrower
Business ServiceStartBS Compare Strings
invoke method: GetBeforeSubtringFromStringBusiness ServiceEndBS Compare Strings
invoke method: GetBeforeSubtringFromString🗁 Buscomp SQL :Borrower CDS UpToDate
Business ServiceWorkflow Siebel Operation
invoke method: Query Execute Time: 0.031 seconds.Business ServiceEndWorkflow Siebel Operation
invoke method: Query🗁 Output
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1307036 | Siebel Operation Object Id | String | 1-2VJ1391W |
| 1307038 | Gross Income Previous Year | String | |
| 1307042 | Norma (N) | Number | 4 |
| 1307044 | Analysis Type | String | PFA |
| 1307046 | Curr Yr Bal Sheet Date | Datetime | 12/31/2026 00:00:00 |
| 1307048 | Prev Yr Bal Sheet Date | Datetime | 12/31/2019 00:00:00 |
| 1307050 | Borrower Registration Date | String | 04/24/2009 00:00:00 |
| 1307052 | Borrower Enrollment Date | String | 06/15/2010 00:00:00 |
| 1307054 | Borrower Account Type | String | Client |
| 1307058 | Call Report | String | Yes |
| 1307060 | Current Year | Number | 2021 |
🗁 Buscomp SQL :cBanking Product Operations
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1307166 | OpTypeCheck | String | Y |
| 1307168 | Borrower Id | String | 1-2VJ1391W |
| 1307170 | Company Category | String | |
| 1307172 | Borrower Count | Number | 1 |
| 1307174 | Borrower Left | Number | 1 |
WF StepBorrower Details Validation
Executing step: Query Request Input🗁 Input
🗁 Buscomp SQL :Request Input
Business ServiceWorkflow Siebel Operation
invoke method: Query Execute Time: 0.024 seconds.Business ServiceEndWorkflow Siebel Operation
invoke method: Query🗁 Output
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1307781 | Siebel Operation Object Id | String | 1-2VJ139A0 |
| 1307783 | TEST Prod Code | Number | 2 |
| 1307787 | Legal Opinion | String | Fara Rezerve |
| 1307789 | Product Guaranteed | String | Y |
WF StepBorrower Details Validation
Executing step: Borrowers ExistStep branchnot pass0 Borrowers
did not pass.Step branchnot passConnector 28
did not pass.WF StepBorrower Details Validation
Executing step: Check TEST COVID Nr EmpBusiness ServiceStartWorkflow Utilities
invoke method: EchoBusiness ServiceEndWorkflow Utilities
invoke method: Echo| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1307813 | Error Message | String | |
| 1307815 | Error Count | Number | 0 |
WF StepBorrower Details Validation
Executing step: Borrower Name🗁 Buscomp SQL :Borrower CDS UpToDate
Step branchnot passBorrower Name 1
did not pass.WF StepBorrower Details Validation
Executing step: Borrower Enrollment DateStep branchnot passBorrower Enrollment Date 1
did not pass.WF StepBorrower Details Validation
Executing step: Borrower Registration DateStep branchnot passBorrower Registration Date 1
did not pass.WF StepBorrower Details Validation
Executing step: Borrower Company Premises Type🗁 Buscomp SQL :Borrower CDS UpToDate
🗁 Buscomp SQL :Borrower CDS UpToDate
Step branchnot passBorrower Company Premises Type 3
did not pass.WF StepBorrower Details Validation
Executing step: Borrower Number of Employees🗁 Buscomp SQL :Borrower CDS UpToDate
Step branchnot passBorrower Number of Employees 1
did not pass.WF StepBorrower Details Validation
Executing step: Borrower Total JK Exposure🗁 Buscomp SQL :Borrower CDS UpToDate
Step branchnot passBorrower Total JK Exposure 1
did not pass.WF StepBorrower Details Validation
Executing step: Call ReportStep branchnot passCall Report 1
did not pass.WF StepBorrower Details Validation
Executing step: Check Legal OpinionBusiness ServiceStartWorkflow Utilities
invoke method: EchoBusiness ServiceEndWorkflow Utilities
invoke method: Echo| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1308012 | Legal Opinion | String | N |
WF StepBorrower Details Validation
Executing step: Legal opinionStep branchnot passLegal opinion 1
did not pass.WF StepBorrower Details Validation
Executing step: Borrower Max Debt Year🗁 Buscomp SQL :Borrower CDS UpToDate
Step branchnot passBorrower Max Debt Year 1
did not pass.WF StepBorrower Details Validation
Executing step: Check Borrower GRC🗁 Buscomp SQL :Borrower CDS UpToDate
🗁 Buscomp SQL :Borrower CDS UpToDate
Step branchnot passCheck Borrower GRC 1
did not pass.WF StepBorrower Details Validation
Executing step: Income Norm FlagStep branchnot passIncome Norm Flag 1
did not pass.WF StepBorrower Details Validation
Executing step: Income AmountStep branchnot passIncome Amount 1
did not pass.WF StepBorrower Details Validation
Executing step: Gross Annualized IncomeStep branchnot passGross Annualized Income 1
did not pass.WF StepBorrower Details Validation
Executing step: Net Annualized IncomeStep branchnot passNet Annualized Income 1
did not pass.WF StepBorrower Details Validation
Executing step: Gross Income Previous YearStep branchpassedGross Income Previous Year 1
passed.WF StepBorrower Details Validation
Executing step: Gross Income Previous Year ErrBusiness ServiceStartWorkflow Utilities
invoke method: EchoBusiness ServiceEndWorkflow Utilities
invoke method: Echo| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1308160 | Error Message | String | |
| 1308162 | Error Count | Number | 0 |
WF StepBorrower Details Validation
Executing step: Errors Exist 2Step branchnot passConnector 7
did not pass.WF StepBorrower Details Validation
Executing step: Get NY YearsBusiness ServiceStartWorkflow Utilities
invoke method: EchoBusiness ServiceEndWorkflow Utilities
invoke method: Echo| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1308180 | Year3 | Number | 2018 |
| 1308182 | Year2 | Number | 2019 |
| 1308184 | Year1 | Number | 2020 |
WF StepBorrower Details Validation
Executing step: Create DatesBusiness ServiceStartWorkflow Utilities
invoke method: EchoBusiness ServiceEndWorkflow Utilities
invoke method: Echo| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1308200 | Date Grater May | String | Y |
| 1308202 | Date Grater Mar | String | Y |
| 1308204 | NY Date 3 | Datetime | 12/31/2018 00:00:00 |
| 1308206 | NY Date 2 | Datetime | 12/31/2019 00:00:00 |
| 1308208 | NY Date 1 | Datetime | 12/31/2026 00:00:00 |
WF StepBorrower Details Validation
Executing step: Calc Bal Sheet ErrorBusiness ServiceStartWorkflow Utilities
invoke method: EchoBusiness ServiceEndWorkflow Utilities
invoke method: Echo| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1308225 | CheckFailed | String | N |
WF StepBorrower Details Validation
Executing step: Wrong Date 1Step branchnot passWrong Date 1 - Y
did not pass.WF StepBorrower Details Validation
Executing step: Query Borrower Industry Codes🗁 Input
🗁 Buscomp SQL :Borrower Industry Codes
Business ServiceWorkflow Siebel Operation
invoke method: Query Execute Time: 0.003 seconds.Business ServiceEndWorkflow Siebel Operation
invoke method: Query🗁 Output
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1308318 | Siebel Operation Object Id | String | * |
| 1308320 | Sector | String | Production |
| 1308322 | Risk Cd | String | High |
| 1308324 | Percent | String | 20 |
| 1308326 | Industr Code | String | 07290 - Mining of other non-ferrous metal ores |
| 1308328 | Source Code | String | Siebel |
| 1308330 | Real Act Flg | String | Yes |
| 1308332 | Entry Id | String | 1-2VJ13970 |
| 1308334 | Ind Codes Left | Number | 4 |
| 1308336 | Ind Codes Count | Number | 4 |
WF StepBorrower Details Validation
Executing step: Codes ExistStep branchnot passConnector 30
did not pass.Step branchnot passConnector 20
did not pass.WF StepBorrower Details Validation
Executing step: Source CodeStep branchnot passSource Code 1
did not pass.WF StepBorrower Details Validation
Executing step: Industr CodeStep branchnot passIndustr Code 1
did not pass.WF StepBorrower Details Validation
Executing step: PercentStep branchnot passPercent 1
did not pass.WF StepBorrower Details Validation
Executing step: Risk CdStep branchnot passRisk Cd 1
did not pass.WF StepBorrower Details Validation
Executing step: SectorStep branchnot passResident Cd 1
did not pass.WF StepBorrower Details Validation
Executing step: Real Act FlgStep branchnot passReal Act Flg 1
did not pass.WF StepBorrower Details Validation
Executing step: Ind Codes Errors ExistStep branchnot passConnector 15
did not pass.WF StepBorrower Details Validation
Executing step: Next Borrower Industry Codes🗁 Input
Business ServiceEndWorkflow Siebel Operation
invoke method: NextRecord🗁 Output
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1308383 | Entry Id | String | 1-2VJ13971 |
| 1308385 | Sector | String | Large scale production |
| 1308387 | Percent | String | 0 |
| 1308389 | Industr Code | String | 11020 - Making wine from grapes |
| 1308391 | Real Act Flg | String | Yes |
| 1308393 | Risk Cd | String | Moderate |
| 1308395 | Source Code | String | Siebel |
| 1308397 | Ind Codes Left | Number | 3 |
WF StepBorrower Details Validation
Executing step: Codes ExistStep branchnot passConnector 30
did not pass.Step branchnot passConnector 20
did not pass.WF StepBorrower Details Validation
Executing step: Source CodeStep branchnot passSource Code 1
did not pass.WF StepBorrower Details Validation
Executing step: Industr CodeStep branchnot passIndustr Code 1
did not pass.WF StepBorrower Details Validation
Executing step: PercentStep branchnot passPercent 1
did not pass.WF StepBorrower Details Validation
Executing step: Risk CdStep branchnot passRisk Cd 1
did not pass.WF StepBorrower Details Validation
Executing step: SectorStep branchnot passResident Cd 1
did not pass.WF StepBorrower Details Validation
Executing step: Real Act FlgStep branchnot passReal Act Flg 1
did not pass.WF StepBorrower Details Validation
Executing step: Ind Codes Errors ExistStep branchnot passConnector 15
did not pass.WF StepBorrower Details Validation
Executing step: Next Borrower Industry Codes🗁 Input
Business ServiceEndWorkflow Siebel Operation
invoke method: NextRecord🗁 Output
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1308444 | Entry Id | String | 1-2VJ1396Z |
| 1308446 | Sector | String | ABCDcultura |
| 1308448 | Percent | String | 10 |
| 1308450 | Industr Code | String | 01500 - Activities in mixed farms (crop farming combined with animal husbandry) |
| 1308452 | Real Act Flg | String | Yes |
| 1308454 | Risk Cd | String | Moderate |
| 1308456 | Source Code | String | DW |
| 1308458 | Ind Codes Left | Number | 2 |
WF StepBorrower Details Validation
Executing step: Codes ExistStep branchnot passConnector 30
did not pass.Step branchnot passConnector 20
did not pass.WF StepBorrower Details Validation
Executing step: Source CodeStep branchnot passSource Code 1
did not pass.WF StepBorrower Details Validation
Executing step: Industr CodeStep branchnot passIndustr Code 1
did not pass.WF StepBorrower Details Validation
Executing step: PercentStep branchnot passPercent 1
did not pass.WF StepBorrower Details Validation
Executing step: Risk CdStep branchnot passRisk Cd 1
did not pass.WF StepBorrower Details Validation
Executing step: SectorStep branchnot passResident Cd 1
did not pass.WF StepBorrower Details Validation
Executing step: Real Act FlgStep branchnot passReal Act Flg 1
did not pass.WF StepBorrower Details Validation
Executing step: Ind Codes Errors ExistStep branchnot passConnector 15
did not pass.WF StepBorrower Details Validation
Executing step: Next Borrower Industry Codes🗁 Input
Business ServiceEndWorkflow Siebel Operation
invoke method: NextRecord🗁 Output
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1308505 | Entry Id | String | 1-2VJ13972 |
| 1308507 | Sector | String | Trade |
| 1308509 | Percent | String | 50 |
| 1308511 | Industr Code | String | 46330 - Wholesale of dairy products |
| 1308513 | Real Act Flg | String | Yes |
| 1308515 | Risk Cd | String | Low |
| 1308517 | Source Code | String | Siebel |
| 1308519 | Ind Codes Left | Number | 1 |
WF StepBorrower Details Validation
Executing step: Codes ExistStep branchnot passConnector 30
did not pass.Step branchnot passConnector 20
did not pass.WF StepBorrower Details Validation
Executing step: Source CodeStep branchnot passSource Code 1
did not pass.WF StepBorrower Details Validation
Executing step: Industr CodeStep branchnot passIndustr Code 1
did not pass.WF StepBorrower Details Validation
Executing step: PercentStep branchnot passPercent 1
did not pass.WF StepBorrower Details Validation
Executing step: Risk CdStep branchnot passRisk Cd 1
did not pass.WF StepBorrower Details Validation
Executing step: SectorStep branchnot passResident Cd 1
did not pass.WF StepBorrower Details Validation
Executing step: Real Act FlgStep branchnot passReal Act Flg 1
did not pass.WF StepBorrower Details Validation
Executing step: Ind Codes Errors ExistStep branchnot passConnector 15
did not pass.WF StepBorrower Details Validation
Executing step: Next Borrower Industry Codes🗁 Input
Business ServiceEndWorkflow Siebel Operation
invoke method: NextRecord🗁 Output
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1308566 | Entry Id | String | 1-2VJ13972 |
| 1308568 | Sector | String | Trade |
| 1308570 | Percent | String | 50 |
| 1308572 | Industr Code | String | 46330 - Wholesale of dairy products |
| 1308574 | Real Act Flg | String | Yes |
| 1308576 | Risk Cd | String | Low |
| 1308578 | Source Code | String | Siebel |
| 1308580 | Ind Codes Left | Number | 0 |
WF StepBorrower Details Validation
Executing step: Codes ExistStep branchpassedConnector 30
passed.Step branchnot passConnector 20
did not pass.WF StepBorrower Details Validation
Executing step: Next FINS cBanking Request Borrower🗁 Input
🗁 Buscomp SQL :Borrower CDS UpToDate
🗁 Buscomp SQL :Borrower Industry Codes
Business ServiceWorkflow Siebel Operation
invoke method: NextRecord Execute Time: 0.007 seconds.Business ServiceEndWorkflow Siebel Operation
invoke method: NextRecord🗁 Output
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1308707 | Borrower Id | String | 1-2VJ1391W |
| 1308709 | Borrower Left | Number | 0 |
WF StepBorrower Details Validation
Executing step: Borrowers ExistStep branchnot pass0 Borrowers
did not pass.Step branchpassedConnector 28
passed.WF StepBorrower Details Validation
Executing step: End 0WorkflowEndBorrower Details Validation
| # | Process Name | Num Processed | Total Time For Process |
|---|---|---|---|
| 1308738 | Borrower Details Validation | 1 | 275 |
🗁 List of Steps: Process Flow Diagram
| Name | Count | |
|---|---|---|
| Start | 1 | |
| Query Account Id | 1 | |
| Query FINS cBanking Request Borrower | 1 | |
| Query Request Input | 1 | |
| Borrowers Exist | 2 | |
| Check TEST COVID Nr Emp | 1 | |
| Borrower Name | 1 | |
| Borrower Enrollment Date | 1 | |
| Borrower Registration Date | 1 | |
| Borrower Company Premises Type | 1 | |
| Borrower Number of Employees | 1 | |
| Borrower Total JK Exposure | 1 | |
| Call Report | 1 | |
| Check Legal Opinion | 1 | |
| Legal opinion | 1 | |
| Borrower Max Debt Year | 1 | |
| Check Borrower GRC | 1 | |
| Income Norm Flag | 1 | |
| Income Amount | 1 | |
| Gross Annualized Income | 1 | |
| Net Annualized Income | 1 | |
| Gross Income Previous Year | 1 | |
| Gross Income Previous Year Err | 1 | |
| Errors Exist 2 | 1 | |
| Get NY Years | 1 | |
| Create Dates | 1 | |
| Calc Bal Sheet Error | 1 | |
| Wrong Date 1 | 1 | |
| Query Borrower Industry Codes | 1 | |
| Codes Exist | 5 | |
| Source Code | 4 | |
| Industr Code | 4 | |
| Percent | 4 | |
| Risk Cd | 4 | |
| Sector | 4 | |
| Real Act Flg | 4 | |
| Ind Codes Errors Exist | 4 | |
| Next Borrower Industry Codes | 4 | |
| Next FINS cBanking Request Borrower | 1 | |
| End 0 | 1 |
Process Flow Diagram :📕 Borrower Details Validation
Section titled “📕 Borrower Details Validation”
🗁 Output
Business ServiceEndWorkflow Process Manager
invoke method: _RunSubProcess🗁 Output
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1308743 | 6 Error Count | Number | 0 |
| 1308745 | Error Message | String |
WF StepValidation Process
Executing step: Errors ExistStep branchnot passYes
did not pass.WF StepValidation Process
Executing step: 10. Check Year Turnover Parent Line Correspondence🗁 Input
🗁 Input
Executing process definition1-3ATZ0-B997
WorkflowStart📘 TEST Check Year Turnover Parent Line Correspondence
Section titled “📘 TEST Check Year Turnover Parent Line Correspondence”| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1308863 | ErrorCount | Number | 0 |
| 1308865 | Parent Current Step | String | 10. Check Year Turnover Parent Line Correspondence |
WF StepTEST Check Year Turnover Parent Line Correspondence
Executing step: StartWF StepTEST Check Year Turnover Parent Line Correspondence
Executing step: Query Borrower🗁 Buscomp SQL :FINS cBanking Request Borrower
Business ServiceStartBS Compare Strings
invoke method: GetBeforeSubtringFromStringBusiness ServiceEndBS Compare Strings
invoke method: GetBeforeSubtringFromString🗁 Buscomp SQL :Borrower CDS UpToDate
🗁 Buscomp SQL :Borrower Industry Codes
🗁 Buscomp SQL :Borrower CDS UpToDate
🗁 Buscomp SQL :Borrower Industry Codes
🗁 Input
🗁 Buscomp SQL :FINS cBanking Request Borrower
Business ServiceStartBS Compare Strings
invoke method: GetBeforeSubtringFromStringBusiness ServiceEndBS Compare Strings
invoke method: GetBeforeSubtringFromString🗁 Buscomp SQL :Borrower CDS UpToDate
🗁 Buscomp SQL :Borrower Industry Codes
Business ServiceWorkflow Siebel Operation
invoke method: Query Execute Time: 0.112 seconds.Business ServiceEndWorkflow Siebel Operation
invoke method: Query🗁 Output
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1310790 | Siebel Operation Object Id | String | 1-2VJ1391W |
| 1310792 | OrganizationForm | String | PFA |
| 1310794 | ClientRiskName | String | 97 |
| 1310796 | OrganizationType | String | ALTELE |
| 1310798 | BorrowerName | String | DEAC HTREW AUTHORIZED NATURAL PERSON |
| 1310800 | ParentLine | String | IMM |
| 1310802 | CountBorrower | Number | 1 |
| 1310804 | TurnoverPrevYear | Number | |
| 1310806 | TurnoverCurYear | Number | 9000000 |
| 1310808 | BorrowerId | String | 1-2VJ1391W |
End of Part 18