Step1:Concurrent Program
Create a Concurrent Program with Exceutable File Name
as XDODTEXE
Step:2 Data Xml Template
Create a Data Xml Template for the Query
Step:3 Data Definitions
Create a Data Definition under XML Publisher
Administrator responsibility with the above XML Template.
Step:4 Excel Template
Define the Tag for Fields in the Excel Template in the
following Format:
Data elements: XDO_?element_name?
where XDO_ is the required prefix and
?element_name? is either:
the XML tag name from your data delimited by
"?"
a unique name that you will use to map a derived value
to the cell
?group_name? is the XML tag name for the parent
element in your XML data delimited by "?".
a unique name that you will use to define a derived
grouping logic.
Eg:
Tag for AR Invocie Posting Date : XDO_?AR_POSTING_DATE?
Tag for Group : XDO_GROUP_?G_HEADER?
The element name in XML data should match with the
field name in the tag.
For group, select the entire record and provide the
tag.
Step:5 Templates
Create a Templates under XML Publisher Administrator
Responsibility with the type as ‘Microsoft Excel’
Step: 6 Excel Output:
Oracle Fusion HCM Online Training
ReplyDeleteOracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Big Data and Hadoop Training In Hyderabad
Fantastic article post.Really thank you! Awesome.
ReplyDeletepythononline course
python online training from India
With a commitment to excellence, a focus on practical learning, and a supportive learning environment, WebTrainings remains the go-to destination for the "Best Digital Marketing Course in Hyderabad."
ReplyDeletehttps://www.webtrainings.in/digital-marketing-course-hyderabad/
Triotech Software Trainings offers comprehensive online training for Oracle Fusion HCM,signed to equip professionals with in-depth knowledge and skills in this powerful human capital management solution. Our expert trainers provide hands-on experience, covering key modules such as Core HR, Payroll, Talent Management, and more. Participants will gain proficiency in configuring, implementing, and managing Oracle Fusion HCM applications, enabling them to streamline HR processes and drive organizational success.
ReplyDeletehttps://triotechsoftwaretrainings.com/oracle-fusion-hcm-online-training/
Dr. Anubha's Homeopathy Clinic in Hyderabad is a well-known online resource for Classical homeopathy consultation and treatment. You can now access Dr. Anubha's web Homeopathic Clinic from the comfort of your own home, thanks to the convenience of current web technology. Under one roof, this Homeo Care Clinic provides complete solutions to all of your health difficulties. It is well-known as the top homeopathy clinic in Hyderabad, offering effective treatments for a variety of diseases.
ReplyDeletehttps://www.dranubha.com/