Siebel Log - Part 17
WF StepLoan Status STAGE FILE History Workflow
Executing step: EndWorkflowEndLoan Status STAGE FILE History Workflow
| # | Process Name | Num Processed | Total Time For Process |
|---|---|---|---|
| 1108329 | Loan Status STAGE FILE History Workflow | 1 | 286 |
🗁 List of Steps: Process Flow Diagram
| Name | Count | |
|---|---|---|
| Start | 1 | |
| Get FILE STAGE/Tip Flux | 1 | |
| Check Current STAGE | 1 | |
| Check STAGE/Tip Flux Changed | 1 | |
| STAGE / Tip Flux is Changed ? | 1 | |
| Query for Nr Records | 1 | |
| No Records ? | 1 | |
| Get Etape FILE Hist Previous Record Data | 1 | |
| Compare Current/Previous STAGE, Tip Flux | 1 | |
| STAGE/Tip Flux Allready Added ? | 1 | |
| Historize Alloc ARS STAGE ? | 1 | |
| Query History | 1 | |
| End | 1 |
Process Flow Diagram :📕 Loan Status STAGE FILE History Workflow
Section titled “📕 Loan Status STAGE FILE History Workflow”🗁 Output
Business ServiceEndWorkflow Process Manager
invoke method: RunProcessBusiness ServiceStartWorkflow Process Manager
invoke method: RunProcess🗁 Input
Executing process definition1-3ATZ0-B9VN
WorkflowStart📘 Loan Status STAGE FILE History Workflow from Action
Section titled “📘 Loan Status STAGE FILE History Workflow from Action”Business ServiceWorkflow Process Manager
invoke method: RunProcess Execute Time: 0.002 seconds.Business ServiceEndWorkflow Process Manager
invoke method: RunProcessBusiness ServiceStartWorkflow Process Manager
invoke method: RunProcess🗁 Input
Executing process definition1-3ATZ0-B988
WorkflowStart📘 Change Loan Flow to Other WF from Account BO
Section titled “📘 Change Loan Flow to Other WF from Account BO”Business ServiceWorkflow Process Manager
invoke method: RunProcess Execute Time: 0.002 seconds.Business ServiceEndWorkflow Process Manager
invoke method: RunProcessBusiness ServiceStartWorkflow Process Manager
invoke method: RunProcess🗁 Input
Business ServiceWorkflow Process Manager
invoke method: RunProcess Execute Time: 0.002 seconds.Business ServiceEndWorkflow Process Manager
invoke method: RunProcess🗁 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 |
|---|---|---|---|
| 1109293 | Str | String | |
| 1109295 | 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 |
|---|---|---|---|
| 1109314 | 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 :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 |
|---|---|---|---|
| 1121620 | 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 (EditField)
Section titled “📗 Requested Product Input Form Applet (EditField)”🗁 Buscomp SQL :Product Flux Category
Row IdSWERowId1-3OG5VEMJK_P12+IMMTEST
Applet Action📗 Request Product Pick Applet (PositionOnRow)
Section titled “📗 Request Product Pick Applet (PositionOnRow)”Row IdSWERowId1-6U719TYSPG0IMMTEST
Applet Action📗 Request Product Pick Applet (PositionOnRow)
Section titled “📗 Request Product Pick Applet (PositionOnRow)”Row IdSWERowId1-6U719TYSPG0IMMTEST
Applet Action📗 Request Product Pick Applet (PickRecord)
Section titled “📗 Request Product Pick Applet (PickRecord)”Row IdSWERowId1-2VJ139A0
Applet Action📗 Requested Product Input Form Applet (WriteRecord)
Section titled “📗 Requested Product Input Form Applet (WriteRecord)”Applet Action📗 Collaterals List Applet (NewRecord)
Section titled “📗 Collaterals List Applet (NewRecord)”🗁 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 |
|---|---|---|---|
| 1160126 | 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-2VJ139AB
Applet Action📗 Collaterals List Applet (GetQuickPickInfo)
Section titled “📗 Collaterals List Applet (GetQuickPickInfo)”Row IdSWERowId1-2VJ139AB
Applet Action📗 Collaterals List Applet (PostChanges)
Section titled “📗 Collaterals List Applet (PostChanges)”Row IdSWERowId1-2VJ139AB
Applet Action📗 Collaterals List Applet (GetQuickPickInfo)
Section titled “📗 Collaterals List Applet (GetQuickPickInfo)”Row IdSWERowId1-2VJ139AB
Applet Action📗 Collaterals List Applet (PostChanges)
Section titled “📗 Collaterals List Applet (PostChanges)”Row IdSWERowId1-2VJ139AB
Applet Action📗 Collaterals List Applet (WriteRecord)
Section titled “📗 Collaterals List Applet (WriteRecord)”Business 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 :FINS Validation Instance
Business ServiceData Validation Manager
invoke method: Validate Execute Time: 0.017 seconds.Business ServiceEndData Validation Manager
invoke method: ValidateRow 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 |
|---|---|---|---|
| 1183434 | Sub Event | String | Decision |
| 1183436 | RTESupressInactiveWFerror | String | Y |
| 1183438 | Event Name | String | PreInvokeMethod |
| 1183440 | 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.016 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.029 seconds.Business ServiceEndWorkflow Siebel Operation
invoke method: QueryBiDirectional🗁 Output
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1184591 | 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 |
|---|---|---|---|
| 1184613 | Validare Decision TEST Ager Request Workflow | 1 | 47 |
🗁 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: 1.391 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 |
|---|---|---|---|
| 1185748 | Toggle | String | 1 |
| 1185750 | 1 Error Count Validity Expired | Number | 0 |
| 1185752 | 6 Error Count | Number | 0 |
| 1185754 | CondirmTEST | String | Cancel |
| 1185756 | Error Count Total | Number | 0 |
| 1185758 | Check Validity | String | N |
| 1185760 | 3 Error Count | Number | 0 |
| 1185762 | Current STAGE | String | Branch Analysis |
| 1185764 | 2 Error Count | Number | 0 |
| 1185766 | Error Count | Number | 1 |
| 1185768 | 9 Error Count | Number | 0 |
| 1185770 | 5 Error Count | Number | 0 |
| 1185772 | 1 Error Count Validity Required | Number | 0 |
| 1185774 | 4 Error Count | Number | 0 |
| 1185776 | Error Message Total | String | . |
| 1185778 | 7 Error Count | Number | 0 |
| 1185780 | Error Code | String | %1 |
| 1185782 | 11 Error Count | Number | 0 |
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1185798 | Toggle | String | 1 |
| 1185800 | Request Id | String | 1-2VJ139A0 |
| 1185802 | Current STAGE | String | Simulation |
| 1185804 | Next STAGE Integration | String | Simulation TEST |
| 1185806 | 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.029 seconds.Business ServiceEndWorkflow Siebel Operation
invoke method: Query🗁 Output
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1187567 | Siebel Operation Object Id | String | 1-2VJ1391W |
| 1187569 | TipANALIZ | String | PFA |
| 1187573 | NormaDeCreditareNAMEric | Number | 4 |
| 1187575 | Borrower Id | String | 1-2VJ1391W |
| 1187579 | 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.018 seconds.Business ServiceEndWorkflow Siebel Operation
invoke method: Query🗁 Output
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1187636 | Siebel Operation Object Id | String | 25483482 |
| 1187638 | 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 |
|---|---|---|---|
| 1187652 | Check Validity | String | N |
| 1187654 | 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 |
|---|---|---|---|
| 1187769 | Ind Codes Left | Number | 0 |
| 1187771 | Ind Codes Count | Number | 0 |
| 1187773 | Borrower Left | Number | 0 |
| 1187775 | Error Count Total | Number | 0 |
| 1187777 | Borrower Count | Number | 0 |
| 1187779 | STAGE | String | Scored |
| 1187781 | 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 |
|---|---|---|---|
| 1190861 | Parent Current Step | String | 6.Borrower Details Validation |
| 1190863 | 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 |
|---|---|---|---|
| 1190876 | 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.090 seconds.Business ServiceEndWorkflow Siebel Operation
invoke method: Query🗁 Output
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1192582 | Siebel Operation Object Id | String | 1-2VJ1391W |
| 1192584 | Gross Income Previous Year | String | |
| 1192588 | Norma (N) | Number | 4 |
| 1192590 | Analysis Type | String | PFA |
| 1192592 | Curr Yr Bal Sheet Date | Datetime | 12/31/2026 00:00:00 |
| 1192594 | Prev Yr Bal Sheet Date | Datetime | 12/31/2019 00:00:00 |
| 1192596 | Borrower Registration Date | String | 04/24/2009 00:00:00 |
| 1192598 | Borrower Enrollment Date | String | 06/15/2010 00:00:00 |
| 1192600 | Borrower Account Type | String | Client |
| 1192604 | Call Report | String | Yes |
| 1192606 | Current Year | Number | 2021 |
🗁 Buscomp SQL :cBanking Product Operations
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1192712 | OpTypeCheck | String | Y |
| 1192714 | Borrower Id | String | 1-2VJ1391W |
| 1192716 | Company Category | String | |
| 1192718 | Borrower Count | Number | 1 |
| 1192720 | 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.050 seconds.Business ServiceEndWorkflow Siebel Operation
invoke method: Query🗁 Output
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1193327 | Siebel Operation Object Id | String | 1-2VJ139A0 |
| 1193329 | TEST Prod Code | Number | 2 |
| 1193333 | Legal Opinion | String | Fara Rezerve |
| 1193335 | 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 |
|---|---|---|---|
| 1193359 | Error Message | String | |
| 1193361 | 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 |
|---|---|---|---|
| 1193558 | 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 |
|---|---|---|---|
| 1193706 | Error Message | String | |
| 1193708 | 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 |
|---|---|---|---|
| 1193726 | Year3 | Number | 2018 |
| 1193728 | Year2 | Number | 2019 |
| 1193730 | 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 |
|---|---|---|---|
| 1193746 | Date Grater May | String | Y |
| 1193748 | Date Grater Mar | String | Y |
| 1193750 | NY Date 3 | Datetime | 12/31/2018 00:00:00 |
| 1193752 | NY Date 2 | Datetime | 12/31/2019 00:00:00 |
| 1193754 | 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 |
|---|---|---|---|
| 1193771 | 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.014 seconds.Business ServiceEndWorkflow Siebel Operation
invoke method: Query🗁 Output
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1193864 | Siebel Operation Object Id | String | * |
| 1193866 | Sector | String | Production |
| 1193868 | Risk Cd | String | High |
| 1193870 | Percent | String | 20 |
| 1193872 | Industr Code | String | 07290 - Mining of other non-ferrous metal ores |
| 1193874 | Source Code | String | Siebel |
| 1193876 | Real Act Flg | String | |
| 1193878 | Entry Id | String | 1-2VJ13970 |
| 1193880 | Ind Codes Left | Number | 4 |
| 1193882 | 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 branchpassedReal Act Flg 1
passed.WF StepBorrower Details Validation
Executing step: Real Act Flg ErrBusiness ServiceStartWorkflow Utilities
invoke method: EchoBusiness ServiceEndWorkflow Utilities
invoke method: Echo| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1193926 | Error Message | String | ‘Activity according to the statute?’, |
| 1193928 | Error Count | Number | 1 |
WF StepBorrower Details Validation
Executing step: Ind Codes Errors ExistStep branchpassedConnector 15
passed.WF StepBorrower Details Validation
Executing step: Required Err Msg3Business ServiceStartWorkflow Utilities
invoke method: EchoBusiness ServiceEndWorkflow Utilities
invoke method: Echo| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1193948 | Error Count | Number | 0 |
| 1193950 | Error Message | String | |
| 1193952 | Error Count Total | Number | 1 |
| 1193954 | Error Message Total | String | Industry Code ROW_ID: 1-2VJ13970. Not all required fields are filled in: ‘Activity according to the statute?’; |
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 |
|---|---|---|---|
| 1193966 | Entry Id | String | 1-2VJ13971 |
| 1193968 | Sector | String | Large scale production |
| 1193970 | Percent | String | 0 |
| 1193972 | Industr Code | String | 11020 - Making wine from grapes |
| 1193974 | Real Act Flg | String | |
| 1193976 | Risk Cd | String | Moderate |
| 1193978 | Source Code | String | Siebel |
| 1193980 | 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 branchpassedReal Act Flg 1
passed.WF StepBorrower Details Validation
Executing step: Real Act Flg ErrBusiness ServiceStartWorkflow Utilities
invoke method: EchoBusiness ServiceEndWorkflow Utilities
invoke method: Echo| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1194024 | Error Message | String | ‘Activity according to the statute?’, |
| 1194026 | Error Count | Number | 1 |
WF StepBorrower Details Validation
Executing step: Ind Codes Errors ExistStep branchpassedConnector 15
passed.WF StepBorrower Details Validation
Executing step: Required Err Msg3Business ServiceStartWorkflow Utilities
invoke method: EchoBusiness ServiceEndWorkflow Utilities
invoke method: Echo| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1194046 | Error Count | Number | 0 |
| 1194048 | Error Message | String | |
| 1194050 | Error Count Total | Number | 2 |
| 1194052 | Error Message Total | String | Industry Code ROW_ID: 1-2VJ13970. Not all required fields are filled in: ‘Activity according to the statute?’; Industry Code ROW_ID: 1-2VJ13971. Not all required fields are filled in: ‘Activity according to the statute?’; |
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 |
|---|---|---|---|
| 1194064 | Entry Id | String | 1-2VJ1396Z |
| 1194066 | Sector | String | ABCDcultura |
| 1194068 | Percent | String | 10 |
| 1194070 | Industr Code | String | 01500 - Activities in mixed farms (crop farming combined with animal husbandry) |
| 1194072 | Real Act Flg | String | |
| 1194074 | Risk Cd | String | Moderate |
| 1194076 | Source Code | String | DW |
| 1194078 | 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 branchpassedReal Act Flg 1
passed.WF StepBorrower Details Validation
Executing step: Real Act Flg ErrBusiness ServiceStartWorkflow Utilities
invoke method: EchoBusiness ServiceEndWorkflow Utilities
invoke method: Echo| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1194122 | Error Message | String | ‘Activity according to the statute?’, |
| 1194124 | Error Count | Number | 1 |
WF StepBorrower Details Validation
Executing step: Ind Codes Errors ExistStep branchpassedConnector 15
passed.WF StepBorrower Details Validation
Executing step: Required Err Msg3Business ServiceStartWorkflow Utilities
invoke method: EchoBusiness ServiceEndWorkflow Utilities
invoke method: Echo| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1194144 | Error Count | Number | 0 |
| 1194146 | Error Message | String | |
| 1194148 | Error Count Total | Number | 3 |
| 1194150 | Error Message Total | String | Industry Code ROW_ID: 1-2VJ13970. Not all required fields are filled in: ‘Activity according to the statute?’; Industry Code ROW_ID: 1-2VJ13971. Not all required fields are filled in: ‘Activity according to the statute?’; Industry Code ROW_ID: 1-2VJ1396Z. Not all required fields are filled in: ‘Activity according to the statute?’; |
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 |
|---|---|---|---|
| 1194162 | Entry Id | String | 1-2VJ13972 |
| 1194164 | Sector | String | Trade |
| 1194166 | Percent | String | 50 |
| 1194168 | Industr Code | String | 46330 - Wholesale of dairy products |
| 1194170 | Real Act Flg | String | |
| 1194172 | Risk Cd | String | Low |
| 1194174 | Source Code | String | Siebel |
| 1194176 | 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 branchpassedReal Act Flg 1
passed.WF StepBorrower Details Validation
Executing step: Real Act Flg ErrBusiness ServiceStartWorkflow Utilities
invoke method: EchoBusiness ServiceEndWorkflow Utilities
invoke method: Echo| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1194220 | Error Message | String | ‘Activity according to the statute?’, |
| 1194222 | Error Count | Number | 1 |
WF StepBorrower Details Validation
Executing step: Ind Codes Errors ExistStep branchpassedConnector 15
passed.WF StepBorrower Details Validation
Executing step: Required Err Msg3Business ServiceStartWorkflow Utilities
invoke method: EchoBusiness ServiceEndWorkflow Utilities
invoke method: Echo| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1194242 | Error Count | Number | 0 |
| 1194244 | Error Message | String | |
| 1194246 | Error Count Total | Number | 4 |
| 1194248 | Error Message Total | String | Industry Code ROW_ID: 1-2VJ13970. Not all required fields are filled in: ‘Activity according to the statute?’; Industry Code ROW_ID: 1-2VJ13971. Not all required fields are filled in: ‘Activity according to the statute?’; Industry Code ROW_ID: 1-2VJ1396Z. Not all required fields are filled in: ‘Activity according to the statute?’; Industry Code ROW_ID: 1-2VJ13972. Not all required fields are filled in: ‘Activity according to the statute?’; |
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 |
|---|---|---|---|
| 1194260 | Entry Id | String | 1-2VJ13972 |
| 1194262 | Sector | String | Trade |
| 1194264 | Percent | String | 50 |
| 1194266 | Industr Code | String | 46330 - Wholesale of dairy products |
| 1194268 | Real Act Flg | String | |
| 1194270 | Risk Cd | String | Low |
| 1194272 | Source Code | String | Siebel |
| 1194274 | 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.013 seconds.Business ServiceEndWorkflow Siebel Operation
invoke method: NextRecord🗁 Output
| # | Process Prop Name | Datatype | Process Prop Value |
|---|---|---|---|
| 1194401 | Borrower Id | String | 1-2VJ1391W |
| 1194403 | 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 |
|---|---|---|---|
| 1194432 | Borrower Details Validation | 1 | 1687 |
🗁 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 |
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 |
|---|---|---|---|
| 1194437 | 6 Error Count | Number | 4 |
| 1194439 | Error Message | String | Industry Code ROW_ID: 1-2VJ13970. Not all required fields are filled in: ‘Activity according to the statute?’; Industry Code ROW_ID: 1-2VJ13971. Not all required fields are filled in: ‘Activity according to the statute?’; Industry Code ROW_ID: 1-2VJ1396Z. Not all required fields are filled in: ‘Activity according to the statute?’; Industry Code ROW_ID: 1-2VJ13972. Not all required fields are filled in: ‘Activity according to the statute?’; |
End of Part 17