Search This Blog

Monday, February 15, 2010

View Barcode in BI Publisher Report when run from Application

Following steps should be completed in order to register your Barcode font to be viewed when report is run from Application.

1) From XML Publisher responsibility, create a font file in XML administration.
Navigation: XML Publisher Administrator -- Administration -- Font FilesCreate Font File
2) Create a font mapping set. Navigation: XML Publisher Administrator -- Administration -- Font Mapping
3) In the template screen , edit configuration -- FO Processing -- Font Mapping Set , provided the corresponding font mapping set
4) The last important step is to always use Territory column while defining Template. E.g. United States.

Now when report is generated from application, barcode font should be viewed.

Related Post:
Using 3 of 9 Barcodes in XML Publisher
Cannot View Output when previewed from RTF Template

Friday, February 5, 2010

Notify when SO is booked or new line is entered on booked order

Based on a request from one of our reader, below are the steps on how to notify users when an order is booked or new line is inserted on a booked order.

The Alert below will send notification once a day in the morning at 8:00 am.

1) Define Alert

Query used is

SELECT ooh.order_number
, ool.line_number||'.'||ool.shipment_number line_number
, ordered_item, ordered_quantity, ool.flow_Status_code
INTO &order_num, &line_num,&Item_num, &Quantity, &line_Status
FROM oe_order_headers_all ooh, oe_order_lines_all ool
WHERE ooh.header_id = ool.header_id
( ooh.booked_date >= to_date(Sysdate,'DD-MON-RRRR HH24:MI:SS')
OR (ool.creation_Date >= to_date(Sysdate,'DD-MON-RRRR HH24:MI:SS')
AND ool.creation_date > ooh.booked_date)

2) Define Actions
Click on the actions button and then actions Detail button and define message as shown in screenshot. Note that the message type is summary.

3) Define Action Sets
Click on action sets and then action set details and in the members tab enter the action defined in step 2

4) Schedule the Request
Navigate to Request --> Check and submit the alert. Based on the definition of alert it will be scheduled to run.

Kindly let me know if any questions.

Related Link: Introduction to Oracle Alerts

Copyright (c) All rights reserved. Presented by Suresh Vaishya