Project Accounting APIs...

APIs Packages

Package Name: Create Agreement

Internal Name: PA_AGREEMENT_PUB

Description: This package contains the public AMG APIs for agreement and Funding procedures that will be used by the external system

APIs (Functions and Procedures):

Name	Internal Name	Description
Create Multiple Project Agreements - Clear	CLEAR_AGREEMENT	This API clears the globals that were set up during initialization In order to execute this API the following list of API's should be executed in the order of sequence.
Create Multiple Project Agreements - Execute Create	EXECUTE_CREATE_AGREEMENT	This API creates an agreement with the funding using the data stored in the global tables during the load phase In order to execute this API the following list of API's should be executed in the order of sequence.
Create Multiple Project Agreements-Initialize	INIT_AGREEMENT	This API sets the global tables used by load-execute-fetch procedures that create a new agreement or update an existing agreement In order to execute this API the following list of API's should be executed in the order of sequence.
Create Multiple Project Agreements-Load	LOAD_AGREEMENT	This API loads an agreement to a PL/SQL record In order to execute this API the following list of API's should be executed in the order of sequence.
Create Multiple Project Fundings - Fetch	FETCH_FUNDING	This API gets the return status that was returned during creation of funds and stored in a global PL/SQL table In order to execute this API the following list of API's should be executed in the order of sequence.
Create Multiple Project Fundings-load	LOAD_FUNDING	This API loads funding to a PL/SQL table In order to execute this API the following list of API's should be executed in the order of sequence.
Create Project Agreement	CREATE_AGREEMENT	This API creates an agreement with associated funds from an external system
Create Project Funding	ADD_FUNDING	This API adds funding to an agreement
Delete Project Agreement	DELETE_AGREEMENT	This API deletes an agreement with associated funds from an external system
Delete Project Funding	DELETE_FUNDING	This API deletes a fund from an agreement
Update Multiple Project Agreements	EXECUTE_UPDATE_AGREEMENT	This API updates an agreement with the funding using the data stored in the global tables during the load phase In order to execute this API the following list of API's should be executed in the order of sequence.
Update Project Agreement	UPDATE_AGREEMENT	This API updates an agreement and associated funds
Update Project Funding	UPDATE_FUNDING	This API updates a fund for an agreement
Validate Project Agreement Deletion	CHECK_DELETE_AGREEMENT_OK	This API checks whether an agreement can be deleted.
Validate Project Funding Creation	CHECK_ADD_FUNDING_OK	This API checks whether a fund can be added.
Validate Project Funding Deletion	CHECK_DELETE_FUNDING_OK	This API checks whether a fund can be deleted
Validate Project Funding Update	CHECK_UPDATE_FUNDING_OK	This API checks whether a fund can be added.

Package Name: Create Budget

Internal Name: PA_BUDGET_PUB

Description: This package contains the public AMG APIs for Budgets that will be used by the external system for preparing budget and use the API's to interface the budget and budget line into Oracle Projects.

APIs (Functions and Procedures):

