Avaloq ACP (DL)

Self-made preparation questions for the "Avaloq Certified Professional" exam

Self-made preparation questions for the "Avaloq Certified Professional" exam

Dominik Langer

Dominik Langer

Kartei Details

Karten 267
Lernende 151
Sprache English
Kategorie Informatik
Stufe Andere
Erstellt / Aktualisiert 29.01.2013 / 07.11.2024
Weblink
https://card2brain.ch/box/avaloq_acp_dl
Einbinden
<iframe src="https://card2brain.ch/box/avaloq_acp_dl/embed" width="780" height="150" scrolling="no" frameborder="0"></iframe>

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)