How to define a Chart of Accounts in Oracle Apps R12

Chart of Accounts is an Accounting Structure of an organization. It is used to record the transaction activity of an organization. It records the financial and accounting transactions of an organization and helps to maintain accounting balances.

Chart of Account is a key flexfield having one or more data segments as defined by the user.

An oracle Chart of Account can have up to 30 segments in a flexfields. 2 segments are mandatory; Balancing Segment and Natural Accounts.

This means, a flexfield can have minimum of 2 segments and maximum of 30 flexfields.

1. Define value sets for the segemnts.
2. Define segments and assign value sets (created above).
3. Define Qualifiers to the value sets.
4. Freeze and compile.

TOKEN in oracle apps

1. Token acts as an intermediate between oracle report user parameter and concurrent program parameters. It is an interface between concurrent program and report builder. It is used to map the parameters which we have created in the report.
2. It is used for mapping the report builder parameter to concurrent program parameters with same variables.
3. Tokens are case sensitive. So, it should be in the same case as given in the report builder.

How to delete a registered concurrent program

The concurrent program can be deleted from the back-end.
From front end we cannot delete the program, we can only enable or disable the program.

begin
FND_PROGRAM.delete_executable(executable_short_name=>xxexe, application =>XX_Custom);
commit;
end;
/


begin
FND_PROGRAM.delete_program(program_short_name=>XXCONC, application =>XX_custom);
commit;
end;
/

Functional or Technical apps consultant

Its a very common confusion for those who want to switch their career to oracle apps consultant.
There is always a contradiction at the back of the mind whether to be a functional apps consultant of a technical apps consultant.  Its really becomes important to decide the answer to the above question. What's important is finding the right answer can be a huge turnaround in your life from career point of view.   It can possibly can the course of your life.

You must be a functional apps consultant if,

1.  You are from accounting background (not necessary, though). Being from a accounting  background,  will make the functional accounting concept much easier to learn and understand  quickly.
2.  You must have a super user experience in the oracle apps module(s). Super user experience is  advantageous as you can access all the functional components in an apps without any restrictions.   
3. You are technically weak in programming concepts and coding.
4. You like to spend most of your time in meeting and writing documents.
5. You understand the concept and functionality of overall ERP apps modules very well and also the dependencies between the various modules.

You must be a technical apps consultant if,

1. You are technically strong in programming skills and passionate about coding.and preferable from technical background and qualifications.
2. You don't bother the relationships between the apps modules, for instance say between GL and OM module.
3. You are ready to accept new challenges every time and .you like to get a feeling of having achieved something each day.

Make parameters in oracle reports as mandatory

To make parameters in oracle report as mandatory:

Navigate to 'Application developer' in concurrent Program -> parameters window -> "Required field" just check that.