LDT generation for Business EVENTS and SUBSCRIPTIONS

Download
adjava oracle.apps.fnd.wf.WFXLoad -d username password host_of_database:port:sid thin US .wfx EVENT/SUBSCRIPTIONS
Upload
adjava oracle.apps.fnd.wf.WFXLoad -u username password host_of_database:port:sid thin US .wfx EVENT/SUBSCRIPTIONS

Calling a webservice from forms

http://www.oracle.com/technology/obe/obe_as_10g/deploy/callws_fromforms/forms_webservice.htm

OAF links

http://www.tier1inc.com/blog.php

LDT File generation for Lookups

The syntax for generation of LDT file for fnd lookups:
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct /home/applmgr/TEST.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME =application short name LOOKUP_TYPE=lookup name

Order Management

Oracle Order Management deals with the creation of orders and shipping Activities and interfacing the related data to Oracle Receivables for creation of invoices.In this Chapter we will see the technical and functional flow of order data and steps involved till the close of the Order.

Order Creation:

• Create the sales order using the order entry screen in Order Management Super User Responsibility.
• Order Entry Screen contain the Headers and Line Page.
• In Headers Page enter the customer details and customer bill to and customer ship to information.
• Customer Information in sales order comes from

HZ_CUST_ACCOUNTS_ALL,

HZ_CUST_ACCT_SITES_ALL,

HZ_CUST_ACCOUNT_SITE_USES_ALL,

HZ_PARTIES,

HZ_PARTY_SITES_ALL,

HZ_LOCATIONS.

Enable Export Feature in Custom Forms

In Order to Enable Export option, available in Oracle Application forms to export the data into Excel file.
In the custom form at form level trigger write the below code in When-New-Form-Instance trigger.
APP_SPECIAL.ENABLE('FILE.EXPORT', PROPERTY_ON);

Difference Between Bitmap and character mode report

Here is an example to help explain how Oracle Reports are designed and printed in both the bitmap and character-mode environments. Assume you wish to print "Cc" where "C" is a different font and a larger point size than "c" and is in boldface type (where "c" is not). In Oracle Reports Designer, bitmap mode, you can make "C" bold and in a different font and point size than "c". This is because you are generating postscript output. Postscript is a universal printer language and any postscript printer is able to interpret your different design instructions. In Oracle Reports Designer, character mode, the APPLICATIONS STANDARDS REQUIRE the report to be designed in ONE FONT/ ONE CHARACTER SIZE. Character mode reports generate ASCII output. In ASCII you cannot dynamically change the font and character size. The standard is in effect so a report prints as identically as possible from both conventional and postscript printers.