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

List of Vendor Sites with no invoices, no PO's

Select sites.vendor_site_id,
vend.segment1 Vendor#,
vendor_name,
sites.vendor_site_code,
vend.end_date_active VEND_INACTIVE,
sites.inactive_date SITE_INACTIVE
from po_vendor_sites_all sites,
po_vendors vend,
ap_invoices_all inv,
po_headers_all PO
where vend.vendor_id = sites.vendor_id
and sites.vendor_site_id = inv.vendor_site_id(+)
and inv.vendor_site_id is null
and sites.vendor_site_id = po.vendor_site_id(+)
and po.vendor_site_id is null
and sites.inactive_date < sysdate
order by vendor_name, vendor_site_code;

Read More