setJournalTxn1227.txpDatabase Script | Description |
wm_install_into_journal.sql | Runs all the scripts listed below, except the uninstall script. |
wm_into_journal_pkg.sql | Installs WM_JOURNAL_IMP_HANDLER_PKG. WM_HANDLE_JOURNAL, which calls the WM_CONC_REQUEST.WM_REQUEST_SUBMIT procedure to submit the journal concurrent process. |
wm_drop_into_journal.sql | Uninstalls all components created by wm_install_into_journal.sql. |
setJournalTxn1227.txpJournalTransactions1227.txpspecifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.specifyConcProgParams specifies the default parameter settings required for concurrent program execution. You should change these settings accordingly.pickSequence generates the current sequence number from the GL_INTERFACE_CONTROL_S sequence.bizDocMapping maps the incoming business document structure to the required Oracle Applications data structures (interface tables). This service uses the following services internally to provide required data feed during the mapping.getOASystemDate maps the current date as a date-object.getOracleAppsUserId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes ORACLE_APPS_USER_NAME as the input parameter from the business document, and queries the table FND_USER to get the USER_ID. The USER_ID information is required for insertion into the interface tables.getSOBId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes SET_OF_BOOKS_SHORT_NAME as the input parameter and queries the table GL_SETS_OF_BOOKS and gets the SET_OF_BOOKS_ID.convertToDateObject converts a datestring to the date-object.getEncumTypeId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes ENCUMBRANCE_TYPE as the input parameter and queries the table GL_ENCUMBRANCE_TYPES to get the ENCUMBRANCE_TYPE_ID.getBudgetVersionID is a transformer for mapping the business document IData structure to the interface table IData structure. It takes BUDGET_NAME as the input parameter and queries the table GL_BUDGET_VERSIONS and gets the BUDGET_VERSION_ID corresponding to the BUDGET_NAME.getCodeCombinationID is a transformer for mapping the business document IData structure to the interface table IData structure. It takes CONCATENATED_SEGMENTS and SETS_OF_BOOKS_NAME as the input parameters and queries the tables GL_CODE_COMBINATIONS_KFV and GL_SETS_OF_BOOKS to obtain the CODE_COMBINATION_ID.setJournalTxn inserts data into the interface table. It extracts data form the IData structure resulted in the bizDocMapping service and puts the data into the interface table in Oracle Applications for GL.importJournal imports data to the production table from the interface table. It then calls the execJournalConcProg, checkIntefaceTabStatus, and getJournalImport_ERR services to execute the corresponding concurrent program that inserts data into the production table to generate the error or acknowledgement message. If the status of the execution is SUCCESS (returned by the service execJournalConcProg), it checks for the record having the returned request ID in interface table and indicates an error during import. In this case, this service calls getJournalImport_ERR to retrieve the errors. If no record is found, it comes out of the flow indicating success of the data import process. If the status of the execution is FAILED it returns appropriate error message and comes out of execution.execJournalConcProg invokes the stored procedure Wm_Journal_Imp_Handler_Pkg.WM_HANDLE_JOURNAL that calls the corresponding concurrent subroutine to execute the data import process for Journal Entry into Oracle Applications. This service outputs the status of the execution and the request ID that has been generated for the request posted in Oracle Applications for the concurrent program.checkJournalImportStatus checks the status of the execution return by callJournalImport. It returns the number of rows in the interface table for a specific request ID.getJournalImport_ERR gets the error message that occurs during the data import to the production table from interface table. Based on the parameter request ID, it scans table GL_INTERFACE to get the corresponding message matches to the request ID.GLField Name | Maps to Column | Description |
SET_OF_BOOKS_ SHORT_NAME | SET_OF_BOOKS_ID | Required. Accounting books defining column. Mapping required from GL_SETS_OF_BOOKS table. |
ACCOUNTING_DATE | ACCOUNTING_DATE | Required. Effective date of the transaction; maps directly. |
CURRENCY_CODE | CURRENCY_CODE | Required. Currency code. This field maps directly. |
DATE_CREATED | DATE_CREATED | Required. System date. DATE_CREATED from a business document is not used. |
CREATED_BY | CREATED_BY | Default. CREATED_BY from a business document is not used. |
ACTUAL_FLAG | ACTUAL_FLAG | Required. Balance type (actual, budget, or encumbrance). This field directly. |
CATEGORY_NAME | USER_JE_CATEGORY_ NAME | Required. Journal entry category user defined name. This field maps directly. |
SOURCE_NAME | USER_JE_SOURCE_ NAME | Required. Journal entry source user defined name. This field maps directly. |
CURRENCY_CONVERSION_ DATE | CURRENCY_CONVERSION_ DATE | Date of exchange rate. This field maps directly. |
ENCUMBRANCE_TYPE | ENCUMBRANCE_TYPE_ ID | Encumbrance type defining column; mapping required from GL_ENCUMBRANCE_TYPE table. |
BUDGET_NAME | BUDGET_VERSION_ID | Budget version defining column; mapping required from GL_BUDGET_VERSIONS. |
USER_CURRENCY_ CONVERSION_TYPE | USER_CURRENCY_ CONVERSION_TYPE | Currency conversion type; maps directly. |
CURRENCY_CONVERSION_ RATE | CURRENCY_CONVERSION_ RATE | Foreign currency exchange rate; maps directly. |
ENTERED_DR | ENTERED_DR | Transaction debit amount. Entered currency; maps directly. |
ENTERED_CR | ENTERED_CR | Transaction credit amount. Entered currency. This field maps directly. |
ACCOUNTED_DR | ACCOUNTED_DR | Transaction debit amount. Base currency. This field maps directly. |
ACCOUNTED_CR | ACCOUNTED_CR | Transaction credit amount. Base currency. This field maps directly. |
REFERENCE | REFERENCE1 | Journal import reference column, which is the batch name for the journal. This field maps directly. |
BATCH_NAME | Journal entry batch defining column. Not used. | |
PERIOD_NAME | PERIOD_NAME | Period name. This field maps directly. |
ACCOUNT_CODE | CODE_COMBINATION_ ID | Combination defining column; mapping required from GL_CODE_COMBINATIONS table. |
STAT_AMOUNT | STAT_AMOUNT | Statistical amount. This field maps directly. |
INVOICE_DATE | INVOICE_DATE | DATE value-added tax descriptive flexfield column. This field maps directly. |
TAX_CODE | TAX_CODE | Value-added tax descriptive flexfield column. This field maps directly. |
INVOICE_IDENTIFIER | INVOICE_IDENTIFIER | Value-added tax descriptive flexfield column. This field maps directly. |
INVOICE_AMOUNT | INVOICE_AMOUNT | Value-added tax descriptive flexfield column. This field maps directly. |
USSGL_TRANSACTION_ CODE | USSGL_TRANSACTION_ CODE | Government transaction code. This field maps directly. |
JGZZ_RECON_REF | JGZZ_RECON_REF | Global reconciliation reference. This field maps directly. |
AVERAGE_JOURNAL | Average journal flag. This field is not used. | |
ORIGINATING_BAL_ SEGMENT_VALUE | ORIGINATING_BAL_ SEG_VALUE | Originating balancing segment value. This field maps directly. |