Name	Internal Name	Description
Create Budget Line	ADD_BUDGET_LINE	This API is used to add a budget line to a working budget in Oracle Projects for a given project and budget type.
Create Draft Budget	CREATE_DRAFT_BUDGET	This API is used to create a draft budget and its budget lines in Oracle Projects for a given project, using a selected budget type and budget entry method.
Create Multiple Budgets- Load Budget Line	LOAD_BUDGET_LINE	This API is used to load a budget line to a global PL/SQL table.
Create Multiple Budgets-Clear	CLEAR_BUDGET	This API is used clear the global data structures set up during the Initialize step.
Create Multiple Budgets-Create Draft Budget	EXECUTE_CREATE_DRAFT_BUDGET	This API is used to create a budget and its budget lines using the data stored in the global tables during the Load process.
Create Multiple Budgets-Execute Calculate Amounts	EXECUTE_CALCULATE_AMOUNTS	This API is used to calculate the raw cost, burdened cost, and revenue amounts using existing budget lines for a given project and budget type In order to execute this API, the following list of API's should be executed in order of sequence.
Create Multiple Budgets-Fetch Calculate Amounts	FETCH_CALCULATE_AMOUNTS	This API is used to get the raw cost, burdened cost, and revenue amounts by budget line from global records updated by the API In order to execute this API, the following list of API's should be executed in order of sequence.
Create Multiple Budgets-Initialize	INIT_BUDGET	This API is used to set up the global data structures that other Load Execute Fetch procedures use to create a new or update an existing draft budget in Oracle Projects In order to execute this API, the following list of API's should be
Create Multiple Budgets-Initialize Calculate Amounts	INIT_CALCULATE_AMOUNTS	This API issued to set up the global data structures used by the Load Execute Fetch API CALCULATE_AMOUNTS In order to execute this API, the following list of API's should be executed in order of sequence.
Create Multiple Budgets-Load Fetch Line	FETCH_BUDGET_LINE	This API is used to retrieve the return status returned during the creation of a budget line from a global PL/SQL table.
Delete Budget Line	DELETE_BUDGET_LINE	This API is used to delete a budget line from a working budget in Oracle Projects for a given project and budget type.
Delete Draft Budget	DELETE_DRAFT_BUDGET	This API is used to delete a working budget in Oracle Projects for a given project and budget type.
Fetch Calculate Amounts	FETCH_CALCULATE_AMOUNTS	This API is used to get the raw cost, burdened cost, and revenue amounts by budget line from global records updated by the API
Get Budget Amounts	CALCULATE_AMOUNTS	Using the PA_CLIENT_EXTN_BUDGET extension, you can use the public API CALCULATE_AMOUNTS to recalculate raw cost, burdened cost, and revenue amounts for existing budget lines.
Update Budget	UPDATE_BUDGET	This API is used to update the working budget with its budget lines in Oracle Projects for a given project.
Update Budget Line	UPDATE_BUDGET_LINE	This API is used to update an existing budget line of a working budget in Oracle Projects for a given project and budget type.
Update Multiple Budgets	EXECUTE_UPDATE_BUDGET	This API is used to update a budget and its budget lines using the data stored in the global tables during the Load process.
Verify Budget Amounts	BASELINE_BUDGET	This API is used to baseline an existing budget in Oracle Projects for a given project and budget type

Package Name:

Internal Name: PA_RESOURCE_PUB

Description: This package contains the public AMG APIs that will be used to export the resource lists and the resources they include to the Oracle Projects. Oracle Projects updates its resource information accordingly.

APIs (Functions and Procedures):

Name	Internal Name	Description
Create Multiple Resource Lists-Clear	CLEAR_CREATE_RESOURCE_LIST	This API is used to clear the global data structures set up during the Initialize step.
Create Multiple Resource Lists-Execute Create	EXEC_CREATE_RESOURCE_LIST	This API is used to execute the composite API CREATE_RESOURCE_LIST In order to execute this API the following list of API's should be executed in the order of sequence.
Create Multiple Resource Lists-Fetch	FETCH_RESOURCE_LIST	This API is used to fetch one resource list identifier at a time from the global output structure for resource lists.
Create Multiple Resource Lists-Initialize	INIT_CREATE_RESOURCE_LIST	This API is used to set up the global data structures used by other Load Execute Fetch procedures.
Create Multiple Resource Lists-Load	LOAD_RESOURCE_LIST	This API is used to load the resource list global input structure.
Create Resource List	CREATE_RESOURCE_LIST	This API creates a resource list and optionally creates the resource list members.
Create Resource List Member	ADD_RESOURCE_LIST_MEMBER	This API adds a resource member to an existing resource list
Delete Resource List	DELETE_RESOURCE_LIST	This API Deletes a resource member from an existing resource list
Delete Resource List Member	DELETE_RESOURCE_LIST_MEMBER	This API deletes a given resource list member
Update Multiple Members-Load	LOAD_MEMBERS	This API is procedure used to load the resource list member global input structure.
Update Multiple Members-Clear	CLEAR_UPDATE_MEMBERS	This API is used to clear the global data structures that were set up during the Initialize step for the Load Execute Fetch update APIs.
Update Multiple Members-Fetch	FETCH_MEMBERS	This API is used to fetch resource members from the global output structure for resource list members.
Update Multiple Members-Initialize	INIT_UPDATE_MEMBERS	This API is used to set up the global data structures used by other Load Execute Fetch procedures.
Update Multiple Members-Sort	SORT_RESOURCE_LIST_MEMBERS	This API updates the sort order for resource members in a given resource list
Update Multiple Resource Lists	EXEC_UPDATE_RESOURCE_LIST	This API is used to execute the composite API UPDATE_RESOURCE_LIST.
Update Resource List	UPDATE_RESOURCE_LIST	This API is used to update an existing resource list, including updating existing or adding new resource list members.
Update Resource List Member	UPDATE_RESOURCE_LIST_MEMBER	This API updates the alias and enables or disables the resource list members.

