Antenna maker launches website that locates OTA broadcasters, USA

A new website called TV-For-Free has been launched to help viewers find free network and local television stations for viewing and also helps them determine the right kind of antenna with which to view those programs.

Mohu, a provider of OTA TV antennas, produced the new locator, called TV-For-Free, to offer free alternatives to more expensive pay television programming. It was designed to help viewers determine locate free programming and to determine the best ways to access those programs.

The locator is accessible at www.GoMohu.com/TV-For-Free. Mohu said until now searching for a listing of free broadcast TV channels in a specific location and figuring out the right antenna to buy was often a complex and inaccurate process.

TV-For-Free displays available channels and subchannels, including those local stations broadcasting in HDTV. The tool taps into data from the more than 1800 broadcast towers located across all 50 U.S. states. In addition, the tool helps determine the right kind of antenna consumers will need in order to receive the channels they want.

By entering their ZIP code or actual street address, people can view a map with detailed information on which stations are available and the distance of broadcast towers from their location. TV-For-Free also offers a way to match people with the proper antenna to help them watch the channels they want. The tool was developed by Mohu, which also markets a line of OTA HDTV antennas, such as the Mohu Leaf and SkyHDTV.“Twenty-two of the top 25 most popular television programs in the United States are broadcast over-the-air for free,” said Mark Buff, co-founder and president of Mohu. “A quick search on TV-For-Free allows anyone to find the stations available to them, which is a great help when looking for ways to trim cable or satellite bills.”

TV-For-Free currently provides information on local OTA TV broadcast reception in all 50 U.S. states and will add coverage for Canada in the coming months.

Oracle Pricing APIs

QP_Price_formula_PUB.Get_Price_Formula (Formula Calculation API): The Formula Calculation package consists of entities to calculate the value of a formula.

QP_Price_formula_PUB.Process_Price_Formula (Update Formula Prices API): The Update Formula Prices package consists of entities to update formula prices.

QP_CUSTOM.Get_Custom_Price (Get Custom Price API): You may add custom code to this customizable function. The pricing engine while evaluating a formula that contains a formula line (step) of type "function" calls this API.

QP_PREQ_GRP.Price_Request (Price Request API): The Price Request Application Program Interface (API) is a public API that allows you to get a base price and to apply price adjustments, other benefits, and charges to a transaction.

QP_MODIFIERS_PUB.Process_Modifiers (Business Object for Modifier Setup API): The Business Object for Modifier Setup package consists of entities to set up modifiers.

QP_QUALIFIER_RULES_PUB.Process_Qualifier_Rules (Qualifiers API): The Qualifiers package consists of entities to set up qualifiers.

QP_ATTR_MAPPING_PUB. Build_Contexts (Attribute Mapping API): The Attribute Mapping package consists of entities to map attributes.

QP_Price_List_PUB.Process_Price_List (Price List Setup API): The Price List Setup package consists of entities to set up price lists.

Oracle API Availability -Purchasing

To get the brief idea about some available standard available Oracle Application interfaces applicable within oracle purchasing modules and hopefully it should serve to familiarize individuals with limited knowledge of Oracle's API functionality.


1. Open Requisition Interface


What you can do:

By this you can Automatically import requisitions from other oracle Application system or any other system using this interface. This allows you to integrate your oracle purchasing application with new or existing applications, such as material requirement planning, inventory management.etc.


What tables involved
PO_REQUISITIONS_INTERFACE_ALL
PO_REQ_DIST_INTERFACE_ALL


2. Requisition Reschedule


What you can do:


This is required when you are having Oracle Master Scheduling/MRP or a non-Oracle MRP system integrated with your oracle Purchasing, you may find that you need to reschedule requisitions as your

Planning requirements change. This API'S lets you reschedule requisition lines according to changes in your planned orders.


What tables involved
PO_RESCHEDULE_INTERFACE


3. Purchasing Documents Open Interface








What you can do:


