93. How do I compile and/or generate an Oracle Applications form
Answer------
a. UNIX
cd $AU_TOP/forms/US
f45gen module=FNDSCAUS.fmb userid=APPS/APPS output_file=
/appl/v1100000/fnd/11.0.28/forms/US/FNDSCAUS.fmx module_type=form
batch=no compile_all=special
b. Windows NT
cd F:\applr11\au\11.0.28\forms\US
f45gen32 userid=APPS/APPS module=FNDSCAUS.fmb output_file=
applr11\fnd\forms\US\FNDSCAUS.fmx module_type=form batch=no
compile_all=special
94. How do I open, compile and/or generate a custom Oracle Applications form on my desktop
Answer
------
a. To port the AU_TOP/forms/US and AU_TOP/resource files to your Windows
desktop:
i. Make copies of all required files.
ii. Replicate the AU_TOP directory structure on your desktop.
iii. Move the files to their appropriate AU_TOP/forms/US for FMB and
AU_TOP/resource for PLL.
iv. Include the AU_TOP/forms/US and AU_TOP/resource directories in
your FORMS45_PATH.
v. Open, compile and/or generate forms.
NOTE: The FORMS45_PATH is specified either in your Registry or oracle.ini.
NOTE: It may sometimes be necessary to convert FMB -> FMT and PLL -> PLD before 38
porting from a Unix platform to your desktop.
95. How do I add a CUSTOM_TOP to Oracle Applications
Answer
a. Replicate an existing Oracle Applications product directory structure underneath your APPL_TOP:
APPL_TOP
|
XXCUS_TOP
|
bin------forms-----html-----lib-----log-----mesg-----out-----reports
| |
US US
b. Make sure all the permissions on the files and directories are the same
as the other product directories.
c. Add the full path to this CUSTOM_TOP to your APPLSYS.env ( Source your
APPLSYS.env) or your Windows NT Registry:
UNIX: /u01/oracle/apps/vd11/xxcus/11.0.28
Windows NT: D:\oa\appltst\vd11\xxcus\11.0.28
d. Login to Oracle Applications using the System Administrator or Application
Developer Responsibility.
e. Navigate: Application -> Register and add your new CUSTOM_TOP to Oracle
Applications.
Application Short Name Basepath Description
-------------------------------------------------------------------------------
Custom Application XXCUS XXCUS_TOP Custom Application
f. Shutdown and restart your Internal Concurrent Manager (ICM) so that the
concurrent manager will recognize the change to the environment that was
made to the APPLSYS.env and Registry.
96. How to get the data from the views in Multi_ORG views
A. Using the profiles and client info package.
Eg:
SELECT FROM po_headers – this is multi org view
If we can?t get the data with the above query then we have to write a procedure as shown below.
DECLARE
x NUMBER:=0; 39
BEGIN
x:=fnd_profile.value('org_id');
fnd_client_info.set_org_context (204);
END;
Compile and run the query once again.
97) What is Responsibility / Request Group
Ans: Responsibility is used for security reason like which Responsibility can do what type of jobs etc.
Set of Responsibility is attached with a Request group. When we attach the request group to a concurrent program, that can be perform using all the Responsibilities those are attached with Request group.
98) What is DFF
Ans: The Descriptive Flexi field is a field that we can customize to enter additional information for which Oracle Apps product has not provided a field.
Ex. ATP program calculates for those warehouses where Inventory Org Type is DC or Warehouse in DFF Attribute11 of MTL_PARAMETERS table.
99) What is Value Set
Ans: Value Sets define and store the valid items of data, which may be entered into a field.
Key Flexfields, Descriptive Flexfields and many standard fields use Value Sets.
Oracle already comes with hundreds of Value Sets.
We define additional Value Sets to support our own user-defined Key and Descriptive Flexfields (although we may use any existing standard Value Sets if they suit our purpose).
In defining a new Value Set, we are defining the physical format of valid data, which can reside in that Value Set.
Data in a Value Set can be of several types:
Independently loaded into a Value Set (through a standard form).
Resident in a table (to which we direct the Value Set definition).
There could be No Validation (any data can go into the field, but still subject to the formatting rules.)
Dependent on the value of data in a preceding Independent segment (loaded through a standard form).
Ex: For Supplies & Accessories CC in ATP, we define GEMS_GPO_ASSIGN_SET value set for the assignment set associated with that OU.
100) What is multi-org
Ans: It is data security functionality in Oracle 10.6 and above. Applicable User responsibilities are created and attached to specific Operating Unit. User can access the data that belongs to the Operating unit they login under. 40
The benefit is it enables multiple operating units to use a single installation of various modules, while keeping transaction data separate and secure by operating unit.
It has an effect on the following modules:
Order Entry
Receivable
Payable
Purchasing
Project Accounting
Answer------
a. UNIX
cd $AU_TOP/forms/US
f45gen module=FNDSCAUS.fmb userid=APPS/APPS output_file=
/appl/v1100000/fnd/11.0.28/forms/US/FNDSCAUS.fmx module_type=form
batch=no compile_all=special
b. Windows NT
cd F:\applr11\au\11.0.28\forms\US
f45gen32 userid=APPS/APPS module=FNDSCAUS.fmb output_file=
applr11\fnd\forms\US\FNDSCAUS.fmx module_type=form batch=no
compile_all=special
94. How do I open, compile and/or generate a custom Oracle Applications form on my desktop
Answer
------
a. To port the AU_TOP/forms/US and AU_TOP/resource files to your Windows
desktop:
i. Make copies of all required files.
ii. Replicate the AU_TOP directory structure on your desktop.
iii. Move the files to their appropriate AU_TOP/forms/US for FMB and
AU_TOP/resource for PLL.
iv. Include the AU_TOP/forms/US and AU_TOP/resource directories in
your FORMS45_PATH.
v. Open, compile and/or generate forms.
NOTE: The FORMS45_PATH is specified either in your Registry or oracle.ini.
NOTE: It may sometimes be necessary to convert FMB -> FMT and PLL -> PLD before 38
porting from a Unix platform to your desktop.
95. How do I add a CUSTOM_TOP to Oracle Applications
Answer
a. Replicate an existing Oracle Applications product directory structure underneath your APPL_TOP:
APPL_TOP
|
XXCUS_TOP
|
bin------forms-----html-----lib-----log-----mesg-----out-----reports
| |
US US
b. Make sure all the permissions on the files and directories are the same
as the other product directories.
c. Add the full path to this CUSTOM_TOP to your APPLSYS.env ( Source your
APPLSYS.env) or your Windows NT Registry:
UNIX: /u01/oracle/apps/vd11/xxcus/11.0.28
Windows NT: D:\oa\appltst\vd11\xxcus\11.0.28
d. Login to Oracle Applications using the System Administrator or Application
Developer Responsibility.
e. Navigate: Application -> Register and add your new CUSTOM_TOP to Oracle
Applications.
Application Short Name Basepath Description
-------------------------------------------------------------------------------
Custom Application XXCUS XXCUS_TOP Custom Application
f. Shutdown and restart your Internal Concurrent Manager (ICM) so that the
concurrent manager will recognize the change to the environment that was
made to the APPLSYS.env and Registry.
96. How to get the data from the views in Multi_ORG views
A. Using the profiles and client info package.
Eg:
SELECT FROM po_headers – this is multi org view
If we can?t get the data with the above query then we have to write a procedure as shown below.
DECLARE
x NUMBER:=0; 39
BEGIN
x:=fnd_profile.value('org_id');
fnd_client_info.set_org_context (204);
END;
Compile and run the query once again.
97) What is Responsibility / Request Group
Ans: Responsibility is used for security reason like which Responsibility can do what type of jobs etc.
Set of Responsibility is attached with a Request group. When we attach the request group to a concurrent program, that can be perform using all the Responsibilities those are attached with Request group.
98) What is DFF
Ans: The Descriptive Flexi field is a field that we can customize to enter additional information for which Oracle Apps product has not provided a field.
Ex. ATP program calculates for those warehouses where Inventory Org Type is DC or Warehouse in DFF Attribute11 of MTL_PARAMETERS table.
99) What is Value Set
Ans: Value Sets define and store the valid items of data, which may be entered into a field.
Key Flexfields, Descriptive Flexfields and many standard fields use Value Sets.
Oracle already comes with hundreds of Value Sets.
We define additional Value Sets to support our own user-defined Key and Descriptive Flexfields (although we may use any existing standard Value Sets if they suit our purpose).
In defining a new Value Set, we are defining the physical format of valid data, which can reside in that Value Set.
Data in a Value Set can be of several types:
Independently loaded into a Value Set (through a standard form).
Resident in a table (to which we direct the Value Set definition).
There could be No Validation (any data can go into the field, but still subject to the formatting rules.)
Dependent on the value of data in a preceding Independent segment (loaded through a standard form).
Ex: For Supplies & Accessories CC in ATP, we define GEMS_GPO_ASSIGN_SET value set for the assignment set associated with that OU.
100) What is multi-org
Ans: It is data security functionality in Oracle 10.6 and above. Applicable User responsibilities are created and attached to specific Operating Unit. User can access the data that belongs to the Operating unit they login under. 40
The benefit is it enables multiple operating units to use a single installation of various modules, while keeping transaction data separate and secure by operating unit.
It has an effect on the following modules:
Order Entry
Receivable
Payable
Purchasing
Project Accounting
No comments:
Post a Comment