Purge Concurrent Request and/or Manager Data

Note 154850.1 - How to Run the Purge Concurrent Request and/or Manager Data Program and Which Tables Does it Purge?


Note: 1086013.1 - How to run the Purge Concurrent Request and/or Manager Data program and which tables does it purge?

Read More

How many times a responsibility has been used by a particular user

You just to enable audit as per metalink Note: '436316.1 - Auditing: How Do I Audit Responsibilities and Data?', and run the reports mentioned in the same document

Read More

How to change the OFSA application front end colour code

Note: 180482.1 - How to Change the Background Color of an OFSA Application

Read More

Oracle Applications R12 – Complete Documentation

Oracle Applications R12 For complete documentation .........


http://download-west.oracle.com/docs/cd/B40089_02/current/html/docset.html

Read More

FIRST POST

FIRST TETS POST

Read More

How : How and what FA Populates into GL

These are the columns which are used for capturing the information from FA to GL.

Convention :GL_INTERFACE table column (GL_LINES table COLUMN) :FA REFERENCE

REFERENCE21(REFERENCE_1):TRANSACTION_HEADER_ID
REFERENCE22(REFERENCE_2):ASSET_ID
REFERENCE23(REFERENCE_3):DISTRIBUTION_ID
REFERENCE24(REFERENCE_4):ADJUSTMENT_LINE_ID
REFERENCE25(REFERENCE_5):BOOK_TYPE_CODE
REFERENCE26(REFERENCE_6):PERIOD_COUNTER
REFERENCE27(REFERENCE_7):FA_TRANSFER_TO_GL
REFERENCE28(REFERENCE_8):ADJUSTMENT_TYPE / LOOKUP_CODE
REFERENCE29(REFERENCE_9):CJE_ID

Read More

Query : To get the FY info from fa_fiscal_year

select fiscal_year_name,

fiscal_year,

start_date,

end_date

from fa_fiscal_year

where fiscal_year_name='&fyname'
order by 2;

Read More