You can Automatically import and update standard purchase orders, price/sales catalog information, and responses to request for Quotations(RFQ's) from suppliers through this interface. This interface uses the API's to process document data in the oracle applications interface table to ensure that it is valid before importing it into oracle purchasing. After the data is validated, the program converts the information in the interface table into the appropriate document in purchasing.


What tables involved
PO_HEADERS_INTERFACE
PO_LINES_INTERFACE
PO_DISTRIBUTIONS_INTERFACE


4. Receiving Open Interface


What you can do:


You can Automatically import receipt information from other oracle applications or other system using the receiving open interface. This interface lets you integrate your oracle purchasing applications with new or existing applications. E.g. you can load bar-coded and other receiving information from scanners.

More over the good things is that you can also bring Advance Shipment Notices (ASNs) sent from suppliers by this interface.


What tables involved
RCV_HEADERS_INTERFACE
RCV_TRANSACTIONS_INTERFACE


What you can't done by this API's
Serial numbering
Separate receive and deliver
Corrections
Returns
Movement statistics
Dynamic locators
Receiving against Internal Orders
Receiving against Inter-Organization transfers
Receiving against Drop Ship Orders
Receiving against RMAs


For more information for these three interface, you can refer these documenst.

OAF Page to Upload Files into Server from local Machine

OAF Page to Upload Files into Server from local Machine

1. Create a New Workspace and Project

File > New > General > Workspace Configured for Oracle Applications
File Name – PrajkumarFileUploadDemo

Automatically a new OA Project will also be created

Project Name -- FileUploadDemo
Default Package -- xxcmn.oracle.apps.fnd.fileuploaddemo

2. Create a New Application Module (AM)
Right Click on FileUploadDemo > New > ADF Business Components > Application Module
Name -- FileUploadAM
Package -- xxcmn.oracle.apps.fnd.fileuploaddemo.server
Check Application Module Class: FileUploadAMImpl Generate JavaFile(s)

3. Create a New Page
Right click on FileUploadDemo > New > Web Tier > OA Components > Page
Name -- FileUploadPG
Package --  xxcmn.oracle.apps.fnd.fileuploaddemo.webui

4. Select the FileUploadPG and go to the strcuture pane where a default region has been created

5. Select region1 and set the following properties --

Attribute	Property
ID	PageLayoutRN
AM Definition	xxcmn.oracle.apps.fnd.fileuploaddemo.server.FileUploadAM
Window Title	Uploading File into Server from Local Machine Demo Window
Title	Uploading File into Server from Local Machine Demo

6. Create messageComponentLayout Region Under Page Layout Region
Right click PageLayoutRN > New > Region

Attribute	Property
ID	MainRN
Item Style	messageComponentLayout

7. Create a New Item messageFileUpload Bean under MainRN
Right click on MainRN > New > messageFileUpload
Set Following Properties for New Item --

Attribute	Property
ID	MessageFileUpload
Item Style	messageFileUpload

8. Create a New Item Submit Button Bean under MainRN
Right click on MainRN > New > messageLayout
Set Following Properties for messageLayout --

Attribute	Property
ID	ButtonLayout

Right Click on ButtonLayout > New > Item

Attribute	Property
ID	Submit
Item Style	submitButton
Attribute Set	/oracle/apps/fnd/attributesets/Buttons/Go

9. Create Controller for page FileUploadPG
Right Click on PageLayoutRN > Set New Controller
Package Name: prajkumar.oracle.apps.fnd.fileuploaddemo.webui
Class Name: FileUploadCO

Write Following Code in FileUploadCO processFormRequest
import oracle.cabo.ui.data.DataObject;
import java.io.FileOutputStream;
import java.io.InputStream;
import oracle.jbo.domain.BlobDomain;
import java.io.File;
import oracle.apps.fnd.framework.OAException;
public void processFormRequest(OAPageContext pageContext, OAWebBean webBean)
{ super.processFormRequest(pageContext, webBean);
if(pageContext.getParameter("Submit")!=null)
{
upLoadFile(pageContext,webBean);
}
}

CODE #1 -- If Page has not deployed at instance, testing at Local Machine, use following Code
public void upLoadFile(OAPageContext pageContext,OAWebBean webBean)
{ String filePath = "D:\\temp";
System.out.println("Default File Path---->"+filePath);
String fileUrl = null;
try
{
DataObject fileUploadData = pageContext.getNamedDataObject("MessageFileUpload");
//FileUploading is my MessageFileUpload Bean Id
if(fileUploadData!=null)
{
String uFileName = (String)fileUploadData.selectValue(null, "UPLOAD_FILE_NAME");
String contentType = (String) fileUploadData.selectValue(null, "UPLOAD_FILE_MIME_TYPE");
System.out.println("User File Name---->"+uFileName);
FileOutputStream output = null;
InputStream input = null;
BlobDomain uploadedByteStream = (BlobDomain)fileUploadData.selectValue(null, uFileName);
System.out.println("uploadedByteStream---->"+uploadedByteStream);

File file = new File("D:\\temp", uFileName);
System.out.println("File output---->"+file);
output = new FileOutputStream(file);
System.out.println("output----->"+output);
input = uploadedByteStream.getInputStream();
System.out.println("input---->"+input);
byte abyte0[] = new byte[0x19000];
int i;

while((i = input.read(abyte0)) > 0)
output.write(abyte0, 0, i);
output.close();
input.close();
}
}
catch(Exception ex)
{
throw new OAException(ex.getMessage(), OAException.ERROR);
}
}

CODE #2 -- If Page has been Deployed at Instance, Use Following Code
public void upLoadFile(OAPageContext pageContext,OAWebBean webBean)
{ String filePath = "/Unix Path/";
System.out.println("Default File Path---->"+filePath);
String fileUrl = null;
try
{
DataObject fileUploadData = pageContext.getNamedDataObject("MessageFileUpload");
//FileUploading is my MessageFileUpload Bean Id
if(fileUploadData!=null)
{
String uFileName = (String)fileUploadData.selectValue(null, "UPLOAD_FILE_NAME");
String contentType = (String) fileUploadData.selectValue(null, "UPLOAD_FILE_MIME_TYPE");
System.out.println("User File Name---->"+uFileName);
FileOutputStream output = null;
InputStream input = null;
BlobDomain uploadedByteStream = (BlobDomain)fileUploadData.selectValue(null, uFileName);
System.out.println("uploadedByteStream---->"+uploadedByteStream);

File file = new File("/Unix Path/", uFileName);
System.out.println("File output---->"+file);
output = new FileOutputStream(file);
System.out.println("output----->"+output);
input = uploadedByteStream.getInputStream();
System.out.println("input---->"+input);
byte abyte0[] = new byte[0x19000];
int i;

while((i = input.read(abyte0)) > 0)
output.write(abyte0, 0, i);
output.close();
input.close();
}
}
catch(Exception ex)
{
throw new OAException(ex.getMessage(), OAException.ERROR);
}
}

10. Congratulation you have successfully finished. Run Your page and Test Your Work










 Page has not been deployed and Used CODE #1

Before Upload the File



After Upload the File




Courtesy : https://blogs.oracle.com/prajkumar/entry/oaf_page_to_upload_files

How to Generate Sample XML Data for Standard PO Report for use with XML Publisher

1. Give Core Apps user (who needs to be a Buyer) access to run the 'PO Output for Communications' concurrent request

2. Once you have your PO, do not approve it_ - leave it as incomplete

3. Go to run a new Request > PO Output for Communication

4. Enter PO Number, and set: Print Selection = New, PO Number = Incomplete PO you just created, Test=Debug

5. Submit request

6. On completion, request will error

7. View log of errored job

8. Do Tools > Copy Document to open Log in browser

9. Scroll down until you find the tag. Start copying from there (including that tag).

10. Stop copying at the


tag (just before starts...


11. Copy the selection


12. Paste the selection into a new text document, but put this in the first line:


13. At the end of the text you pasted in (last bit should say .


14. Manually type at the end of the text you pasted in.


15. Save as an XML file.


How to Generate Sample XML Data for Standard PO Report for use with XML Publisher [ID 364177.1] Ability to Edit po_standard_xslfo.xsl Using XML Publisher Desktop [ID 356596.1] Can POXPPO and POXPOPDF be Set to Call the Same Custom XML Data Source? [ID 562957.1]


Oracle Notes :



305307.1


364177.1

Adding a Special Menu

a menuitem;



Begin

a := FIND_MENU_ITEM ('SPECIAL.SPECIAL15');

if (event_name = 'WHEN-NEW-BLOCK-INSTANCE') then

if (form_name = 'OEXOEORD' AND block_name = 'LINE') then

app_special2.instantiate ('SPECIAL15', 'Query Form');

SET_MENU_ITEM_PROPERTY (a, displayed, property_true);

SET_MENU_ITEM_PROPERTY (a, enabled, property_true);

end if;

end if;



if (event_name = 'SPECIAL15') then

if (form_name = 'INVIDITM') then

fnd_function.EXECUTE (function_name => 'INV_INVMATWB',

open_flag => 'Y',

session_flag => 'Y' );

end if;

end if;

Orace Application Adding User and Adding Responsibility

User following PL/SQL to achieve the same,




DECLARE
l_user_id NUMBER;
l_resp_id NUMBER;
l_app_id NUMBER;
BEGIN
FND_USER_PKG.CreateUser (x_user_name => 'DEVUSER',
x_owner => NULL,
x_unencrypted_password => 'WELCOME123',
x_email_address => 'devuser@domain.com');

SELECT user_id
INTO l_user_id
FROM fnd_user
WHERE user_name = 'DEVUSER';

SELECT responsibility_id, application_id
INTO l_resp_id, l_app_id
FROM fnd_responsibility
WHERE responsibility_key = 'SYSTEM_ADMINISTRATOR';

FND_USER_RESP_GROUPS_API.
insert_assignment (user_id => l_user_id,
responsibility_id => l_resp_id,
responsibility_application_id => l_app_id,
security_group_id => NULL,
start_date => SYSDATE,
end_date => NULL,
description => NULL);

COMMIT;
EXCEPTION
WHEN OTHERS THEN
raise_application_error ( -20001, 'An error was encountered - ' || SQLCODE || ' -ERROR- ' || SQLERRM);
END;