Integrations Lead - Lessons learnt

 Integrations have been my passion for a while but like anything tech there is no credit given when things go right but always heaps of pressure when things go wrong. Putting together some of my lessons learnt -

1. Get the functional specifications signed off by business, these are pushed away due to lack of understanding, time pressures etc.

2. Give special focus for elements which are customer facing like Invoice Print or Invoice numbering for Payment systems. Remittance advices etc

3. Focus on ensuring the COA mapping is accurate to the multiple levels. One level mapping is easy but multi level is always a tricky things to get it right.

4. Focus on ensuring all the elements from source can be pushed into Oracle in one shape or form to aid with reconciliation. Example AR Lockbox ensure rules are defined at customer and transaction number level rather than just one level.

5. No one focuses on a generic end to end test case for loaded data, but having a discussion and capturing the detailed tests will mean no surprises when the interface data is processed after Go Live.

More to be updated.

Oracle BI Get users with a role

 Very handy query to get all users with a given role.

SELECT pu.username,
       prdt.role_id,
       prdt.role_name,
       prd.role_common_name
FROM   per_user_roles pur,
       per_users pu,
       per_roles_dn_tl prdt,
       per_roles_dn prd
WHERE  pu.user_id = pur.user_id
       AND prdt.role_name LIKE 'IT Security Manager'
       AND prdt.role_id = pur.role_id
       AND prdt.role_id = prd.role_id
       AND prdt.language = Userenv ('lang')
       AND pu.active_flag = 'Y'
ORDER  BY pu.username,
          prdt.role_name 

OIC Blogs

 Error Handling - https://www.linkedin.com/pulse/error-handling-oracle-integration-cloud-harris-qureshi/