New feature added, version 7.5.2, 7.5.3, 8.1
Program OEAF, Maintain Acknowledgment Print Flags, is used to indicate which order acknowledgments will be printed when program OEAP, Print Order Acknowledgments, is run. Only status O - Complete, J - Confirmed Incomplete, and S - Confirmed Complete sales orders can be queried in this program.
* The information displayed includes the sales order number and suffix, customer number and name, sales location, type, date ordered, status, and hold code.
* Program OEAP, Print Order Acknowledgments, will run this program before printing the sales order acknowledgments.
Sales Order Acknowledgment Print Flag Parameters
Selecting Sales Order Acknowledgments to Print
Batch Emailing or Faxing Sales Order Acknowledgments
Automatic Transmit Processing for Sales Acknowledgments
1. Press [Execute Query] upon entering this program.
2. For all orders for which you wish to print acknowledgments, set the Print flag to on.
* To print acknowledgements for all orders, press the [Select All] 
button. This will select all orders. You can deselect orders after this button has been pressed.
* To deselect all orders, press the [Deselect All] 
button. You can select orders after this button has been pressed.
3. Press [Commit] and exit.
1. Press [Execute Query] upon entering this program.
2. For all sales orders for which you wish to fax or email sales order acknowledgements, set the Print flag to on.
3. Press [Commit].
4. Press the [Transmit Selected Orders] button.
When automatic transmit is running, the form queries and transmits all sales orders that are set up to be transmitted. When the selected orders have been transmitted, the process enters waiting mode until the defined number of minutes have passed, at which point the process beings again.
1. In the Cycle Interval field, enter the number of minutes that will lapse between the completion of one batch transmit and the beginning of another. This field can be entered in minutes and decimals of minutes.
2. Click on the Start Auto Transmit button to begin the automatic batch transmit process.
3. To stop the batch transmission, click on the Stop Auto Transmit button.
Press this button to deselect all orders. You can select orders after this button has been pressed.
Press this button to select all orders to print acknowledgements. You can deselect orders after this button has been pressed.
Press this button to begin the automatic batch transmit process.
Press this button to stop the automatic batch transmit process.
Press this button to email or fax the selected sales order acknowledgements to customers. Some set up must be completed before sales order acknowledgements can be faxed or emailed. See the Faxing and Emailing Reports section for more information.
The sales acknowledgement transmission process can be run in the background without using program OEAF, Maintain Acknowledgment Print Flags. This process can be set up through program JOBQ, NDS Job Queue Management, Windows Scheduler, or another job scheduler, such as Cron.
In order to transmit any report the following set up must be done. If you need assistance for these steps, contact your NDS Project Manager.
* If the report to be called is custom then procuser.uproc23 needs to be programmed to return the proper report parameter values if the drill down keys for the custom report are not the same as standard drill down keys. In addition, the report should be flagged as custom in program UTKM, Maintain Drill Down Keys.
* If a record should be written to program CMEV, Customer Events Maintenance, when the report is transmitted, then the report class of the report must be set up as an event type in program CMEM, Customer Event Type Maintenance.
* To verify the parameters used in batch transmission, in SQL*Plus, enter the following code. In addition to displaying in your SQL session, the output will be written to program UTDB, Debug Control and Display.
SQL>set serveroutput on
SQL> execute procsend.batch_transmit_murms;
When setting up your job in your job scheduler, you need to make sure the following actions are completed. For additional information, reference the documentation in the procsend.sql file in your patches or sql directory in your NDS Home Directory.
* Delete from the temporary transmit table oeaf_transmit.
* Insert the desired records into the temporary transmit table oeaf_transmit.
For oeaf_transmit the values would be order number and customer number for the sales acknowledgements that will be transmitted.
* Call procdefs_set_empno(empno) to set the employee number that will be tracked as having run the reports.
* Call the transmission routine procsend.oeaf_transmit, passing in the appropriate input parameter values.
To set up the job in program JOBQ, NDS Job Queue Management, complete the following steps:
1. Go to the second page of program JOBQ, NDS Job Queue Management.
2. In the Job No field, enter the job number.
3. In the job name field to the right of the job number, enter the job name.
4. In the Contact Name field, enter a contact name for the job.
5. Set the Job Log Activation flag to on if you wish the activation of this job to be logged as history. Set the Job Log Activation flag to off to prevent the activation of this job from being logged as history.
6. In the PL/SQL field, enter the SQL statement that will be used to run the job. In the following example, bold text indicates a comment describing the code that follows it, and italicized text indicates that an appropriate replacement should be made by the user.
-- records remain in table from last transmit and should be deleted and replaced with new records
delete from oeaf_transmit;
commit;
insert into oeaf_transmit
(order_no, cust_no)
select order_no, cust_no
from oehead
where (your custom criteria)
commit;
-- set the login employee no so sales tracking can pick it up
execute procdefs.set_empno('XXX');
-- this sends out email and fax acknowledgements only, turns off the print flag, writes the sales tracking record and writes a customer event record (as long as OEACK is set up as a customer event type)
execute procsend.oeaf_transmit('OEAPX','T','Y','Y','Y', user/pswd@db);
procedure oeaf_transmit( t_drilldown_rpt in varchar2,
t_transmit_type in varchar2,
turn_off_print_flag in varchar2,
write_oe_tracking in varchar2,
write_cust_event in varchar2,
t_logon in varchar2);
t_drilldown_rpt is the drilldown 'to program' from program OEAF, Maintain Acknowledgment Print Flags, to the OEAP, Print Order Acknowledgments, report for transmitting. The standard is OEAPX.
t_transmit_type is the kind of transmission for the report. Sales order acknowledgements with a different transmit type than the one passed to the procedure will be ignored.
Valid values are:
T - Email and Fax
M - Email only
F - Fax only
P - Printer only
A - Email, Fax, and Printer
turn_off_print_flag determines whether the print flag should be set to N for the sales orders that are successfully transmitted. The default is Y.
Valid values are:
Y: Set the print flag to N for successfully transmitted sales orders.
N: Leave the print flag set to Y for successfully transmitted sales orders.
write_oe_tracking determines whether tracking record will be written. The default is N
write_cust_event determines whether the a customer events record will be written to program CMEV, Customer Events Maintenance. The default is N.
t_logon is the user logon user/password@database and is, necessary to run report via URL.
Records are left in the OEAF_TRANSMIT table upon completion
7. In the Interval field, you can enter an expression that will evaluate into a date, such as SYSDATE. This field is generally used when you wish to run a job at specific time intervals.
* For example, if you wanted to run the job every hour, you would enter SYSDATE + 60/1440. 1440 is the number of minutes in a day. If you wanted to run the job every 5 minutes, you would enter SYSDATE + 5/1440.
8. In the Repeat Until field, enter the date and time on or before which the last running of this job will occur. This field is used in conjunction with the interval. Format is MM-DD-YYY hh24:mm. For example, July 13th 2006 at three pm would be 07-13-2006 15:00.
9. Press [Commit].
10. Press the [Submit to Job Queue] button to add the job to the job queue. The status field will change from NOT IN SYSTEM JOB QUEUE to IN SYSTEM JOB QUEUE.
11. The information can now be viewed on page one and will be run on the date indicated.