Receive Auto Invoice Service

Database Scripts

This service uses the following database scripts:

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 definitions:

• setAutoInvoiceTxn1227.txp
• AutoInvoiceTransactions1227.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.
• 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.

For more details on receive transactions, see Overview of Receive Service Transaction Processing.

Business Document Structure

This service uses the business document autoInvoiceBizDoc. Its structure is as follows:

• 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

1.0 TRANSACTIONS (Maps to RA_INTERFACE_LINES_ALL)

1.1 TRANSACTION_LINES (Maps to RA_INTERFACE_LINES_ALL)

1.1.1 TAX_LINES (Maps to RA_INTERFACE_LINES_ALL)

1.1.1.1 GL_DISTRIBUTIONS (Maps to RA_INTERFACE_DISTRIBUTIONS_ALL)

1.1.2 FREIGHT_LINES (Maps to RA_INTERFACE_LINES_ALL)

1.1.3 SALES_CREDITS (Maps to RA_INTERFACE_SALESCREDITS_ALL)

1.2 CHARGES (Maps to RA_INTERFACE_LINES_ALL)

1.3 FREIGHT_LINES (RA_INTERFACE_LINES_ALL)