Create an Algorithm for an FOP Report
Before creating any new custom FOP report an algorithm is created which contains the following content:
-
Query for the report
-
XML formation code
-
Input parameter validation
-
Call to report generation algorithm
The algorithm is then associated with the FOP report while defining the FOP report in the application. When the FOP report is generated, the algorithm which is attached to the FOP report does the following:
-
Extract data from the system in an XML file
-
Present the extracted data in CSV, JSON, PDF, XML, or XLS format using the XSL file associated with the FOP report
The following algorithms for the corresponding FOP reports are shipped with ORMB:
| FOP Report | Report Generation Algorithm |
|---|---|
| FOPADJBXLS | C1_FOPADJUST |
| FOPADJOXLS | |
| FOPAGEBPDF | C1_FOPAGING |
| FOPAGEOPDF | |
| FOPAGEHCBPDF | C1_FOPAGEHC |
| FOPAGEHCOPDF | |
| FOPAGEHCBXLS | C1_FOPAGEHC |
| FOPAGEHCOXLS | |
| FOPAPAYHBPDF | C1_FOPAPAY |
| FOPAPAYHOPDF | |
| FOPAPAYHBXLS | C1_FOPAPAY |
| FOPAPAYHOXLS | |
| PLSM_DETEXL | C1-PLDETXCL |
| PLSM_SMRYEXL | C1-PLSMEXCL |
| FOPBIPAHBPDF | C1_FOPBIPA |
| FOPBIPAHOPDF | |
| FOPBIPAHBXLS | C1_FOPBIPA |
| FOPBIPAHOXLS | |
| DCMR | C1-DLCMPRRPT |
| DLDWLD | C1-DLDWLD |
| DEEEXCEL | C1-DLEXTEXCL |
| DEIEXCEL | C1-DLINTEXCL |
| DEIPDF | C1-DLINTPDF |
| DLPRTEXLR | C1-DLPRTEXLR |
| DEEPDF | C1-DLEXTPDF |
| FOPDDROPDF | C1_FOPDEBIT |
| EFPR_EXT_PDF | C1-EFFPRPDF |
| EFPR_EXT_EXL | C1-EFFPREXL |
| FOPASLHCBPDF | C1_FOPASLHC |
| FOPASLHCOPDF | |
| FOPASLHCBXLS | C1_FOPASLHC |
| FOPASLHCOXLS | |
| FOPSSLHCBPDF | C1_FOPSSLHC |
| FOPSSLHCOPDF | |
| FOPSSLHCBXLS | C1_FOPSSLHC |
| FOPSSLHCOXLS | |
| FOPHLDBXLS | C1_FOPHOLD |
| FOPHLDOXLS | |
| FOPPADGHBPDF | C1_FOPPADTGH |
| FOPPADGHOPDF | |
| FOPPADGHBXLS | C1_FOPPADTGH |
| FOPPADGHOXLS | |
| FOPPADIHBPDF | C1_FOPPAYHDT |
| FOPPADIHOPDF | |
| FOPPADIHBXLS | C1_FOPPAYHDT |
| FOPPADIHOXLS | |
| FOPPAYDTBPDF | C1_FOPPAY |
| FOPPAYDTOPDF | |
| FOPPASGHBPDF | C1_FOPPAHGSM |
| FOPPASGHOPDF | |
| FOPPASGHBXLS | C1_FOPPAHGSM |
| FOPPASGHOXLS | |
| FOPPASMHBPDF | C1_FOPPAYHSM |
| FOPPASMHOPDF | |
| FOPPASMHBXLS | C1_FOPPAYHSM |
| FOPPASMHOXLS | |
| FOPPAYSMBPDF | C1_FOPPAY |
| FOPPAYSMOPDF | |
| FOPWRORBPDF | C1_FOPRWO |
| FOPWROROPDF | |
| FOPWRORBXLS | C1_FOPRWO |
| FOPWROROXLS | |
| FOPTODOOPDF | C1_FOPTODO |
| FOPTODOBPDF | |
| FOPTODOOXLS | C1_FOPTODO |
| FOPTODOBXLS | |
| FOPTRDTBXLS | C1_FOPTXNREG |
| FOPTRDTOXLS | |
| FOPTRSMBXLS | C1_FOPTXNREG |
| FOPTRSMOXLS | C1_FOPTXNREG |
| FOPUSROPDF | C1_FOPUSER |