Package Name: Project Pub

Internal Name: PA_PROJECT_PUB

Description: This package contains the public AMG APIs for project and task information

APIs (Functions and Procedures):

Name	Internal Name	Description
Create Multiple Projects-Clear Project	CLEAR_PROJECT	This API procedure is used to clear the global structures setup during the load process In order to execute this API the following list of API's should be executed in the order of sequence.
Create Multiple Projects-Execute Create Project	EXECUTE_CREATE_PROJECT	This Load Execute Fetch API is used to create a project and its tasks using the data stored in the global tables during the Load process In order to execute this API the following list of API's should be executed in the order of sequence.
Create Multiple Projects-Execute Update Project	EXECUTE_UPDATE_PROJECT	This API procedure is used to update an existing project, including changing or adding project data, adding new tasks, and updating existing tasks.
Create Multiple Projects-Init Project	INIT_PROJECT	This API procedure is used to the global data structures. Other Load-Execute-Fetch use the structures to create a new project in Oracle Projects In order to execute this API the following list of API's should be executed in the order of sequence.
Create Multiple Projects-Load Class Category	LOAD_CLASS_CATEGORY	This Load Execute Fetch API is used to load class categories to a global PL/SQL table.
Create Multiple Projects-Load Key Member	LOAD_KEY_MEMBER	This Load Execute Fetch API is used to use to load key members to a global PL/SQL table.
Create Multiple Projects-Load Project	LOAD_PROJECT	This API is used to use to load a project to a global PL/SQL record.
Create Multiple Tasks-Fetch	FETCH_TASK	This Load Execute Fetch API is used to fetch output parameters related to tasks.
Create Multiple Tasks-Load	LOAD_TASK	This API is used to load a task to a global PL/SQL table.
Create Project	CREATE_PROJECT	This API creates a project in the Oracle Projects using a Template or existing project.
Create Task	ADD_TASK	This API is used to add new subtasks to a task of a project in Oracle Projects.
Delete Project	DELETE_PROJECT	This API procedure is used to delete a project and its tasks from Oracle Projects
Delete Task	DELETE_TASK	This API is used to delete tasks of a project in Oracle Projects
Update Task	UPDATE_TASK	This API is used to update existing tasks of a project in Oracle Projects.
Update project	UPDATE_PROJECT	This API procedure pushes project and task information from your external system to Oracle Projects to reflect any changes you have made in the external system
Validate Project Deletion	CHECK_DELETE_PROJECT_OK	This API is used to determine if you can delete a project.
Validate Project Organization Change	CHECK_CHANGE_PROJECT_ORG_OK	This API is used to determine if you can change the CARRYING_OUT_ORGANIZATION_ID field for a particular project or task.
Verify Parent Change	CHECK_CHANGE_PARENT_OK	This API is used to determine if you can move a task from one parent task to another.
Verify Project Reference Uniqueness	CHECK_UNIQUE_PROJECT_REFERENCE	This API is used to determine if a new or changed project reference (PM_PROJECT_REFERENCE) is unique.
Verify Subtask Addition	CHECK_ADD_SUBTASK_OK	This API is used to determine if a subtask can be added to a parent task.
Verify Task Deletion	CHECK_DELETE_TASK_OK	This API is used to determine if you can delete a task.
Verify Task Number Change	CHECK_TASK_NUMBER_CHANGE_OK	This API is used to determine if you can change a tasks number.
Verify Task Number Uniqueness	CHECK_UNIQUE_TASK_NUMBER	This API is used to determine if a new or changed task number is unique within a project.
Verify Task Reference Uniqueness	CHECK_UNIQUE_TASK_REFERENCE	This API is used to determine if a new or changed task reference (PM_TASK_REFERENCE) is unique.

