Showing posts with label How to load XML file data into Oracle Apps database tables. Show all posts
Showing posts with label How to load XML file data into Oracle Apps database tables. Show all posts

How to load XML file data into Oracle Apps database tables

Following is the script to insert XML data from a file to oracle database tables

INSERT INTO XX_ONRPTS_STG_TAB (DOCUMENT_NUM,
                               HEADER_ID,
                               RELEASE_NO,
                               RELEASE_ID,
                               DOCUMENT_LINE_NUM,
                               ITEM_NUM,
                               REC_QUANTITY,
                               LINE_ID,
                               LINE_LOCATION_ID,
                               TRANSACTION_ID,
                               FILE_NAME)