Ans. We can do this in Apps Forms.
Prerequisite: We need to load all the predefined plls for example APPDAYPK for calendars.
Once we have all the dll's required
Assign the key list lamb LOV to the textfield.
Validate from list (property) : No
Key list val trigger of that field --> calendar.show;
You will get the calendar LOV whenever you enter into that text field...!
2. Table for independent value set
Ans. If you want the base table where the name of the value set is stored then it isFND_FLEX_VALUE_SETS.
3. Define Shipping Parameters
Ans.
This is detail about Shipping Parameters..for OM.. The below details
are breifly descripb u.. If any clarifications plz.. go to India Local
Order Management>> Shipping>> Setup>> Shipping
Parameters..General:
Weight UOM Class : VOLUME
vOLUMEN uom cLASS : volume
pERSENT Fill Basis: Quantity
Export Compliance Screening : Not Required -- as per requirement..
PICK RELEASE:
Release Sequence Rule : Default: Order Number
Pick Slip Grouping Rule : Default: Order Number
Print Pick slip : At the End
Number of pick slip lines: null
Default Pick release document set : create Default rule
Default Stage Subinventory: org code
Autocreate Deliveries: Check
Auto Allocate: Check
Default Stage Locator: Stock locator
Shipping Transaction:
Delivery
4. How to schedule the concurrent programs from Back end(PLSQL) -not from SRS form.
Ans. fnd.request.submit_request( Concurrent_program_name,application_short_name
description,
parameters)
,
5. What is the role of applsys and applsyspub
Ans. All the technical products' database objects are consolidated into a single schema called ApplsysApplsyspub is used for authentication by having read only views
6. How can we delete a Concurrent Program which is already registered?
Ans. Through the Application Front end its not possible to delete CP. But from backend we can delete it.TO DELETE CONCURRENT PROGRAM
---------------------------------------------
begin
fnd_program.delete_program('SHORTNAME','APPLICATION');
fnd_program.delete_executable('SHORTNAME','APPLICATION');
end;
7. What is a concurrent program and a concurrent request set ?
Ans. A
concurrent program is an executable file that runs simultaneously with
other concurrent programs and with online operations, fully utilizing
your hardware capacity. Typically, a concurrent program is a
long-running, data-intensive task, such as posting a journal or
generating a report.A concurrent request is a request that you submit to run a concurrent program as a concurrent process.
A request set is a collection of reports and/or programs that you group together. You can submit the reports and/or programs in a request set all at once using a single transaction.
8. How do you attach javascript to a menu ? When user clicks on a menu it should display simple message
Ans. No Answer
9. How do I submit a Series of requests from PL/SQL?
Ans.
May be your question about series of requests is from PL/SQL. For this
it is not possible to submit series of requests at a time their is only
one option to submit request from backend is fnd_request.sumbint_request(Paramenters)
10. What is US directory under any TOP?
Ans. This directory contain code related to base language which is US English
11. What so you mean by Hierarchical and non Hierarchical security type in value set?
Ans. This comes into picture when security rule comes into picture.For example Say Maintanance is the one of the accounts in that we have cleaning painting expenses when we are not accesssible to main a/c (i.e maintanance) we cannot use sub a/c i.e cleaning and painting when you select Hierarchicalsecurity when it is non-Hierarchical we can use sub a/c i.e painting cleaning etc...
12. What is the difference between organization id and master organization id?
Ans. In simple wordsOrg_id referes the operating unit and and organization id refers the Inventory OrganizationRegardsKarthikeyan|
13. What is quick code? Why is it called a quick code?What is steps of defining a quick code?
Ans. Quick Code or Lookup Code are short names given to some field values. an example is two letter codes given to Country names.
14. What is '$flex$ and '$profile$, What is the use of '$flex$'?
Ans. $Flex$ is used when we need to return the Flex value contained by any AOL Vlauset or AOL object . For Ex . $Flex$. would return the value held by that valueset . $profiles$. are used to get the values of environment variables like org_id or mfg_Organization_id etc which are related to the current apps environment. Ex. $profiles$.org_id would return the operating unit which is active at that time for the user.
15. How can i implement and manage the custom schema?
Ans. basically a schema is collection of objects(tables
views indexes sequences) belonging to particular user here in case of
Oracle apps every module is implemented as a user for example Order
Management is implemented as a user ONT so to create a custom schema we
need to create a user and register the user with AOL.check this link for
step by step process to create a custom module(Application) and
register with oracle AOL.
16. How can I change in custom.pll? After changes how can I send on the server and what's effect in this condition?
Ans. 1. FTP the Custom.pll from $AU_TOP/resource 2. Open the Custom.pll in Forms6i 3. Include the following code for your Form logic : begin Form_Name varchar2(50) : name_in('system.current_form'); If Form_Name 'YOUR CUSTOM FORM then begin include your logic end; end; 4. Once changes over using the following command to generate the CUSTOM.plx f60gen module CUSTOM.pll userid apps/apps@mfgdev module_type LIBRARY to generate the latest CUSTOM.plx and move this CUSTOM.plx to $AU_TOP/resource
17. I have run a request but it is not completed.
His status is (running normal) and those requests are giving after this
he will be completed.So,now what steps I have to follow for the running
request?
Ans. give
it some more time. Did you ensure that you had run immediately checked
when you submitted the report/request? If it was accidentally scheduled
for a later date/time the best thing you can do is to submit it again
with correct parameters.
18. I have applied a patch. at the time of applying he update a table and suddenly he gives the error that table is lock. Now what i do?
Ans. use
adctrl utility to monitor and restart adworkers after fixing your
locking problem. check ad workers log file that show you which table has
problem and error message
19. where would i find the .rf9 files what actualy it dose
Ans. .rf9 files are created while applying patches usually in $APPL_TOP/admin/SID/restart directory
20. How can i disabled and enabled the standard button's in apps window?
Ans. You
can do this with Custom.pll and if ur using apps version greater that
11.5.9 then you can do this with form personlization too
21. How do i recover the responsibility in apps if it is disabled?
Ans. We can also recover through the following steps:Go to system administrator responsibility > Security > Responsibility > Define > Give the particular responsibility name query on it and then see the effective dates to field. If any date is there then that repsonsibility will expire on that date and if it is null then it will not expire on any date.
22. Where do concurrent request log files and output files go?
Ans. The concurrent manager first looks for the environment variable $APPLCSF If this is set, it creates a path using two other environment variables: $APPLLOG and $APPLOUT It places log files in $APPLCSF/$APPLLOG Output files go in $APPLCSF/$APPLOUT So for example, if you have this environment set: $APPLCSF = /u01/appl/common $APPLLOG = log $APPLOUT = out The concurrent manager will place log files in /u01/appl/common/log, and output files in /u01/appl/common/out Note that $APPLCSF must be a full, absolute path, and the other two are directory names. If $APPLCSF is not set, it places the files under the product top of the application associated with the request. So for example, a PO report would go under $PO_TOP/$APPLLOG and $PO_TOP/$APPLOUT Logfiles go to: /u01/appl/po/9.0/log Output files to: /u01/appl/po/9.0/out Of course, all these directories must exist and have the correct permissions. Note that all concurrent requests produce a log file, but not necessarily an output file.
23. What are the logfile and output file naming conventions?
Ans. Log file get following name by default: lRequest_id.reqand Output file get following name by default : oRequest_id.out Output files are stored at $APPLCSF/$APPLOUT and Log files are stored at $APPLCSF/log These paths may vary depending on the setups that sys admins perform at the time of Oracle Apps installation 24.How do I check if Multi-org is installed? Ans. SELECT MULTI_ORG_FLAG FROM FND_PRODUCT_GROUPS If MULTI_ORG_FLAG is set to 'Y' Then its Multi Org. If MULTI_ORG_FLAG is set to 'N' Then its single Org.
|
30. How do I cancel a running concurrent request?
Ans. Navigate to the Concurrent Request Summary form Select a request
In character, do a Quickpick on the Status column
You can select Cancel or Hold
In GUI, use the Cancel or Hold buttons
The Sysadmin responsibility can cancel or hold any running request
31. Why does Help->Tools->Examine ask for a password?
Ans. Navigate to the Update System Profile Screen. (\ navigate profile system)
- Select Level: Site
- Query up Utilities:Diagnostics in the User Profile Options Zone.
If the profile option Utilities:Diagnostics is set to NO, people with access to the Utilities Menu must enter the password for the ORACLE ID of the current responsibility to use Examine. If set to Yes, a password will not be required.
32. How do I open a form in query-only mode?
Ans. go
to applcation developer
responsibilitynavigation->Application/function.query the function
name then goto form tab then goto parameters field then write the
following code in that fieldQUERY_YES= YES save the changes and then see
the forms get affected in query only mode.
33. How do I find the version of an installed product? (such as Reports, SQL*Net etc.)
Ans. One
of the easiest ways is to run the product if you can. Running Reports
designer will give you the Reports version, running SQL*Plus will give
you its version etc. Another easy way is to launch the Oracle Installer and look in the installed products on the right side. It will list all the products installed with their versions.
Another way is to look at the .rgs file. This file is located in $ORACLE_HOME/orainst
On UNIX, it will be called unix.rgs. On the PC, it will be called Windows.rgs.
This file will list all the products installed and their versions. Note though that
this file is not always correct. For example, patching Reports from 2.5.5.4 to 2.5.5.8 will not show up in this file as the new version. Running Reports Designer is the best way of getting the correct version.
Also, on UNIX there is an executable called 'inspdver'. It is located in $ORACLE_HOME/orainst.
Running it will produce a display of all the installed products. It just pulls the information from unix.rgs, so it may show the wrong information as well.
34. How do I generate one single form? (As opposed to using adadmin to generate them all)
Ans. No ANSWER
35. What should I do if I am missing an executable from my APPL_TOP?
Ans. relink the particular module eg :if FNDLOAD is missing then relink FND module
Regards,
ReplyDeleteHarish
Oracle technical and fusion cloud SCM online classes, if you are interested please whatsapp to this number +91 7382582893, thank you.