Package Name: Project Billing Events

Internal Name: PA_EVENT_PUB

Description: This package contains the public AMG APIs which provide an open interface for external systems to insert, update and delete events.

APIs (Functions and Procedures):

Name	Internal Name	Description
Create Billing Event	CREATE_EVENT	This API creates an event or a set of events.
Create Multiple Billing Events – Clear	CLEAR_EVENT	This API clears the globals that were set up during initialization.
Create Multiple Billing Events - Execute Create	EXECUTE_CREATE_EVENT	This API creates an event using the data which is stored in the global tables during the Load phase In order to execute this API the following list of API's should be executed in the order of sequence.
Create Multiple Billing Events – Fetch	FETCH_EVENT	This API gets the return_status that was returned during creation of an event and stored in a global PL/SQL table.
Create Multiple Billing Events – Load	LOAD_EVENT	This API loads an event to a PL/SQL record.
Create Multiple Billing Events-Initialize	INIT_EVENT	This API sets the global tables used by the Load Execute Fetch procedures that create a new event or update an existing event.
Delete Billing Event	DELETE_EVENT	This API deletes an event.
Update Billing Event	UPDATE_EVENT	This API updates an event or set of events.
Update Multiple Billing Events-Update	EXECUTE_UPDATE_EVENT	This API updates event data using the information stored in the global tables during the Load phase.
Validate Billing Event Deletion	CHECK_DELETE_EVENT_OK	This API checks whether an event can be deleted.

Open Interfaces

