The parameters for the AutoInvoice Master Program do not allow selective documents to be processed by the program in an instance of the flow. Therefore, the program execution also processes documents not inserted into interface tables during that instance of the flow.

Although import errors are logged in tables, you cannot selectively retrieve errors for documents loaded during an instance of the flow. All errors for the Batch Source Name will display in the flow.

setAutoInvoiceTxn1227.txp

AutoInvoiceTransactions1227.txp

specifyDefaultSettings 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.

bizDocMapping maps the incoming business document structure to the required Oracle Applications data structures (interface tables).

getSetOfBooksId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes SET_OF_BOOKS_NAME as the input parameter and queries the table GL_SETS_OF_BOOKS and gets the SET_OF_BOOKS_ID.

getInventoryItemId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes INVENTORY_ITEM and ORGANIZATION_NAME as the input parameters and queries the tables MTL_SYSTEM_ITEMS_B_KFV, ORG_ORGANIZATION_DEFINITIONS, to get the INVENTORY_ITEM_ID.

getTerritoryId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes TERRITORY_NAME as the input parameter, queries the table RA_TERRITORIES, gets the TERRITORY_ID.

getWarehouseId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes WAREHOUSE_NAME as the input parameter and queries the table HR_ALL_ORGANIZATION_UNITS to get the ORGANIZATION_ID.

setAutoInvoiceTxn inserts data into the interface tables.

importAutoInvoice imports data to the production table from the interface table. It calls the execAutoInvConcProg, checkAutoInvImportStatus, and getAutoInvoiceImport_ERR services to execute the corresponding concurrent program that inserts data into the production table and to generate the error/acknowledgement message. If the status of the execution is SUCCESS (returned by the service execAutoInvConcProg), it checks for the record with the current BATCH_NAME in the interface table. If any are found, it generates an error during import. In this case, this service calls getAutoInvoiceImport_ERR to retrieve the errors. If no record is found, it comes out of the flow and indicates that the data import process is successful. If the status of the execution is FAILED, it discontinues execution.

execAutoInvConcProg invokes the stored procedure WM_AUTOINVOICE_IMP_HANDLER_PKG.WM_HANDLE_AUTOINVOICE that then calls corresponding concurrent subroutine to execute the data import process for AutoInvoice into Oracle Applications. This service provides Status ID, Request ID, and Execution Status Message for normal concurrent program completion and a database Stored Procedure error message if an exception occurs in the Stored Procedure execution.

checkAutoInvImportStatus checks the status of the execution by checking the interface table for any rejected record corresponding to the current BATCH_SOURCE_NAME. If the query does not return any rows, it indicates a successful import. If the query returns any row, it indicates that the concurrent program could not import data successfully into the production tables of Oracle Applications.

getAutoInvoiceImport_ERR gets the error message that occurs during the data import to the production table from interface table. Based on the parameter BATCH_SOURCE_NAME, it scans the RA_INTERFACE_LINES_ALL and RA_INTERFACE_ERRORS_ALL tables to get the corresponding message for the BATCH_NAME.

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.2. CHARGES

1.2.2 GL_DISTRIBUTIONS

1.3 FREIGHT_LINES

1.3.1 GL_DISTRIBUTIONS

1.4 DEFAULT_SALES_CREDITS

1.5 NOTES