getARTransactionTxn1227.txp

specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.

lockTxnCtrl determines whether the sendARTransaction 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 the next scheduled execution.

If lockTxnCtrl returns True, it means that the service is ready to execute. It locks the AR Transaction row in the control table and updates it so that the status changes to be INPROCESS. This prevents any other AR Transaction service from executing.

getARTransactionTxn service queries the Oracle Applications database for any AR Transaction. The number of records returned depends on the parameter value specified in noOfRowsToFetch parameter in the specifyDefaultSettings map.

processBizDoc sends the business document to a trading partner. You must customize this step to receive a Success or an Error status of the document transfer. The document transfer status information should be sent back to the calling service (sendARTransaction). The document transfer status passed back should have the document identifiers along with the transfer status of SUCCESS or ERROR and Error information for the particular document which has not been transferred successfully to the trading partner.

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. The 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. The purgeTrackChanges service purges the records from the WM_TRACKCHANGES table.

Loop against each document and based on the Transfer Status, insertTransferERRInfo inserts a new record in the WM_TRACKCHANGES table so that same document can be picked up during the next polling interval.

unlockTxnCtrl service releases the lock on the Custom Control table so that next polling instance of sendVendor service can begin.

getLastError service logs any flow service execution errors in the above steps.

1.0 TRANSACTIONS

1.1 TRANSACTION_LINES

1.1.1 TAX_LINES

1.1.1.1 GL_DISTRIBUTIONS

1.1.2 FREIGHT_LINES

1.1.2.1 GL_DISTRIBUTIONS

1.1.3 SALES_CREDITS

1.1.3.1 GL_DISTRIBUTIONS

1.1.4 GL_DISTRIBUTIONS

1.2 CHARGES

1.2.1 GL_DISTRIBUTIONS

1.3 FREIGHT_LINES

1.3.1 GL_DISTRIBUTIONS

1.4 DEFAULT_SALES_CREDITS

1.5 NOTES

1.6 GL_DISTRIBUTIONS