D2K <-> OAF
Call D2K form from oaf using syntax: pageContext.forwardImmediatelyToForm(String); String should be in format of form:APPLICATION_SHORT_NAME:RESPONSIBILITY_KEY:DATA_GROUP_NAME:FORM_FUNCTION_NAME
Example: String d2k = "form:FND:APPLICATION_DEVELOPER:STANDARD:FND_FNDPOMPO";
Call OAF from D2K using fnd_function.execute API
Import data from Excel to Oracle Table using OAF:
For this we need jxl.jar to download and place it in myprojects folder in local and place it in
Deployment of JAR Files
Till R12.1.
JAR file by placing in server and add below entry in orion-application.xml at $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/application-deployments/oacore/ Remember to run auto-config bounce middle tier as well. This works upto R12.1, since OCJ4 understands orion-application.xml file. After R12.1 its different procedure.
From R12.2, it works like this.
Deploy JAR file into $FND_TOP/java/jar in R12.2, WLS understands a file $FND_TOP/admin/template/ebsProductManifest_xml.tmp and run auto-config and bounce middle-tier services.
customprod.jar
1. if you modify file in standard folder--> unjar using jar -xvf, unzip, modify, zip, jar using jar -cvf and then execute 'regenerate product jar' from adadmin
2. if you modify file in non-oracle standard custom i,e $JAVA_TOP/oracle/apps/xxe --> create customprod.zip using below and then run adjava command as sample below
zip -r customprod.zip $JAVA_TOP/oracle/apps/xxe
adjava oracle.apps.ad.jri.adjmx -areas $JAVA_TOP/customprod.zip -outputFile $JAVA_TOP/customprod.jar -jar $CONTEXT_NAME 1 CUST jarsigner -storePass apps -keyPass apps
3. if you modify file in oracle standard custom i,e $JAVA_TOP/xxe/oracle/apps --> Run adcgnjar utility from $AD_TOP/bin, which will create and sign-in customall.jar
Thursday, July 30, 2015
Bit map index
This type of indexes normally used to create on low cardinality columns. Low cardinality column means, which is going to have very less type of values. For example: Supplier type would be internal or external. These indexes would be created in Data warehouse tables to improve the performance. We can create this index on column or joining of tables also.
http://www.orafaq.com/wiki/Bitmap_index
http://www.orafaq.com/wiki/Bitmap_index
Thursday, July 23, 2015
Deployment changes from 12.2 onwards
Please refer to:
1.Oracle® E-Business Suite Developer's Guide Release 12.2 (Part No. E22961-09)
2.Deploying Customizations in Oracle E-Business Suite Release 12.2 (MOS Doc ID 1577661.1)
3.Using the Online Patching Readiness Report in Oracle E-Business Suite Release 12.2 (MOS Doc ID 1531121.1)
4.Oracle E-Business Suite Release 12.2: Online Patching FAQ (MOS Doc ID 1583902.1)
Edition based Redefination ( EBR) - Run Edition and Patch Edition
EBR in DB: Editionable objects are synonym, views and all plsql objects.
In Linux:
echo $FILE_EDITION
In DB:
select ad_zd.GET_EDITION_TYPE,
ad_zd.GET_EDITION
from dual;
How to set your Edition?
OS:
source /oracle/ebs122/EBSapps.env run or
source /oracle/ebs122/EBSapps.env patch
echo $RUN_BASE - the run filesystem
echo $PATCH_BASE - the patch filesystem
DB:
ad_zd.SET_EDITION(‘RUN’)
or
ad_zd.SET_EDITION(‘PATCH’)
Check Edition Status:
•How to check the status of patching
•In the OS:
adop –status
•From the DB:
sqlplus apps @ADZDSHOWED.sql
EBR and Data:
•Table Data is maintained through triggers
•Seed Data is handled by striping it with an Edition column
1.Oracle® E-Business Suite Developer's Guide Release 12.2 (Part No. E22961-09)
2.Deploying Customizations in Oracle E-Business Suite Release 12.2 (MOS Doc ID 1577661.1)
3.Using the Online Patching Readiness Report in Oracle E-Business Suite Release 12.2 (MOS Doc ID 1531121.1)
4.Oracle E-Business Suite Release 12.2: Online Patching FAQ (MOS Doc ID 1583902.1)
Edition based Redefination ( EBR) - Run Edition and Patch Edition
EBR in DB: Editionable objects are synonym, views and all plsql objects.
In Linux:
echo $FILE_EDITION
In DB:
select ad_zd.GET_EDITION_TYPE,
ad_zd.GET_EDITION
from dual;
How to set your Edition?
OS:
source /oracle/ebs122/EBSapps.env run or
source /oracle/ebs122/EBSapps.env patch
echo $RUN_BASE - the run filesystem
echo $PATCH_BASE - the patch filesystem
DB:
ad_zd.SET_EDITION(‘RUN’)
or
ad_zd.SET_EDITION(‘PATCH’)
Check Edition Status:
•How to check the status of patching
•In the OS:
adop –status
•From the DB:
sqlplus apps @ADZDSHOWED.sql
EBR and Data:
•Table Data is maintained through triggers
•Seed Data is handled by striping it with an Edition column
Oracle MAF (Mobile Application Framework)
Need to install Jdeveloper 12c.
http://multikoop.blogspot.in/2014/07/adf-mobile-rebrands-to-oracle-maf.html
http://www.oracle.com/technetwork/developer-tools/maf/overview/index.html
http://download.oracle.com/otn_hosted_doc/maf/academy/DevelopingApplicationsWithMAF/presentation.html
http://multikoop.blogspot.in/2014/07/adf-mobile-rebrands-to-oracle-maf.html
http://www.oracle.com/technetwork/developer-tools/maf/overview/index.html
http://download.oracle.com/otn_hosted_doc/maf/academy/DevelopingApplicationsWithMAF/presentation.html
Develop your own free IM(Instant Messaging) tool for your website or organization
Openfire server --> Install this at linux server. This is open source and written in java. This uses XMPP (Extensible Messaging and Presence Protocal)
Spark client --> Clients should install this at their local machines
http://www.tecmint.com/create-your-own-instant-messagingchat-server-using-openfire-in-linux/
We can also integrate IM(XMPP) with Oracle Apex. Please check below
https://technology.amis.nl/2012/10/01/how-to-build-an-im-xmpp-solution-with-oracle-apex-and-websockets/
Spark client --> Clients should install this at their local machines
http://www.tecmint.com/create-your-own-instant-messagingchat-server-using-openfire-in-linux/
We can also integrate IM(XMPP) with Oracle Apex. Please check below
https://technology.amis.nl/2012/10/01/how-to-build-an-im-xmpp-solution-with-oracle-apex-and-websockets/
Subscribe to:
Posts (Atom)