You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Transform payment terms data given in excel format into XML

edited Jan 30, 2019 4:31PM in Receivables & Collections 4 comments

Summary

Transform payment terms data given in excel format into XML so that it can be loaded via FSM

Content

We recently created a process to transform Receivables Payment Terms Data given in excel format into XML
so that it can be loaded via FSM.

Below are basic steps to be followed.

1. Convert the data into header and Lines (details) format.
2. Load data into staging table
3. Prepare and run the sql query using XMLELEMENT & XMLFOREST etc to transform data into XML
4. Load XML data from FSM.

Attached document has more details including objects like table creation script, SQL Loader, SQL query

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!