Explore topic-wise InterviewSolutions in .

In simple and LAYMAN WORDS:-

1. Open the PERIOD
2. Create Journal ENTERIES
3. Post the Journals.

In simple and layman words:-

Below are the Profiles LEVEL available in oracle APPS:

1. Site(Lowest level)
2. APPLICATION
3. RESPONSIBILITY
4. User.

Below are the Profiles Level available in oracle apps:

PROFILE: Profile is the CHANGEABLE option that affects the WAY your application runs.

There are TWO types of profile:

1. System defined
2. User defined

Profile: Profile is the changeable option that affects the way your application runs.

There are two types of profile:

Different types of CALENDARS are LISTED below:

• FISCAL
• ACCOUNTING

Different types of Calendars are listed below:

• FUNCTIONAL CURRENCY
• FOREIGN currency.

Flexfield Qualifiers is USED to identify the segments. Various TYPES of flexfield qualifiers are listed below:

• Balancing Segment Qualifier.
• Cost Center segment Qualifier.
• Natural Account Segment Qualifier.
• INTERCOMPANY Segment Qualifier.

Flexfield Qualifiers is used to identify the segments. Various types of flexfield qualifiers are listed below:

MAX 30 SEGMENTS and MIN TWO.

max 30 segments and min two.

1. Company
2. Cost CENTER
3. ACCOUNT
4. PRODUCT
5. Future USE.

SQUARE BRACKET [ ].

Square Bracket [ ].

1. Module KFF
2. GL Accounting FF
3. AP No KFF
4. AR SALES TAX Location FF
5. Territory Flexfield.

KFF:

• Unique IDENTIFIER
• Stored in segment COLUMN

DFF:

• Is used to CAPTURE additional information
• Stored in ATTRIBUTE Column

KFF:

DFF:

Flex field is USED to CAPTURE information of your ORGANISATIONS.

Flex field is used to capture information of your Organisations.

You will need to check your Fa_distribution_history table to SEE if you are missing GAPS there and then trace it to where assets where CREATED, EITHER in FA or in PA.

You will need to check your Fa_distribution_history table to see if you are missing gaps there and then trace it to where assets where created, either in FA or in PA.

• The situation you mentioned is the reasons why you should not change invoices that are accounted for. This can also happen when the J/E is changed since the AR transfer to GL creates unnoted J/E. Changing the said invoices puts GLA and the sub ledger out of SYNC.
• You NEED to SET the journal source for receivables so that the update flag is not enabled.
• In AR, don’t change invoices that are there. Instead use DM and CM functionality to adjust invoices or create new ones.

You have just found out that database would not start correctly in getting the error in identifying CONTROL FILE:

• Go to the COMMON_TOP/admin/install directory/u202/train/d01/oracle/prodcomn/admin/create.
• To solve this, RUN “adcrdb.sh”. This created the control file.
• Restart the database, and then try connecting to APPLICATIONS which will complete the connection.

You have just found out that database would not start correctly in getting the error in identifying control file:

• We have the RA_INTERFACE_LINES_ALL table to be POPULATED. From there, AR PICKS data for creating an INVOICE USING “autoinvoice”.
• While Autoinvoice gets data from ra_interface_lines_all, it ALSO picks data from ra_interface_salescredits_all and ra_interface_distributions_all if it is present.

In order to create a NEW set of DATABASE ORACLE Finance and PROGRAM in the same machine, you will need to create a new INSTANCE. You can create the new instance in the same machine.

In order to create a new set of database Oracle Finance and program in the same machine, you will need to create a new instance. You can create the new instance in the same machine.