Name	Internal Name	Description
PRC: Interface Assets to Oracle Assets	PAXCPCAL	The Interface Assets process sends valid asset lines to Oracle Assets to become fixed assets. The process creates one mass addition line in Oracle Assets for each asset line in Oracle Projects, assigning the asset information you entered for the CIP asset to the mass addition line in Oracle Assets. Interface the costs to General Ledger before you run the Interface Assets process.
PRC: Interface Cross Charge Distributions to General Ledger	PACCGLTR	The process identifies the cross charged transactions that fit the parameters you specify and then interfaces the cross charged distributions to General Ledger
PRC: Interface Expense Reports from Payables	PAAPIMP	This process gets expense report information from Payables. This process creates pre- approved expense report batches from expense report information entered in Self-Service Expenses or in the invoices window (in payables).
PRC: Interface Expense Reports to Payables	PATTER	The Interface Expense Reports to Payables process collects all eligible expense reports, including adjustments, in Oracle Projects and interfaces them to the Oracle Payables interface tables.
PRC: Interface Intercompany Invoices to Receivables	PATTAR-IC	This process collects all eligible intercompany invoices in Oracle Projects and interfaces them to the Oracle Receivables interface tables.
PRC: Interface Invoices to Receivables	PATTAR	This process collects all eligible draft invoices in Oracle Projects and interfaces them to the Oracle Receivables interface tables. The process also maintains the project balances of unbilled receivable and unearned revenue and creates accounting transactions for these amounts.
PRC: Interface Labor Costs to General Ledger	PAGGLT	This process collects all eligible labor costs in Oracle Projects and interfaces them to the Oracle General Ledger interface tables. The interface process also determines the liability account for the labor costs.
PRC: Interface Revenue to General Ledger	PATTGL	This process collects all eligible revenue in Oracle Projects and interfaces it to the Oracle General Ledger interface tables. This process also maintains project balances for unbilled receivables and unearned revenue and creates accounting transactions for these amounts.
PRC: Interface Supplier Costs	PAAPIMP_SI	The PRC: Interface Supplier Invoices from Payables process retrieves the following items and interface them to Oracle Projects: All eligible posted, project related supplier invoices from Oracle Payables, Tax lines for project related intercompany invoices. The process first populates the Transaction Import Interface table, creating a cost distributed expenditure item and cost distribution line for each invoice distribution line, and expenditure for each invoice.
PRC: Interface Supplier Invoice Adjustment Costs to Payables	PAVTVC	This process collects all eligible supplier invoice adjustment costs in Oracle Projects and interfaces them to Oracle Payables. The process determines the liability account for the supplier invoice costs.
PRC: Interface Total Burdened Cost to GL	PACTFTBC	This process collects all eligible total burdened distribution lines in Oracle Projects and interfaces them to Oracle General Ledger.
PRC: Interface Usage and Miscellaneous Costs to General Ledger	PASGLT	This process collects all eligible cost distribution lines of the following transactions in Oracle Projects and interfaces them to the Oracle General Ledger interface tables: usage costs, miscellaneous transaction costs, burden transaction costs, and Inventory and WIP transactions not already costed or accounted. The interface process also determines the liability account for these costs.
PRC: Transaction Import	PAXTRTRX	Transaction Import is an open interface that enables you to load transactions from external cost collection systems into Oracle Projects. Transaction Import creates pre-approved expenditure items from transaction data entered in external cost collection systems.

Oracle Apps Question Answer 2

1.Q. Different Type of Value Sets. What is exactly Translatable independent and Translatable Dependent Value Sets (Introduced in latest version of 11i).

Ans:- There are 8 types of Values Sets.

a.       None (Non Validate at all) (Validation is Minimal)

b.       Independent (Input must exist on previous defined list of values)

c.        Dependent (Input is checked against a subset of values based on prior Value)

d.       Table (Input is checked against a subset of values in an application table)

e.       Special (advanced) (Value set uses a flexfield itself)

f.         Pair (advanced) (Two Flexfields together specify a range of valid values)

g.       Translatable Independent (Input must exist on previous defined list of values. Translated value can be used)

h.       Translatable Dependent. (Input is checked against a subset of values based on a prior value; translated value can be used)

(Note:- When you first define your flexfields, you choose how many segments

You want to use and what order you want them to appear. You also

Choose how you want to validate each of your segments. The decisions

You make affect how you define your value sets and your values.)

2.Q. How to run a concurrent program. What all concurrent programs u have 

        created.

Ans:- (Definition :-  A concurrent program is an instance of an execution file, along with

parameter definitions and incompatibilities. Concurrent programs use concurrent program executables to locate the correct execution file.)

Oracle Tool Concurrent Program * A concurrent program written in

·          Oracle Reports, PL/SQL package procedures,

      SQL*Loader, SQL*Plus, Host Scripting.

How to Run :  * Write a execution file and place in correct directory.

·          Establish executables in Oracle apps specify execution file and method.

·          Define Concurrent Program (Program, Parameters and Incompatibilities)

·          Call your Program (- Thu application form, from other concurrent program.

-          OR through standard request submission, you must check the ‘USE in SRS check box’ and register your program parameters when you define your concurrent program. Add your program into the request security  group for your custom application.)

I have created reports through concurrent program, load(sql*loader/pl-sql pkg-proc) the file through concurrent program.

3.Q. What is parameter in apps  and from where u can create it.

Ans:- Parameters only using in report, you can create in defining the report in apps (you can create the parameter there only).

4.Q.What all are the tables used in the modules u have worked on.

