Jdevelop配置
解压至某目录(我是d:\java\jdev_oaf)(注意目录中不要带有空格!) 解压后的目录结构是 jdevbin jdev的执行程序所在目录 jdevdoc 开发文档 jdevhome oaf工作目录 配置步骤: 1) 填加环境变量 JDEV_USER_HOME 指向d:\java\jdev_oaf\jdevhome\jde...
XMLType Operations
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14259/xdb04cre.htm#sthref465
在oracle中通过字段信息生成xml文件
一般地,在开发xmlp的时候,我们要先用report builder制作rdf模板,然后上传rdf到客户化应用下的reports文件夹下,通过并发请求,输出xml数据,然后保存成xml文件,或者直接将请求输出的out文件改后缀为xml,同样得到输出数据的xml文件,接着通过加载xml数据制作rtf模拟,定义数据和模板,再次处...
How to Check Debug Log on OAF Pages
1. Profile 'FND: Diagnostics' = Yes at user level.This will make 'Diagnostics' menu display.2. Login to Personal Home Page as that user and select the 'Diagnostics' icon at the top of the page.3.In list box, Choose 'Show Log on Screen',and Select Statement4.Once thi...
Oracle EBS APIs
API To Find Sales Order's Subtotal,discount,charges and Tax (OE_OE_TOTALS_SUMMARY.ORDER_TOTALS) API for Cancelling the Purchase Order (PO) Document (PO_DOCUMENT_CONTROL_PUB.CONTROL_DOCUMENT) API for Deleting the category assignment to an item (INV_ITEM_CATEGORY_PUB.DELETE_CATEGO...
Purchase Document Open Interface(PDOI)
PO模块也有自己的接口表,多用于把其他业务系统在Oracle EBS系统生成采购订单记录。 Table NameDescriptionTypePO_HEADERS_INTERFACEThis is the table where to insert PO headers data in interface table....
OAF MVC Architecture
MVCM:The Model is the place containing the business logic.V:The View is the presentation layer.C:The Controller manages the flow between pages.OAF MVC Architectureor1] ModelBC4J(Business Components For Java) have three basic component clas...
MetaData Service (MDS) in OA Framework
OAF的XML文件有:UIX Pages and Regions.OAF PersonalizationsBC4J Substitutions (EO, VO Substitutions)BC4J Components (EO.xml, VO.xml, AM.xml, AO.xml, VL.xml)OAF的很多组件都是以XML的形式存在,但到最终的系统里,OAF的XML文件会存储到数据库表中(JDR_...
How to Deploy a OAF Files
a) Copy all files except page definition from local machine to appropriate directories.The files such as Controllers *CO.class Application modules *AM.class View Objects *VOImpl.class, *VORowImpl.class, *VO.xml Entity ob...
Oracle AP Invoice APIs
These APIs are handful when you want to do Insert, Update or Delete programmatically for some business requirements (rare cases!) API Name Procedure Name Description ...
API to Create AP Supplier Site
API - pos_vendor_pub_pkg.create_vendor_site Example -- -- API to Create Supplier Site DECLARE l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type; lc_return_status VARCHA...
API to Create AP Supplier
API - pos_vendor_pub_pkg.create_vendor Example -- -- API to Create Supplier DECLARE l_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type; l_return_status VARCHAR2(10); l_ms...
API to Create Item Specific UOM Conversion (INV_CONVERT.CREATE_UOM_CONVERSION)
TEST INSTANCE: This API is available from the release R12.1.3 Oracle ApplicationsPACKAGE: INV_CONVERTPROCEDURE : CREATE_UOM_CONVERSIONNOTES: Creates the Item Specific conversion between two uom's using uom_ra...
How to deploy JAR file into R12 server in OA
Steps to add JAR file into R12 server in OA -- 1. Deploy your JAR file at some custom location in R12 server i.e. – /u01/app/apnac03r12/XX_TEST/ 2. Open “orion-application.xml” file present at path – $ORA_CONF...
Oracle Application Server上不同类型的文件所在的目录
Generate XML Output from a PL/SQL Concurrent Program
Use the utility DBMS_XMLGEN to generate XML output, as in the following procedure. An example of a query string used to display multiple nested levels of data (using the CURSOR function) is shown below the procedure.----------------------------------------------------------------------------- ...
Bounce Apache Server
Release 12 (Run following command in UNIX) Stop Serversh $INST_TOP/admin/scripts/adoacorectl.sh stop Start Serversh $INST_TOP/admin/scripts/adoacorectl.sh start Release 11 (Run following command in UNIX) Stop Serversh $COMMON_TOP/admin/scripts/KTP...
Deploy OAF page
1. Copy all files from local machine to appropriate $JAVA_TOP directory 2. Compile all java files (Controller Files) with command javac <file_name>.java 3, Call java importer to import all xml filesjava oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/prajkumar/oracle/apps/fnd...
Implement Train in OAF Page
OAF Train
Implement Master Detail Relationship in OAF Page
Let us try to implement Master Detail Relationship in advanceedTable. We will create two tables master table and child table. Both have relationship with each other with Column1 (Note - Column1 is a primary key in both tables) 1. Create a New OA Workspace...