Before you can use these templates, you need to download and install the xls4oracle tool.
Insert GMD formula headers and details using GMD_FORMULA_PUB.INSERT_FORMULA. Pls. note that you need at least 2 lines for each formula: one product and one ingredient.
- Download: insert GMD Formula - posted 08-06-2010
Status: Validated – ready for prod
Load GMD Formula using GMD_FORMULA_PUB.INSERT_FORMULA and GMD_FORMULA_DETAIL_PUB.UPDATE_FORMULADETAIL.
- Download: Load GMD Formula - posted 23-11-2009
Status: Draft – need some valid data for test
Oracle documentation:
- Goto Oracle Integration Repository and search for internal name: GMD_FORMULA_DETAIL_PUB