*In GL – I have worked on GL_JE_HEADERS(JOURNALS HEADER),GL_JE_LINES(JOURNAL LINES), GL_JE_BACHES(JOURNAL BATCHES), GL_SET_OF_BOOK(SET_OF_BOOK_ID),

*In PO- I have worked on PO_HEADER_ALL…..

5.Q.What is Profile? Explain different levels of  Profile.

Ans:- A user profile is a set of changeable options that affects the way yourapplications run. Oracle Application Object Library establishes a value for each option in a user’s profile when the user logs on or changes responsibility. Your user can change the value of profile options at any time a) To create Profile Option. ( Profile Option can created by developer in application developer area)  b)set the value (Values of the profile option , who will have what value at various levels is set by SYSADMIN). Oracle Application Object Library provides many options that. (Edit profile feature for every user is available to set any value to allow the user).your users can set to alter the user interface of your applications to satisfy their individual preferences.

Profile Option – set at run time like – User Related, responsibility, Sequence, Printer, Security.

Values in 4 Levels(HIEARCHY WISE) :-

A.       USER

B.       RESPONSIBILITY

C.      APPLICATION

D.      SITE

Application Developer create the profile.

System Administrator make profile option.

(NOTE:- If any change in value, it will active when you re-login or switch

  to the responsibility.)

                                ( Usage in the multi-tier, the profile is biggest impact)

                               

6. Q.How to restrict the data for a responsibility as per the ORG-ID

Ans:-Through Multi – Org(MO) u can restrict the data for a responsibility as per the ORG-ID. Only in GL- Set of book Id you set the value to restrict the data for a responsibility.

7.Q. What is Flexfield? What is flexfield qualifier and what is segment qualifier?

Ans:- A flexfield is made up a segments (Which are actually table columns). Each segment has a name that can be assigned, and set of valid value.

Purpose and Application:-

* Flexibility to implement code structure.

* Flexibility to capture additional information.               

Two Types of Flexfields in oracle apps.

a.       Key Flexfields (KFF)

b.       Descriptive Flexfields (DFF)

A key flexfield segment has a name you assign, and set of valid values you specify. Each value has a meaning which can be specified.

Flexfield Qualifier:-A flexfield qualifier identifies a particular segment of a key flexfield..

Usually an application needs some method of identifying a particular

segment for some application purpose such as security or computations. However, since a key flexfield can be customized so that segments appear in any order with any prompts, the application needs a mechanism other than the segment name or segment order to

use for segment identification.

Segment Qualifier :- A segment qualifier identifies a particular type of value in a single

segment of a key flexfield.

 In the Oracle Applications, only the. Accounting Flexfield uses segment qualifiers. You can think of a segment qualifier as an ”identification tag” for a value. In the Accounting Flexfield, segment qualifiers can identify the account type

8.Q. Which flexfield qualifiers are mandatory?

Ans:- ‘Balancing Segment’  flexfield qualifier is mandatory.

9. Can we see our data of RA_CUSTOMER (account Receivables) in Order Management?

Ans:-**********

10. Difference Between versions of Apps.(Front end & Database)

Ans:- In backend- Client server architecture (old)/  Three tire architecture

          In font end- Client Server Application (old)/  Web Based  application


 Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide) 

11.Q.What Difference Between report development and report customization.

Ans:- Report Development means – make the new report and attach to the oracle apps.

          Report Customization means – customize the existing oracle apps report.                

 12.Q.How to change the forms and reports from older versions to newer

versions(for D2k).

Ans:-*******************

13.Q.What is MULTI-ORG and what is structure of multi-org.

Ans:- Use a single installation of any oracle applications product to support any number of organizations. if those organizations use different set of books.

Support any number or legal entities with a single installation of oracle applications.

Secure access to data so that users can access only the information that is relevant to them.

Structure :-  Business Unit

 -HRMS(Employee)

 -GL(Set of Books)(Currency, Calendar, Chart of Account)

|

                                Balancing Segment(You can do multiple balancing segment)

-Operating Units (Purchase, Selling, Fixed Asset, Payable,

     Receivables)

