I’ve been doing some work on a POC for embedded BIP and will be writing a few things about it’s functionality.
Previously all intermediate files and PDF files were only available temporarily while the process was running, now this has all changed.
When BIP is enabled for a report in E1, the report produces an XML file which is the raw data and it also produces all of the output files - which JDE also stores - in tables!
· F95630 contains the XML data created from the UBE run.
· F95631 contains the actual output files.
So, VERY easily a UBE could be written or a DB procedure to extract the files to a flat file location.
Note that you can also activate some JDE.INI settings to write them to the local machine, and therefore script them out to another dir too:
[UBE] section
BipSaveOutputOnFs= 0 or 1
A value of 1 enables the archiving of Report Definition Output. The default value is 0 (zero). If the value is 0, archiving is turned off and report output is saved only in the F96531 table, not in the file system.
BipOutputDirectory=
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=HOWTO&id=816003.1
A client that does a lot of XMLP / BIP will need to be very wary of growth in this tablespace.
No comments:
Post a Comment