tag:blogger.com,1999:blog-78256873688915039442010-02-19T13:51:35.359-05:00There is a lot to learn about Oracle EBS and more is coming everyday, so this Blog mainly is a storing site for new and exciting knowledge.Galarzahttp://www.blogger.com/profile/03776381912462170666noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-7825687368891503944.post-70117341217406392772010-02-06T16:44:00.002-05:002010-02-06T16:54:40.251-05:00

This is only for EBS 11iSometimes is required to update the forms60_path with the AU_TOP/forms source home like:FORMS60_PATH=$FORMS60_PATH:$AU_TOP/forms/USthenf60gen module=.fmb userid=USER/PWD output_file=.fmx module_type=form batch=no compile_all=special

Galarzahttp://www.blogger.com/profile/03776381912462170666noreply@blogger.com0tag:blogger.com,1999:blog-7825687368891503944.post-42575717940506652402009-10-12T15:14:00.001-04:002009-10-12T15:16:28.865-04:00

Very good information about ANSI/FACT Data Identifiers in BarCoding.http://www.idat.com/a-identifiers.html

Galarzahttp://www.blogger.com/profile/03776381912462170666noreply@blogger.com0tag:blogger.com,1999:blog-7825687368891503944.post-89284730635902933482009-09-18T13:52:00.002-04:002009-09-18T13:58:05.849-04:00

Use following Oracle program:1. First update CLASSPATH env variable:CLASSPATH=$JAVA_TOP:$CLASSPATHexport CLASSPATHif you want to check it.echo $CLASSPATH2. Generate Data Template:java oracle.apps.xdo.rdfparser.DataTemplateGenerator {RDF file name converted as XML}3. Generate RTF Template:ava oracle.apps.xdo.rdfparser.RTFTemplateGenerator {RDF file name converted as XML}and that is it.

Galarzahttp://www.blogger.com/profile/03776381912462170666noreply@blogger.com0tag:blogger.com,1999:blog-7825687368891503944.post-72214994807827576312008-09-29T17:14:00.006-04:002009-04-08T15:01:15.998-04:00

FND_MDI_TITLE_USER_DESC: To show user description on MDI window Title.FND_CORPORATE_BRANDING_IMAGE: To Customize corporate branding image for Oracle Applications.FND_COLOR_SCHEME:To change Java Color Scheme.FND_LOOK_AND_FEEL:To change Java Look and Feel, to generic or to oracle.Variables:(cd $VARIABLE_NAME  to go to path define in variable.echo $APPLCSF  to see variable value)APPLLOG - Path

Galarzahttp://www.blogger.com/profile/03776381912462170666noreply@blogger.com0tag:blogger.com,1999:blog-7825687368891503944.post-13870005168637366242008-09-04T11:40:00.003-04:002008-09-04T12:06:22.212-04:00

Imagine you are developing a new Workbook in Discoverer, after you are sure it works fine, you ask your DBA to move the BA and the Workbook to Production, so BA goes through well but workbook does not, because it tell you there is an error like this:“Cannot join tables used in the workbook. Item dependency “” not found in the EUL”what next?, besides the possible finger pointing, most of the cases

Galarzahttp://www.blogger.com/profile/03776381912462170666noreply@blogger.com0tag:blogger.com,1999:blog-7825687368891503944.post-58842043551125078952008-08-15T12:50:00.006-04:002009-02-03T17:14:28.960-05:00

You go to system Administrator responsibility and assign to yourself or to someone else a desired responsibility, so you think, the job was done; but surprise even the user is able to select such responsibility, it does not work ... why? this is because Oracle change the way some responsibilities can be assigned, probably it is going to be the future for all of them.So here are the steps to

Galarzahttp://www.blogger.com/profile/03776381912462170666noreply@blogger.com0tag:blogger.com,1999:blog-7825687368891503944.post-74646385117386724762008-06-10T14:41:00.000-04:002008-06-11T17:37:00.554-04:00