-Inventory Organizations (Storing Items, Transaction Happening,

Ware Housing)

(Note:- Means if you maintaining GL(set of book id), If  u have operating unit, if you

have inventory then its called MULTI-ORG)

14.Q.What is difference between ORG_ID and ORGANIZATION_ID in Multi-Org.

            At where we can set ORG_ID and ORGANIZATION_ID level it comes in the

structure.

Ans:-A Global Variable exists in the oracle database called CLIENT_INFO, which is 64 bytes long. The first 10 bytes are used to store the operating unit ID(or ORG_ID) for the multiple organization support feature.

Multi-Org views are partitioned by ORG_ID. The ORG_ID value is stored in CLIENT_INFO variable.(It comes in AP,PO,AR,OM level)

ORGANIZATION_ID – Its for Inventory, Mfg, & BOM.

15.Q.What are the default types of parameters. What is the use of each one of it.

Ans:-******

16.Q.ORG_ID can be set at master levels or transaction level.

Ans:- ORG_ID can be set at transaction Level.

17.Q.Differnet type of execution methods in Conc.Progs. Explain Each Type.

Ans:- a.Oracle Reports- You can register your report as executable file type is oracle reports.

b. PL/SQL Package Procedure - You can register your PL/SQL Package Procedure as executable file type is oracle PL/SQL Package Procedure.

c.        SQL Loader- You can register your SQL Loader SQL Loader is your executable file type.(for data loading)

d.       SQL*Plus :- You can register your SQL script as SQL*Plus executable type.

e.       Host Scripting:- You can write down Unix Host scripting and register here.

18 .Q. What is Database Tuning:-

Ans:- Database Tuning is required when your program is using more resource and performance is very slow, database tuning is required. Means its required some optimization in database level. There are two types of optimization

a.       Cost Based optimization.

b.       Rule based optimization.

19.Q.What is Schema

Ans:-The create Schema command creates a collection of tables, views, and previlege grants as a single transaction. The schema name is the same as your oracle user name. The create table, create view, an grant commands are the standard commands, and the order in which the commands appear is not important, even if there internal dependencies.

20.Q. What is difference between oracle schema and apps schema.

Ans:-Database Schema-

 The APPS schema- is an ORACLE schema that has access to the

complete Oracle Applications data model. This schema is maintained

by AutoInstall.

21.Q.What are the objects APPS schema contain.

Ans:- The APPS schema contains synonyms to all tables and

sequences as well as all server–side code (stored procedures, views,

and database triggers).

For ERP applications, data partitioning is performed by database

views. These views reside in the APPS Oracle schema and derive the

appropriate operating unit context from an RDBMS variable.



Pro WF: Windows Workflow in .NET 3.5 

22.Q.What is Workflow and what is the benefit of using workflow

Ans:-A graphical tool that allows you to CREATE, TRACK and MODIFY business process.

Embedded in the Oracle Database Server, It can monitor the workflow activity statuses.

Benefits:-

*Create a clear business process definition

*Automate the business routings

*Monitor the process

*Allow users to define their own business process to suit their organization needs.

*Readily change the business process definitions in case of a change business process.

23.Q.Where exactly u place your forms in APPS environment.

Ans:- /apps/visappl/au/11.5.0/forms/US

24.Q.What are the factors for application developer responsibility.

Oracle PL/SQL/Forms/Reports:

31.Q.What is type of Triggers in Oracle

Ans:- Two Types of trigger in Oracle.

Trigger only fire on table or any specific column for that table, it will fire when any DML statement (INSERT,UODATE,DELETE) will execute, its system control

a.       Statement Level Trigger. (Under this there are 6 triggers)

1.Befor Insert

2.Before Update

3.Before Delete

4.After Insert

5.After Update

6.After Delete

b.       Row Level Trigger. (Under this there are 6 triggers)

1.Befor Insert

2.Before Update

3.Before Delete

4.After Insert

5.After Update

6.After Delete

Oracle PL/SQL For Dummies