AOL Customization FAQs
----------------------
----------------------
When will a New version of flint60 be released?
flint60 is a developer/development tool. Since flint60 can change at any time,
the most current flint60 will always obsolete all prior releases. In other
words, the development standards implemented in the most current flint60 are the
standards to which everyone using flint60 must adhere.
How do I register a custom concurrent program?
Step 1: Register a concurrent program executable
Navigate to the Define Executable form (AOL Reference manual pg 9-84)
This determines the type of program being run,
ie an Oracle Report, a C program, a shell script etc.
Fill in the executable name, application and execution method.
For the Execution File, fill in just the filename. The concurrent manager will
look in the appropriate directory under the application's top directory.
For spawned programs, the file must be in the bin directory, for Oracle Reports the
rdf file must be in the srw directory.
For PLSQL concurrent programs, put the name of the stored procedure.
Step 2: Define the concurrent program
Navigate to the Define Concurrent Program form (AOL Reference manual pg 9-87)
This form links a concurrent program to the executable you just defined, as well as
defines the programs parameters, incompatibilities, and other options.
Enter the concurrent program name, application, short name and description.
Check Standard Submission if you want to be able to submit this program from the
Standard Report Submission form.
Enter the name of the executable you defined and any report information if necessary.
Also define any parameters your program needs here and any incompatibilities.
Step 3: Add the concurrent program to a Report Group
First you will need to find the name of the Report Group to use.
Go to Security->Responsibility and query the responsibility you want to run the program with.
It should show a Report Group name. Query this name in Security->Responsibility->Report
Add your new program to the list of available programs. Now when you go to submit
a request with this responsibility, you will be able to submit your custom program.
How do I compile a custom C program?
Spawned programs:
Step 1: Write the code
Self-explanatory
Step 2: Compile the source
You must use the makefile under $FND_TOP/usrxit
Use: make -f $FND_TOP/usrxit/Makefile program.o
We do not support using any other makefile
Step 3: Link the program
This part is a little tricky. You need to create a custom makefile for this step.
Use $FND_TOP/lib/sample.mk as a starting point. Copy this file to the lib directory
under your applications top directory. Rename it
Modify this file according to the directions in it. Basically you need to add a target
and build commands for your executable.
Next, use adrelink to link the executable:
adrelink force=y ranlib=y "shortname programname"
Step 4: Register the program as in the above question
Immediate programs:
Just don't do it.
How do I run a shell script as a concurrent program?
1: Write the script and call it
Place the script under the bin directory under your applications
top directory.
For example, call the script CUSTOM.prog and place it under
$CUSTOM_TOP/bin
2: Make a symbolic link from your script to $FND_TOP/bin/fndcpesr
For example, if the script is called CUSTOM.prog use this:
ln -s $FND_TOP/bin/fndcpesr CUSTOM
This link should be named the same as your script without the .prog
extension
It should be in the same directory as the script.
3: Register a concurrent program as described above, using an execution
method of 'Host'
Use the name of your script without the .prog extension as the name
of the executable
For the example above, you would use CUSTOM
4: Your script will be passed at least 4 parameters, in $1 through $4
These will be: orauser/pwd, userid, username, request_id
Any other parameters you define will be passed in $5 and higher.
Make sure your script returns an exit status.
5: If your script returns a failure exit status but the concurrent
manager does not report the error (shows it as still running normal)
apply Patch 442824
Why do my PLSQL stored procedure concurrent programs error out with: 'Invalid number of
arguments'?
See pg. 9-79 of the AOL Reference manual.
PLSQL concurrent programs must have 2 OUT arguments defined.
RETCODE is used to return the error status
ERRBUF is used to return an error message
Note that you do not need to define these arguments in the Define Arguments form,
only in the procedure itself.
Why do I get the following error when trying to download a menu:
"APP-FND-01564: ORACLE error 6550 in afpodbinit"
Try running FNDSLOAD using apps as the username:
FNDSLOAD apps/
No comments:
Post a Comment