xmlandfsgcollab10
TRANSCRIPT
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
XML Publisher and FSG for Beginners
Alyssa JohnsonSusan Behn
Karen Brownfield
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Where is Karen
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Agenda• XML/BI Publisher Introduction• Needed patches for FSG• Setups• FSG Template Common Issues• FSG Process Flows• FSG Seeded Templates
– Differences, Advantages, Opportunities– Sample Formatting
• Report Manager• More Information/References
Copyright 2008 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered trademarks or service marks of their respective owners.
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
BI Publisher (formerly XML Publisher)
• XML Publisher– Included free as part of E–Business Suite (as long
as only used against EBS tables)– Current version 5.6.3
• 11i – 500 templates• R12.1 – all reports are BI Publisher
– 2724 templates• XML Publisher Administrator Responsibility
– Templates– Data Definitions
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
BI Publisher (formerly XML Publisher)
• Refer to BI Publisher Quick Start Guide– http://www.solutionbeacon.com/BIPublisherQuick
StartGuidePresentationc.pdf– http://www.solutionbeacon.com/BIPublisherQuick
StartGudepaper.pdf
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Needed FSG Patches• Apply Latest FSG Patch - How to Find It And
Verify It's Been Applied [ID 189282.1] – Identifies latest patches by release– Shows unix commands to verify what has been
applied• How To Determine Which FSG Patches Have
Been Applied In Release 11i, 12.0 and 12.1 [ID 549289.1]
• FSG Functional FAQ [ID 108236.1]
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Needed FSG Patches• As of 3rd February, 2010 the latest FSG patches
are: – 11.5
• 8640288 (with XML) • 9013928 (without XML)
– 12.0• 9182320:R12.RG.A• 9276305:R12.GL.A for FSG drilldown
– 12.1.1 and 12.1.2• 9182320:R12.RG.B• 9276305:R12.GL.B for FSG drilldown
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Other Specific Patches for FSG• 5887917 - Desktop Add–in for Word
– ORACLE XML PUBLISHER DESKTOP PATCH 5.6.3 – BI Publisher Desktop 10.1.3.2 contains the XML Publisher
5.6.3 core libraries and is intended to develop templates for XML Publisher 5.6.3
• Server Side, XML Publisher– XML Publisher part of ATG patches as of 11.5.10.2 RUP5– Application Short Name is XDO
• Server Side, XBRL Publisher – 5745329 (Optional)– Marries XML Publisher with XBRL taxonomies to produce
XBRL reports as required by outside agencies
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Setups
• Profile Options– Concurrent: Report Access Level
• Cannot be NULL at Site level• Set to U (User) or R (Responsibility)• FSG XML Publisher FAQ [ID 370358.1]
– FSG: Create Numbers in XML• Set to 'N' to block creation of attribute RealNum
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Setups
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Application Developer Profile• Create the profile option as shown below
• Then go back to system administrator, query this profile option and set it at the site level to your codeset value returned in the earlier sql statement
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Setups• When Oracle supports asks you to run a FSG
with "RG_DEBUG_ON" set to yes, or "FSG: Debug" set to yes, a new profile option must be created
• Since value is free-form, be sure to set to ‘Y’, not ‘Yes’
• How to create and use the RG_DEBUG_ON profile option [ID 435029.1]
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
• Create profile option as shown below
Application Developer Profile
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Setups• Temporary File
Directory– This is where the
report is generated– Responsibility 'XML
Publisher Administrator'
• Home | Administration• Open 'General'
– Apps user must have read/write privileges
• Cloning trouble spot!
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
FSG Template Common Issues• FSG Publishing with Report Manager using
Content Sets and Parallel Type Processing causes Error [ID 552592.1]– Cannot use parallel processing with content sets
• RGFSGXML One Step Program - Publish FSG Report Throws ORA-06550 PLS-00306 [ID 787396.1]– Issue with mismatch on number of parameters– Check your patch levels
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
FSG Template Common Issues• Request 'Xml Report Publisher' Erroring With
XDOException When Published In PDF Format [ID 417810.1] – Sequence/Position of columns must be in ascending order -
otherwise column width values become negative causing a java error
• Xml Publisher Drops Two Columns And Changes Template Alignment [ID 464418.1] – Don't overlap columns and position in ascending order
• Signal 11 Error – A memory error which can have several causes– The latest patchset addresses current bug – FSG definitions also can cause this error– Note: Large FSG reports sometimes cause this error
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
FSG process flows• Two step process
– Request FSG Report using XML as the output option, either from the Submit Financial Report window or from the Submit Request window (Program - Run Financial Statement Generator)
– From the concurrent manager, run the 'XML Report Publisher' process, applying the relevant template
• One step process - run the Program - Publish FSG Report from the Submit Request window
• Financial Report Submission from Report Manager
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Seeded Templates• Generic FSG Template
(GENERICFSG_en.xsl)• FSG: Basic Template (RGFSGXPB.rtf)• FSG: Fixed Number of Columns
(FSGTEMP.rtf)
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Generic FSG Template(GENERICFSG_en.xsl)• Seeded template for Report Manager• Should never be modified per How To Modify
The Generic FSG Template in Report Manager [ID 388130.1]
• If using XML Publisher to create a custom template for use in Report Manager and want to use this as the basis, upload as a new name– Note: same My Oracle Support ID states that
Report Manager does not provide method of creating generic template
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Creating Template in Report Manager• Navigate to Financial Report Template Editor
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
FSG: Basic Template (RGFSGXPB.rtf)
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
FSG: Basic Template (RGFSGXPB.rtf)
• FSG text output designed for four widths– 80, 132, 180, 255– Anything > 255 required export to spreadsheet
• XML subtracts margins from these totals using 10 CPI plus cell margin, for example– 8 ½ X 11 paper, landscape– Template has 1/2 inch margins, cell has .08 margin
• 132 minus 10 (margins) minus 2 (cell margin) minus 1 (currency format) = 119 maximum
– Must allow 1 extra space for any negatives if 'Currency: Negative Format' not set to: –XXX
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
FSG: Basic Template (RGFSGXPB.rtf)• Use 'Build Column Set' to verify ending
position of last column• If exceeds "allowable end column", report
wraps to next page
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
FSG: Basic Template (RGFSGXPB.rtf)• Font size of 'Report Data' element does not
shift horizontal placement– If get too big, wraps within the column
• Proportional fonts still align numbers• Negative Currency Format can cause number
to shift– Text version properly aligns numbers
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
FSG: Fixed Number of Columns (FSGTEMP.rtf)
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Both Templates
• Templates do not recognize – Lines to Skip– Page Break
• Templates do recognize– Underline Character– Indent
Spaces do not seem to appear in tag but they are there
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Report Manager• Separate Tool than Web ADI• My Oracle Support Documentation
– WebADI and Report Manager Webcasts for EBS 11i/R12 -- Replay is Now Available [ID 603169.1]
– List of Patches Released in Report Manager for Releases 11i and 12 [ID 726958.1]
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Same Parameters as Standard FSG
Submission
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Template with FSG Template
editorSecurity is Available
Availability
Reviewers
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Repository Management
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Create Menu Items for Reports
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
More information• Publisher Home Page
– http://www.oracle.com/technology/products/xml-publisher/index.html
• Publisher Demo Catalog– http://www.oracle.com/technology/products/xml-
publisher/demoshelf/Shelf.html• Publisher Blog
– http://blogs.oracle.com/xmlpublisher/• Publisher Forum
– http://forums.oracle.com/forums/forum.jspa?forumID=245
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Assessments Implementations• Strategic business assessments & ROI• Functional assessments• Technical assessments• IT roadmap planning• Acquisition integration• Software selection• Upgrade readiness
• ERP upgrades• ERP implementations• ERP migration and consolidation• Oracle Fusion Middleware - SOA• Develop industry specific front-end modules• Custom development• International dependencies and multi-org
Optimizations Support Services
• Business process re-engineering• Functional optimization• Technical optimization• System architecture optimization• Database tuning and optimization
• Functional and technical support• Focused knowledge transfer• Remote DBA support• Oracle instance hosting
Solution Beacon’s services are even better than our presentations
BOOTH
BOOTH27202720
STOP BY
STOP BY
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.37
Published Authority on Oracle
Published Books
National Publications
BOOTH
BOOTH27202720
STOP BY
STOP BY
Copyright © 2010 Solution Beacon, LLC All Rights Reserved Any other commercial product names herein are trademark, registered
trademarks or service marks of their respective owners.
Questions and AnswersAlyssa Johnson
[email protected] Behn
[email protected] Brownfield
www.solutionbeacon.comReal Solutions for the Real World ®