forms to apex - nloug · forms to apex customer case “one does not discover new lands without...
TRANSCRIPT
Forms to APEXCustomer case
“One does not discover new lands without consenting to lose sight of the shore for a very long time.”
Andre Gide
• Consultant since 2006 at TSS
PinkRoccade Local Government
• Product Owner since nov. 2016 at
Stadsbeheer BV
• Special interest business requirements
Bart Prinsen
Application for governments to
manage changes and enforce
regulations in the public area.
Stadsbeheer LEEF
• Rebuilt Forms application into APEX
• Transform Forms screens to smart and
simple APEX-pages
• Enhance UI & UX
• Keep core engine unchanged
Assignment to SMART4Solutions
• Oracle developer since 1998
• Started as classic developer, now
APEX
• Special interest in UI / UX
• Bootstrap theme / Skillbuilders
• Managing partner SMART4Solutions
Sergei Martens
• +/- 40 government organisations
• +/- 2500 active users
• +/- 250 forms (fmb)
• +/- 530 tables
• +/- 750 modules of PL/SQL code
Statistics
Less code
HTML5
Multi tenant
Easier tomaintain
Faster
Modern
Easier to useImprove
Migrate to ApexWithin seven months
Project approach
• Start with smallest and biggest challenges
• Distributed scrum, weekly office meeting
• Two weekly sprints
• Changing team members
Sprint velocity
150
200 200 200 200 200
150
50 50
200
250
300 300
150
may jun jul aug sept okt nov dec
Planned Actual
Lessons learned #1
• Good infrastructure & access to Forms
• Start with design patterns & templates
• Start with a stable toolset
• Start with biggest challenges
• Product owner availability
Lessons learned #2
• Build close to Apex when possible
• Logger
• Distributed when programming
• Centralized when finishing
• Multiple applications
• Change team members when needed
User interface layer
Webservice interface layer (API) MULTI TENANT layer SBA CORE
Archtiecture database possible future
OWSBA
OWMENV
SBA_UIAPEX
SBA_VPD
SBA_RESTORDS
Google search
Table 1mview
logMaterialized
View 1Table 2
mview
log
Table 3mview
log
Table 4mview
log
Table 5mview
log
Table 6mview
log
Materialized
View 2
Materialized
View 2
Oracle
text
index
Oracle
text
index
Oracle
text
index
SBACS
Google search
MVIEW refresh every 5 minutes