There are two ways to execute the Payment Pattern Loader procedure: Running
Procedure Using SQL*Plus and Payment Pattern Loader Procedure Using OFSAAI Batch
Maintenance
To run the procedure from SQL*Plus, login to SQL*Plus as the Schema
Owner:
SQLPLUS > declare
result number;beginresult := fn_paymentpattern
('Payment_Pattern_20121212_1','20121212');
end;
/
BATCH_RUN_ID is any string to identify the executed
batch.
AS_OF_DATE is in the format YYYYMMDD
To execute Payment Pattern Loader from OFSAAI Batch Maintenance, a seeded Batch
is provided.
The batch parameters are:
Datastore Type: Select the appropriate datastore
from list.
Datastore Name: Select the appropriate name from
the list.