well, how Fastformula works?1. Logon using US Super User HRSM Manager.2. Go to Other Definitions > Formula Function.And look for the function with the problem.Definition is the actual Database Package name and the function.3. Describe the code:FUNCTION get_plan_year( -- Input values --p_date_earned IN DATE)RETURN DATEIS--l_out_date DATE;--BEGINselect start_datei nto l_out_datefrom

Galarzahttp://www.blogger.com/profile/03776381912462170666noreply@blogger.com0tag:blogger.com,1999:blog-7825687368891503944.post-22898274844667537082008-02-11T15:51:00.000-05:002008-02-11T17:01:27.650-05:00

ic_tran_cmp_vw1 is a view inside Oracle Process Manufacturing, through it, you are able to see all completed transactions no matter what their source is, next is the mapping to link PORC transactions in that view with Oracle Purchasing Tables.----------------------------------------------------------- IC_TRAN_CMP_VW1.ITEM_ID = IC_ITEM_MST.ITEM_ID Note that this item_id is not same as Item_id in

Galarzahttp://www.blogger.com/profile/03776381912462170666noreply@blogger.com0tag:blogger.com,1999:blog-7825687368891503944.post-89036936044167468622008-01-18T14:31:00.000-05:002008-01-21T16:45:17.791-05:00

1. Review installation steps OAEXT_README.txt in the ZIP distribution file.2. Open file gs_setup.htm, see location in the below image.3.- Configure the JDEV_USER_HOME environment variable using Windows XP or Windows 2000 .My example: C:\installjdev\jdevhome\jdev4.-Obtaining a Database Connection File.Log on into your application tier where OA framework was installed, and go to$ cd $FND_TOP/

Galarzahttp://www.blogger.com/profile/03776381912462170666noreply@blogger.com0tag:blogger.com,1999:blog-7825687368891503944.post-18246322989689882582008-01-18T12:45:00.000-05:002008-01-18T12:50:23.884-05:00

http://blogs.oracle.com/schan/2006/12/21from the above link:BI Publisher (Tim Dexter)Tim is the one Oracle blogger who seems to work even harder than I do. His blog is packed with tips, screenshots, code samples, FAQs, and advice for BI Publisher users. If you use his product, this blog is a must-read. In Depth Apps - Oracle eBusiness Suite (Gareth Roberts)Another excellent blog from an Oracle

Galarzahttp://www.blogger.com/profile/03776381912462170666noreply@blogger.com0tag:blogger.com,1999:blog-7825687368891503944.post-67824342389892408542008-01-15T16:54:00.000-05:002008-01-15T16:56:48.719-05:00

to know the jdeveloper version you have to install, use http://hostname:port/OA_HTML/OAInfo.jspthe go to Metalink and look for Note 416708.1

Galarzahttp://www.blogger.com/profile/03776381912462170666noreply@blogger.com0tag:blogger.com,1999:blog-7825687368891503944.post-58570029573664851492008-01-08T15:42:00.000-05:002008-02-22T16:04:37.624-05:00

As you could know already TKPROF ($ tkprof sys=no explain=apps/) does not take into account bind variables. Therefore, you can not see those values in the output file. If you want to see them, you could use TraceAnalyzer.1. Download and install the trace Analizae rprogram for your current instance.2. Using it as followLaunch: SQL*Plusconnect as APPS/****** (0r user you used to create the raw file

Galarzahttp://www.blogger.com/profile/03776381912462170666noreply@blogger.com0tag:blogger.com,1999:blog-7825687368891503944.post-41198614917665268692008-01-08T14:42:00.000-05:002008-01-08T14:45:24.324-05:00

Applies to:Oracle Applications Framework - Version: 11.5 to 11.5.10Information in this document applies to any platform.OA FrameworkGoalThe steps below provide instructions on how to generate a SQL trace from Oracle Applications. An example where this can be useful is when SQL Exception messages occur in OA Framework screens e.g. oracle.jbo.SQLStmtExceptionSolutionPlease perform the following

Galarzahttp://www.blogger.com/profile/03776381912462170666noreply@blogger.com0