Posts

Showing posts from 2021

Freight Carriers: Query to fetch Freight Carriers in Oracle Apps

Image
Freight Carriers: Navigation: Shipping/OM Super User responsibilities -> Setup -> Shipping -> Freight Carrier, Cost Types -> Freight Carriers  Query to Fetch Freight Carriers: select  wc.carrier_name,  WC.FREIGHT_CODE, wcs.service_level,  wcs.mode_of_transport, ship_method_code, WOC.ORGANIZATION_CODE from  apps.WSH_CARRIERS_V WC, apps.WSH_CARRIER_SERVICES WCS, apps.WSH_ORG_CARRIER_SERVICES_V woc where wc.carrier_id = wcs.carrier_id   and wcs.carrier_service_id = woc.carrier_service_id   and WC.ACTIVE ='A'   and wc.carrier_name ='EUROPOST' order by wc.carrier_name,WOC.ORGANIZATION_CODE

How to add new FONTs to Oracle apps server

Add New Font to Oracle Apps Business Case  T here could be a business scenario where we might need to add new font like BARCODES or specific font to match the companies LOGO and BRAND. In Order to achieve new fonts being added to Oracle Apps so it can used by XML Publisher in reporting, following steps need to be done to bring in the new font: Steps: Place the font .ttf file in any server path like erpapp/customtop/fonts                sample file name: New40font.ttf The new font needs to be added to the XDO.cfg config file to be able to use by XML publisher                 code snippet to be added to config file: <font family="New40font" style="normal" weight="normal" > <truetype path="/erpapp/customtop/fonts/New40font.ttf"/> </font>