Oracle Receivables Transaction Printing Views

Transaction Printing Views

Use the Receivables Transaction Printing Views with Oracle Applications or any third party SQL-based system to collect Receivables transaction information and print it in a format you define. The Transaction Printing Views cannot be accessed from any Receivables window or program. Your system administrator or Oracle consultant must write custom SQL scripts to extract the transaction data that you need from the views. You can then use Oracle Reports 2.5 or later (or a similar SQL-based report generator) to format and print the data according to your needs.

While the Transaction Printing Views and the Receivables Print Invoice program are somewhat similar, you use each differently and for different purposes. The Receivables Print Invoices program prints selected transactions based on a series of runtime parameters that you specify, such as transaction class, transaction type, or a range of transaction numbers. Transaction Printing Views select all Receivables transaction information from the database. Your system administrator or Oracle consultant extracts the transaction information needed from the views by entering parameters in the WHERE clause for each SQL statement. A list of valid parameters is included with each view.

Note: The Transaction Printing Views also provide several functions to extract complex data that cannot be accessed using SQL select statements. These functions are for select purposes only and cannot update the database due to pragma restrictions, compiler directives that indicate which kinds of SQL statements can be used in a PL/SQL function. These restrictions are declared in the package specification for each function. The Pragma Restrict-Reference is located in the package header with the specification for the function.

Note: When you print your reports, you will want to update the transaction header indicating when the transaction was successfully printed. This is done by calling the Oracle Receivables API, ARTPSQB.pls. Select the "updated_customer_trx" function. This API updates the following columns: PRINTING_COUNT, PRINTING_LAST_PRINTED, PRINTING_ORIGINAL_DATE, and LAST_PRINTED_SEQUENCE_NUM.

New Modules

The following modules create the view structure for the transaction printing procedure. You must run these modules in the order in which they appear, because dependencies exist between some of the files.

New Views

Receivables provides the following Transaction Printing Views you can use to select transaction data.

For more information about these views and the tables and columns from which they select data, refer to the Oracle eBusiness Suite Electronic Technical Reference Manual (eTRM) on My Oracle Support.

See: Printing Transactions.