First, develop the report & save it in a local machine. upload into custom_top/11.5.0/reports/us/goes to system administrator open executable form create an executable by mentioning executable method as reports, executable as report name which was created. go to the cc program form create a program by attaching executable name in the executable section. then attach this program to request group, Request group to Responsibility. Responsibility to User.
Posted Date:- 2021-10-01 10:34:25
Schema: Schema is the location in the database contains database objects like views, tables, and synonyms.
Apps Schema: It is used to connect the all schemas to get the information from the database.
Posted Date:- 2021-10-01 10:33:33
We can handle errors by using SQL*Loader, or another import program, to load customer information into the interface tables.
When you import customer information, the Customer Interface program validates the global attribute columns in the interface tables and transfers those values into the customer tables.
Get through the interview bar with our selected interview questions for Oracle Apps Technical enthusiasts
Tell me something about SQL-LOADER.
Sql * loader is a bulk loader utility used for moving data from external files into the oracle database.
Posted Date:- 2021-10-01 10:32:43
CHART OF ACCOUNTS
* Your chart of accounts is the account structure you define to fit the specific needs of your organization.
* You can choose the number of account segments as well as the length, name, and order of each segment.
ACCOUNTING CALENDAR :
* An accounting calendar defines an accounting year and the periods it contains.
* You can define multiple calendars and assign a different calendar to each set of books.
CURRENCIES
* You select the functional currency for your set of books as well as other currencies that you use to transact business and report in.
* GL converts monetary amounts entered in a foreign currency to functional currency equivalents using supplied rates.
Posted Date:- 2021-10-01 10:31:54
The transaction calendar is defined to enable average balance processing. The transaction calendar is created optionally with valid business days mentioned.
Posted Date:- 2021-10-01 10:30:44
If you choose to allow posting of out-of-balance/unbalanced journal entries, GL automatically posts the difference to Suspense Account. However, the Suspense Account checkbox should be checked and an Account to be provided for this feature to work during the creation of a set of books.
Posted Date:- 2021-10-01 10:30:09
Custom top can be defined as the customer top which is created exclusively for customers. According to the requirement of the client, many numbers of customer tops can be made. The custom top is made used to store components, which are developed as well as customized. At the time when the oracle corporation applies patches, every module other than the custom top is overridden.
Posted Date:- 2021-10-01 10:29:32
There are certain steps that you need to follow to register the concurrent program.
The first step is to log in to your system with the responsibility of the system administrator.
The next step is to define an executable concurrent program.
While defining concurrent programs do take care to give application name, short name and description along with the selection of executable concurrent program.
Posted Date:- 2021-10-01 10:28:55
The US folder is just a language specification. Multiple folders can be kept for language specifications depending on the languages that are installed.
Posted Date:- 2021-10-01 10:27:57
There are certain steps that you need to follow systematically for attaching the reports along with oracle application.
* Designing the report.
* Generating an executable file related to the report.
* Moving executable and source files to the appropriate folder of the product.
* Registering the report in the form of concurrent executable.
* Defining a concurrent program for registered that is executable.
* Adding a concurrent program for requesting a group of responsibility.
Posted Date:- 2021-10-01 10:27:06
Inbound Interface: For inbound interfaces, where these products are the destination, interface tables as well as supporting validation, processing, and maintenance programs are provided. Outbound Interface: For outbound interfaces, where these products are the source, database views are provided and the destination application should provide the validation, processing, and maintenance programs.
Posted Date:- 2021-10-01 10:25:04
* Identify programs that should not run simultaneously with your concurrent program because they might interfere with its execution.
* You can specify your program as being incompatible with itself.
* Application: Although the default for this field is the application of your concurrent program, you can enter any valid application name.
* Name: The program name and application you specify must uniquely identify a concurrent program. Your list displays the user-friendly name of the program, the short name, and the description of the program.
* Scope: Enter Set or Program Only to specify whether your concurrent program is incompatible with this program and all its child requests (Set) or only with this program (Program Only).
* Run Alone: Indicate whether your program should run alone relative to all other programs in the same logical database. If the execution of your program interferes with the execution of all other programs in the same logical database (in other words, if your program is incompatible with all programs in its logical database, including itself), it should run alone.
Posted Date:- 2021-10-01 10:24:21
* Create the report using the report builder.
* Place the report definition file in the module-specific reports directory.
* Create an executable for the report definition file.
* Create a concurrent program to that executable.
* Associate the concurrent program to a request group.
Posted Date:- 2021-10-01 10:22:51
Oracle Trading Community Architecture (TCA) is a data model that allows you to manage complex information about the parties, or customers, who belong to your commercial community, including organizations, locations, and the network of hierarchical relationships among them. This information is maintained in the TCA Registry, which is the single source of trading community information for Oracle E-Business Suite applications.
Posted Date:- 2021-10-01 10:21:37
A summary column performs a computation on another column's data. Using the Report Wizard or Data Wizard, you can create the following summaries: sum, average, count, minimum, maximum, % total. You can also create a summary column manually in the Data Model view, and use the Property Palette to create the following additional summaries: first, last, standard deviation, variance.
Posted Date:- 2021-10-01 10:17:32
A formula column performs a user-defined computation on another column(s) of data, including placeholder columns.
Posted Date:- 2021-10-01 10:17:02
A placeholder is a column that is an empty container at design time. The placeholder can hold a value at run time has been calculated and placed into It by pl/sql code from another object.
You can set the value of a placeholder column is in a Before Report trigger.
Store a Temporary value for future reference. EX. Store the current max salary as records are retrieved.
Posted Date:- 2021-10-01 10:15:44
Confine mode:
On: child objects cannot be moved outside their enclosing parent objects.
Off: child objects can be moved outside their enclosing parent objects.
Flex mode:
On: parent borders "stretch" when child objects are moved against them.
Off: parent borders remain fixed when child objects are moved against them.
Posted Date:- 2021-10-01 10:14:30
BIND VARIABLE:
are used to replace a single value in sql, pl/sql
bind variable may be used to replace expressions in select, where, group, order
by, having, connect by, start with cause of queries.
bind reference may not be referenced in FROM clause (or) in place of
reserved words or clauses.
LEXICAL REFERENCE:
You can use lexical reference to replace the clauses appearing AFTER select,
from, group by, having, connect by, start with.
You can’t make lexical reference in pl/sql statements.
Posted Date:- 2021-10-01 10:13:44
This object is used for process associated with executable field.
Posted Date:- 2021-10-01 09:56:51
We can handle errors by using SQL*Loader, or another import program, to load customer information into the interface tables.
When you import customer information, the Customer Interface program validates the global attribute columns in the interface tables and transfers those values into the customer tables.
Posted Date:- 2021-10-01 09:54:19
A menu is a hierarchical arrangement of functions and menus. Each responsibility has a menu assigned to it. A function is a part of an application that is registered under a unique name for the purpose of assigning it to be including it from a menu.
Posted Date:- 2021-10-01 09:53:45
Schema: Schema is the location in the database that contains database objects like views, tables, and synonyms.
Apps Schema: It is used to connect all schemas to get the information from The database.
Posted Date:- 2021-10-01 09:52:45
Second parameter can be attained by making use of the first parameter by making use of the command $flex$value set name.
Posted Date:- 2021-10-01 09:50:43
ERP is a software system that is available as a package and can be helpful in automating as well as integrating most of the processes associated with the business.
Posted Date:- 2021-10-01 09:49:48
This is a kind of tool that is highly powerful as well as flexible and helps in building reports that are customized without depending on programming. This tool is only available with GL.
Posted Date:- 2021-10-01 09:49:20
Multiple – Reporting Currency is a kind of feature that is associated with oracle application and helps in reporting as well as maintaining records that are associated with the transaction level in various forms of functional currency.
Posted Date:- 2021-10-01 09:47:02
Responsibility is used for security reasons 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 performed using all the Responsibilities that are attached with the Request group.
Posted Date:- 2021-10-01 09:46:42
Errorbuf: It is used to returns the error messages and sent them to the log file.
Recode: It is used to show the status of the Procedure with 0, 1, and 2 0 for Completed Normal.
1 for Completed Warning
2 for Completed Error
Posted Date:- 2021-10-01 09:45:59
This is a kind of flexfield that is mainly used for gathering extra information and also for providing space for you to form and get expanded.
Posted Date:- 2021-10-01 09:45:05
It is a language-specific folder used to store the G.U.I like reports and forms.
Posted Date:- 2021-10-01 09:44:34
When we connect to the server we will find the top called application top. Under application top we have
Product top.
Custom top
The product top is the default top built by the manufacturer. The custom top is used to select the Client for his business purposes. Customizations are done with the Custom top.
Posted Date:- 2021-10-01 09:44:16
These are the kinds of tables that can be used for the purpose of storing intermediate values or data.
Posted Date:- 2021-10-01 09:43:33
Typically, the last day of the fiscal year is used to perform adjusting and closing journal entries. This period is referred to as Adjusting Period.
Choosing whether to include an adjusting period or not in a calendar is a very important decision. There can be an unlimited number of adjusting periods. Once the accounting calendar is used, changes to its structure to remove or add an adjusting period cannot be done.
Posted Date:- 2021-10-01 09:43:06
No Security: All security is disabled for this value set.
Hierarchical Security: With Hierarchical security, the features of the value security and value hierarchies are combined. With this feature, any security that applies to a parent value also applies to its child values.
Non-Hierarchical Security: Security is enabled, but the rules of the hierarchical security do not apply. That is, a security rule that applies to a parent value does not “cascade down†to its child values.
Posted Date:- 2021-10-01 09:42:26
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.
Posted Date:- 2021-10-01 09:40:49
SELECT MULTI_ORG_FLAG FROM FND_PRODUCT_GROUPS
If MULTI_ORG_FLAG is set to ‘Y’, Then its Multi Org.
Posted Date:- 2021-10-01 09:39:59
The organization that contains your master list of items. You define it by setting the OM: Item Validation Organization parameter. You must define all items and bills in your Item Validation Organization, but you also need to maintain your items and bills in separate organizations if you want to ship them from other warehouses.
OE_System_
Posted Date:- 2021-10-01 09:39:30
A set of values against which Oracle Application Object Library validates values your end-users enter when running your program. You define your value set by specifying validation 28 rules, format constraints, and other properties.
For example, you could define a value set to contain values that are character strings, validated from a table in your application. You can Specify that Oracle Application Object Library uses the same value set to validate different Report parameters. You can also use value sets that you use in your flex fields to validate Your report parameters.
Posted Date:- 2021-10-01 09:38:53
The TEMPLATE form is the required starting point of all development of new forms. Start Developing each new form by copying the TEMPLATE.FMB file, located in $AU_TOP/forms/US(or your language and platform equivalent), to a local directory and Rename it as appropriate.
Posted Date:- 2021-10-01 09:38:19
A user profile is a set of changeable options that affect the way the applications run. Oracle Does applications object Library establish a value for each option in a user's profile when the user logs on or changes responsibility.
<> System Profile: The profile option can be set for the user community.
<> User Profile: Provide Oracle Apps with standard information that describes a user, Application, Responsibility, and site. At each profile level, user profile options can be set.
Posted Date:- 2021-10-01 09:37:59
Custom.pll is used while making new or customizing standard oracle forms in apps. It contains all the forms of libraries for apps.
Posted Date:- 2021-10-01 09:37:16
An environment variable that denotes the installation directory for Oracle Application Object Library and your other Oracle applications. $APPL_TOP is usually one directory level above each of the product directories (which are often referred to as $PROD_TOP or $PRODUCT_TOP or $_TOP).
Posted Date:- 2021-10-01 09:37:04
A function is a part of an application's functionality that is registered under a unique name for the purpose of assigning to it to or excluding it from, a menu (and by extension, responsibility). There are several types of functions: – Form Functions, SubFunctions, and Non-form functions. We often refer to a form function simply as a form.
Posted Date:- 2021-10-01 09:36:49
* Responsibility: A responsibility is a set of authority in Oracle Apps that lets users access only that functionality of the application appropriate to their roles.
* Menu: A menu is a hierarchical arrangement of functions and menus of functions that appears in the * Navigator. Each responsibility has a menu assigned to it.
* Request Group: it is a collection of reports or concurrent programs. A System Administrator defines report groups in order to control user access to reports and concurrent programs.
Only a system administrator can create a request group.
Posted Date:- 2021-10-01 09:36:27
Begin dbms_application_info.set_client_info(‘ORG_ID’);
end;
Posted Date:- 2021-10-01 09:35:35
Three MASTER CONCURRENT MANAGERS:
* Internal Concurrent Manager (ICM): This is the one that monitors all other CMs
* Standard Manager (SM): This takes care of report running and batch jobs
* Conflict Resolution Manager (CRM): checks concurrent program definitions for compatibility checks.
We cannot delete a concurrent manager… but we can disable it… but it’s not recommended.
Posted Date:- 2021-10-01 09:35:15
Application is a collection of forms, function, and menus
Posted Date:- 2021-10-01 09:34:43
Security Attributes are used by Oracle self-service web Applications to allow rows of data to be visible to specified users' responsibilities based on the specific data contained in the row.
Posted Date:- 2021-10-01 09:34:03
Responsibility is the method through which the group of various modules can be made in a format accessible by users.
Posted Date:- 2021-10-01 09:32:13