the clearing house n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
THE CLEARING HOUSE PowerPoint Presentation
Download Presentation
THE CLEARING HOUSE

Loading in 2 Seconds...

play fullscreen
1 / 6

THE CLEARING HOUSE - PowerPoint PPT Presentation


  • 118 Views
  • Uploaded on

THE CLEARING HOUSE. Anna, Emil & Stian. Roles. Team Leader Emil Documenter Anna Time Keeper Stian Developer Team Tester Team XML Data Manager Anna. }. We all worked together, as a team with the solution. How it all comes together. PO_Outbox. PO_Outbox. PO_Inbox. Norwegian Bank.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'THE CLEARING HOUSE' - meg


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
the clearing house

THE CLEARING HOUSE

Anna, Emil & Stian

roles
Roles
  • Team LeaderEmil
  • DocumenterAnna
  • Time KeeperStian
  • DeveloperTeam
  • TesterTeam
  • XML Data Manager Anna

}

We all worked together,

as a team with the solution.

how it all comes together
How it all comes together

PO_Outbox

PO_Outbox

PO_Inbox

Norwegian Bank

PO_Inbox

Finland Bank

ACK_Outbox

ACK_Outbox

ACK_Inbox

ACK_Inbox

PO_Outbox

ClearingHouseSEPA

PO_Outbox

PO_Inbox

PO_Inbox

ACK_Outbox

ACK_Outbox

ACK_Inbox

ACK_Inbox

Colchester Bank

Belgium Bank

business rules
Business Rules
  • Rule #02
    • System date
    • Altered to current local time
  • Rule #04
    • Only member banks
    • Checking bank id’s
  • Rule #07
    • Moving to failed table
  • Rule #21
    • Giving minus score

Example – Rule #7

create or replace TRIGGER "BI_PF_PO_REMOVEFAILED"

AFTER

insert on "PF_PO_FAILED"

for each row

begin

delete from PF_PO_TESTDATA

where PF_IS_MEMBERBANK (SB_BANK_ID) < 1;

end;

complications
Complications
  • Trigger problems
    • Porting over to failed box
    • Deleting the actual table row from test
  • New Parameter Procedure
    • Generating payments
    • 10 000 payments per script run
  • Generating competition sets
    • Trail version don’t support 40 000 rows
    • Had to export one set of 10 000 at a time
competition setup
Competition Setup
  • Swapping bank id’s
    • For 33 rows per xml set.
      • COBA to C0BA
      • FIBA to F1BA
      • NOBA to NOB4
      • BEBA to B3BA
  • Creating negative amounts
    • A bank should not process negative amounts
    • Changed 100 rows
  • Changing maximum amounts
    • Maximum = 50 000
    • Changed 50 rows to + 100 000
  • Numbers of errors
    • May vary, cause of the overlapping negative > maximum

Example

UPDATE PF_PO_COMPETITION_BEBA SET DB_BANK_ID = 'C0BA'

WHERE PO_ID IN

(

SELECT PO_ID FROM

(

SELECT ROWNUM R,T.PO_ID FROM PF_PO_COMPETITION_BEBA T

)

WHERE MOD(R,300) = 0

)