Avaloq ACP (DL)
Self-made preparation questions for the "Avaloq Certified Professional" exam
Self-made preparation questions for the "Avaloq Certified Professional" exam
-
- 1 / 267
-
Lernkarten
Naming conventions for DDICs?
- memory layer: mem_doc_xy
- order persistence layer: doc_xy
- kernel data: obj_xy
- datamart: dtm_xy
Data types within data dictionaries?
- base types
- references / ID types (primary keys of table records or objects)
- object types (links to table records or business object instances)
How can be classifications of objects be directly accessed by their name in a data dictionary?
- my_bp.class("bp_custr_type").name
- my_bp.extn.bp_custr_type.name
How are automatically calculated fields designated in a data dictionary?
- they have two entries
- the entry with ..._a (boolean) indicates whether it has been automatically calculated (+) or overruled (-)
3 parts of a data dictionary?
- fields
- methods
- constructor(s)
Types of fields in a data dictionary?
- simple fields (single value, get/set)
- fields with input parameters (multiple values, indexed with formal parameter, get/set)
- list fields (multiple values that can be looped over)
Which possible behaviours do result from an order validation?
- validation passed: proceed and execute workflow commands
- error: order remains in original wfc state; user has to correct data and retry
- warning: an overide message is shown; user with appropriate access rights can override
What is the sequence of events of which order validation is a part of, when a workflow action is issued?
- system validation
- order validation
- execution of workflow commands
In which memory layer is workflow validation executed?
memory layer
Which Avaloq Script command can an error message be raised in an order validation?
session.raise_ui_err(error_code_id);
Which Avaloq Script command can override message be raised in an order validation?
doc.chk_override(20001);
Which sources are important for the order validation of the business type BP?
- CODE_UI_ERR.CSS (CODE TAB): custom error messages
- CODE_OVERRIDE (CODE TAB): override messages
- BP (DOC VALID): constraints and checks
Which tables are relevant for order validation?
- CODE_UI_ERR
- CODE_OVERRIDE
- DOC_TAB_OVERRIDE (logged overrides of override messages)
Structure of a DOC VALID source?
[Order Validation 1.0]
validation of country
-- constraints
-- checks
end validation
Structure of a constraint in a DOC VALID source?
constraint my_little_constraint
if ... then
-- raise error or override message
end if;
end
Structure of a check in a DOC VALID source?
order_type "A"
state "A.B"
action "A.B.C"
check my_constraint_1, my_constraint_2
end
end
end
AMI: characteristics of messages?
- text-based
- structured data
- according to standards
AMI: types of messages?
- external message: formatted according to network standard
- internal message: AMI-internal format
AMI allows to connect the ABS to ...
- third-party systems
- the external world
- bank-internal systems such as e-banking or ATM
- other BUs in the same instance
Architecture for connecting ABS to external world?
MOM / adapters / EMI / AMI
Components of the AMI?
- input components:
- message parser
- message handler
- output components:
- message builder
- message formatter
What can trigger a message to be sent via the AMI?
- settlement plan
- workflow action
What does the message builder do?
- fills in data via DDIC of the corresponding order and that of the internal message
- stores generated internal message in the table MSG (status: "ready_to_send")
What does the message formatter do?
- stores formatted message in table MSG_EXTL_OUT
- message queue MSG_OUT contains the message ID and transmission information
- status of internal message in MSG is set to "sending"
Number of task to insert messages for debugging purposes?
981
Message creation process in AMI?
Data --> doc (e.g. mem_doc_pay) --> message builder --> internal message (mem_msg_...; table MSG) --> message formatter --> external message (MSG_EXTL_OUT)
Process for intepretting an incoming message?
external message (table MSG_EXTL_IN) --> message parser --> internal message (mem_msg_..., MSG table) --> message handler --> doc (e.g. mem_doc_pay) --> data
Market Data interface for share prices: tables?
- from generic source: LD_MD_DIRECT
- from Telekurs: MP_RBA_LD
- target: OBJ_ASSET_PRICE
Market Data Interface for Forex, deposit rates, swap rates: tables?
- source is Thomson Reuters
- source tables: LD_MP, LD_MD
- target: OBJ_TS_REP
Tables relevant for AMI?
- CODE_NETW
- MSG (internal messages)
- CODE_MSG_STATUS
- MSG_EXTL_IN and MSG_IN
- MSG_EXTL_OUT and MSG_OUT
List the sources relevant for AMI (naming/type)?
- SWIFT (NETW)
- SWIFT (NETW STRUCT)
- SWIFT.MT150 (MSG STRUCT)
- SWIFT.MT150.IN (MSG IN)
- SWIFT.MT150.OUT (MSG OUT)
Structure of a NETW source?
[Network 1.0]
network swift
outgoing
...
incoming
...
handle_error
...
end network
Structure of a MSG STRUCT source?
[Message Structure 1.0]
message structure swift.mt105
message compound
order_type ot
business_partner bp
amount amt
end
end message structure
2 ways of customising forms?
- standard form override
- creation of a custom form
What is the advantage of a standard form override compared to the creation of a custom form?
field mapping doesn't change; so when Avaloq changes a field mapping, the override source doesn not have to be adapted
What is possible in a standard form override?
- optional field > mandatory
- editable field > non-editable
- restrict the fields of a look-up form
- hide/add tabs
- adjust tab order
- change form logic (event-handler)
Which table maps a meta type to the ABS GUI ribbon?
CODE_UI_META_TYP_MAP
Alias for mem_doc_xy in a form source?
doc
How does a subwindow definition start?
[Form 1.1]
win definition bp.favourites_02 (8302)
connect mem_doc_extn_acad_favourites_02 as doc
...
How does a win definition source differ from a doc definition source?
- no tab definition
- no doc notify handler
- explicit DDIC binding (connect)
