Setup Considerations

Before you use this operation, you can set business service properties to specify how the system retrieves data. This table includes information about the business service properties that the getVoucher operation uses:

Group	Key	Description	Default Value
J0400002	J0400002_MAX_ROWS	Use this business service property to specify the maximum number of records the operation returns for the query.	0: Return All Records

Note:

It is recommended that this business service property is configured and used. Also, it is strongly recommended that the consumer pass in selection criteria when performing a query. If these two recommendations are not followed, the operation attempts to fetch all the records from the database, which can significantly impact performance.

Also be aware that this operation performs multiple data retrievals from the EnterpriseOne database. Initially, records are selected from the Accounts Payable Ledger table (F0411) based on the selection criteria that is passed in by the consumer. After the operation retrieves records from the F0411, processing continues, and additional records are retrieved from the Account Ledger table (F0911), based on the data in the F0411 records. This business service property limits the number of records initially retrieved from the F0411. Therefore, the total number of records that are returned to the consumer might be greater than the value that you enter in this property.

See JD Edwards EnterpriseOne Tools Business Services Development Methodology Guide.