1 / 6

THE CLEARING HOUSE

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.

meg
Download Presentation

THE CLEARING HOUSE

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. THE CLEARING HOUSE Anna, Emil & Stian

  2. Roles • Team LeaderEmil • DocumenterAnna • Time KeeperStian • DeveloperTeam • TesterTeam • XML Data Manager Anna } We all worked together, as a team with the solution.

  3. 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

  4. 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;

  5. 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

  6. 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 )

More Related