Send Journal Service
This service is in the WmOAFIN1227 package and has the following fully-qualified service name: generalLedger1227.fromOA.journal:sendJournal.
This service retrieves Journal information, such as general, recurring, mass allocation or reversing journal entries.
You must post the Journal entries to qualify them for sending to the trading partner.
While configuring the queryJournalTxn service, a java.outOfMemory error can occur. Because the database can have so many records, it would be unable to configure the service. One workaround is to use a restricting condition in the query, such as 1 = 2, so that the service configures successfully. After you have configured this service, remove the restricting condition from your transaction definitions. In addition, update the SQLOut parameters of the service’s transactionRecord in the Designer and remove the restricting condition. (In this example, remove the 1 = 2 condition.)
Database Scripts
This service uses the following database scripts:
Database Script | Description |
wm_install_from_journal.sql | Runs all the scripts listed below, except the uninstall script. |
wm_from_journal_vw.sql | Creates the following required view components for Journal outbound transactions:  WM_GL_JOURNALS_QRY_VW WM_GL_JOURNALS_VW |
wm_from_journal_trg.sql | Creates the following required trigger component to be used for writing to the WM_TRACKCHANGES table to indicate a new or updated document: WM_GL_JE_LINES_IU_TRG |
wm_disable_from_journal.sql | Disables the triggers installed by wm_from_journal_trg.sql. |
wm_enable_from_journal.sql | Re-enables the triggers installed by wm_from_journal_trg.sql. |
wm_drop_from_journal.sql | Uninstalls all components created by wm_install_from_journal.sql. |
For more information about using database scripts, see
Database Scripts.
Supporting Transaction Definitions
This service was built from the configured services defined in the following transaction definition:
getJournalTxn1227.txp
For information about using the transaction definition files to customize this service, see
Transaction Definitions.
Flow Control
The main flow executes as follows:
specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.
lockTxnCtrl determines whether the
sendJournal service is ready for execution. That is, it determines whether there is no other instance of this service already in process.
If
lockTxnCtrl returns False, it means that another instance of this service is already in process. The service exits and waits for next scheduled execution.
If
lockTxnCtrl returns True, it means that the service is ready to execute, the Journal row in the control table is locked and updated, and status is changed to INPROCESS. This prevents any other Journal service from executing.
getJournalTxn queries the Oracle Applications database for any Journal Transaction to be processed. The number of records returned depends on the parameter value specified in the above map.
processBizDoc is the customizable step that sends the business document to the recipient such as a trading partner by looping against each document. You must customize this step to receive a SUCCESS or an ERROR status of the document transfer along with the Error information. Transfer Status and any Error Information is logged against each document.
Loop against each document. Based on the Debug Mode specified during execution, it either purges or updates the records in the WM_TRACKCHANGES table.
If the Debug Mode is TRUE, the records in the WM_TRACKCHANGES table are updated and the PROCESSED_FLAG is set to Y. This ensures that same sets of records are not picked up during next polling interval.
updateTrackChanges service updates the PROCESSED_FLAG in the WM_TRACKCHANGES table to Y and PROCESSED_DATE to sysdate so that same information is not picked up again during next polling instance.
If the Debug Mode is FALSE, the records in the WM_TRACKCHANGES table are deleted.
purgeTrackChanges service purges the records from the WM_TRACKCHANGES table.
Loop against each document. Based on the Transfer Status,
insertTransferERRInfo service inserts a new record in the WM_TRACKCHANGES table so that same document can be picked up during the next polling interval.
unlockTxnCtrl releases the lock on the Custom Control table so that next polling instance of
sendVendor service can begin.
Using
getLastError service, any errors are logged. The
unlockTxnCtrl service executes to release the lock on the Custom Control table.
Business Document Structure
This service uses the following business document structure:
JOURNAL
JOURNAL
Document Field | Oracle Applications Table/View Name | Column Name | Description |
WEB_TRANSACTION_
ID | | | |
DOCUMENT_TYPE | | | Value is JOURNAL. |
DOCUMENT_
STATUS | | | Value is INSERT. |
JE_LINE_ID | GL_JE_LINES | JE_LINE_ID | Document identifier for outbound transactions. Not used for inbound transactions. |
SET_OF_BOOKS_
SHORT_NAME | GL_SETS_OF_
BOOKS | SHORT_NAME | Set of Books short name. |
ACCOUNTING_
DATE | GL_JE_
HEADERS | DATE_CREATED | |
CURRENCY_CODE | GL_JE_
HEADERS | CURRENCY_CODE | |
DATE_CREATED | GL_JE_
HEADERS | DATE_CREATED | |
CREATED_BY | | | |
CREATED_BY_
EMPLOYEE_NUMBER | PER_ALL_
PEOPLE_F | EMPLOYEE_
NUMBER | |
CREATED_BY_
NAME | PER_ALL_
PEOPLE_F | FULL_NAME | |
ACTUAL_FLAG | GL_JE_HEADERS | ACTUAL_FLAG | |
CATEGORY_NAME | GL_JE_HEADERS | JE_CATEGORY | |
SOURCE_NAME | GL_JE_HEADERS | JE_SOURCE | |
CURRENCY_
CONVERSION_
DATE | GL_JE_HEADERS | CURRENCY_
CONVERSION_
DATE | |
ENCUMBRANCE_
TYPE | GL_
ENCUMBRANCE_
TYPES | ENCUMBRANCE_
TYPE | |
BUDGET_NAME | GL_BUDGET_
VERSIONS | BUDGET_NAME | |
USER_CURRENCY_
CONVERSION_TYPE | GL_JE_HEADERS | CURRENCY_
CONVERSION_
TYPE | |
CURRENCY_
CONVERSION_
RATE | GL_JE_HEADERS | CURRENCY_
CONVERSION_
RATE | |
ENTERED_DR | GL_JE_LINES | ENTERED_DR | Entered debit. |
ENTERED_CR | GL_JE_LINES | ENTERED_CR | Entered credit. |
ACCOUNTED_DR | GL_JE_LINES | ACCOUNTED_ DR | Accounted debit. |
ACCOUNTED_CR | GL_JE_LINES | ACCOUNTED_ CR | Accounted credit. |
REFERENCE | GL_JE_LINES | REFERENCE_1 | |
BATCH_NAME | GL_JE_BATCHES | NAME | |
PERIOD_NAME | GL_JE_HEADERS | PERIOD_NAME | |
ACCOUNT_CODE | GL_CODE_
COMBINATIONS_
KFV | CONCATENATED_
SEGMENTS | |
STAT_AMOUNT | GL_JE_LINES | STAT_AMOUNT | Statistical amount. |
INVOICE_DATE | GL_JE_LINES | INVOICE_DATE | Date value added tax descriptive flexfield column. |
TAX_CODE | GL_JE_LINES | TAX_CODE | Value-added tax descriptive flexfield column. |
INVOICE_IDENTIFIER | GL_JE_LINES | INVOICE_
IDENTIFIER | Value-added tax descriptive flexfield column. |
INVOICE_AMOUNT | GL_JE_LINES | INVOICE_
AMOUNT | Value-added tax descriptive flexfield column. |
USSGL_TRANSACTION_
CODE | GL_JE_HEADERS | USSGL_
TRANSACTION_
CODE | Government transaction code. |
JGZZ_RECON_REF | GL_JE_HEADERS | JGZZ_RECON
_REF | Global reconciliation reference. |
AVERAGE_JOURNAL | GL_JE_BATCHES | AVERAGE_
JOURNAL_FLAG | |
ORIGINATING_BAL_
SEGMENT_VALUE | GL_JE_HEADERS | ORIGINATING_
BAL_SEG_VALUE | Originating balancing segment value. |
POSTED_DATE | GL_JE_HEADERS | POSTED_DATE | Date journal was posted. |