Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Managing Cash , EBS and SWIFT

Posted on May 18th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

In last couple of years, IT and Internet open the new door not only to IT Finance Managers but also Corporate Treasurers .The role of treasurers is more demanded and expectation with their banking partner have been greatly increased Changing Banking Relationships, Single Bank Model ,globalization , SWIFT corporate access and XML and end to end Integration with In house accounting system are some of the key points that enforce treasury department to look options with usage of Technology by either in building custom online applications or integrated and modified products From commercial vendors of ERP.

Lets start the topic of Treasurer Dilemma for exploring Integration of Oracle ERP with SWIFT Network.Here is one of case where treasurers seeking information with Oracle.

greyBarrowBackground

- Currently using Oracle E-Business Suite and planning to generate e-files from AP and Treasury modules and transfer it to SWIFT.
- Came to know that many messages stating that Oracle is developing some applications that would help integrate the e-business suite with SWIFT.
- As Oracle Treasury has the ability to generate MT 100. ( Assume AP has this functionality).

greyBarrowIssues

  • MT 100 is outdated. Currently SWIFT uses only MT 101 and MT 103 for payment instructions.
  • Treasury settlements are confirmed using message types (MT) 300, 320 etc.
  • The account statements are received from the bank through a MT 940.
  • Can Oracle Treasury or Cash Management accept data from MT 940.
  • Can Oracle GL create MT 940 (account statements) for our subsidiaries.

greyBarrowInformation needed

  • Does Oracle have an application that would create SWIFT messages (currently used and recognized)?
  • What is the cost of this application? License fee, period of license etc.
  • Is this application scalable i.e. would it support different Message types.
  • Would the application keep itself abreast with the modifications made by SWIFT to its MT?

greyBarrowThe outcome Answer

Currently in 11i release of Oracle Applications , Treasury or Cash Management modules are not able to generate SWIFT format messages.
The only thing related to SWIFT940 or MT940 format is that Cash Management can load bank statements provided from your bank in this standard format , that s the only thing manages in Oracle Application for this format .

I think there are certainly some 3rd Part Software which can help you to reach what you want , but Oracle Standard Support does not know these softwares . Buy some other middleware that would create SWIFT messages from data provided by Oracle ERP system.

greyBarrowIntegration aspect with Treasurer/Cash Management Area

Treasury lies at the financial heart of the organization due to the strategic decision-making these specialized financial professionals take part in. As the role of treasury departments continues to change, some of the traditional challenges have become less critical, while new challenges have emerged.On the top of that, there are mainly four area where any ERP consultant should know the integration aspect based out of box functionality.

  • Information reporting : BAI,SWIFT MT940, MT942 MT950,standard reports, ad hoc reports
  • Payments: ACH (all entry classes), SWIFT MT101, MT103,MT210, ISO 20022 XML, IFX,OFX, Account Transfer,recurring non-recurring, drawdowns,Netting , netting settlement,MT 3XX (300, 320, etc) for treasury deals confirmations (spots, swaps, forwards, options) ,MT 54X, securities settlement messages
  • Check services: Inquiry, stops,positive pay, image integration,check ordering
  • User & Security maintenance: Account based permission, functional based permissions, Distributed ,user maintenance.

greyBarrowMoving forward

I am going to bring few post about the integration aspect with Banking Patner with focus on EBS out of box fubctionality and SwiftNet .Hopefully these post might be very helpful line managers , EBS implementation consultant who are exploring the bank Integration.

greyBarrowSimilar Post

Related Posts

Posted in Cash Management, Oracle Application, Oracle Treasury | 2 Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
2 Responses
  1. Oracle EBS & Swift.. Says:

    […] EBS & Swift..Managing Cash , EBS and SWIFTStep by Step : ‘AuditTrail’Are you seeking auditing ability in EBS…use […]

  2. Implementing SWIFT MT’s within EBS Says:

    […] SWIFT MT’s within EBSManaging Cash , EBS and SWIFTOracle EBS & SWIFTStep by Step : ‘AuditTrail’Are you seeking auditing ability in […]

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.