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

Query : To find PO corrections

execute fnd_client_info.set_org_context('ORG_ID');

SELECT pol.po_header_id,pol.po_line_id, rct.po_line_location_id Line_location_id
, sum (nvl(rct1.source_doc_quantity,0) ) Qty_corrected
from rcv_transactions rct
, rcv_transactions rct1
, po_lines pol
, po_line_locations pll
where rct.transaction_type in ( 'RECEIVE' ,'MATCH')
and rct.po_line_location_id = pll.line_location_id
and rct1.transaction_type = 'CORRECT'
and rct1.parent_transaction_id = rct.transaction_id
and rct1.po_line_location_id = pll.line_location_id
and rct.po_line_id = pol.po_line_id
and nvl(pol.order_type_lookup_code,'QUANTITY') NOT IN ('RATE','FIXED PRICE')
group by pol.po_header_id,pol.po_line_id,rct.po_line_location_id
union all
SELECT pol.po_header_id,pol.po_line_id,rct.po_line_location_id Line_location_id
, sum (nvl(rct1.amount,0) ) Qty_corrected
from rcv_transactions rct
, rcv_transactions rct1
, po_lines pol
, po_line_locations pll
where rct.transaction_type in ( 'RECEIVE' ,'MATCH')
and rct.po_line_location_id = pll.line_location_id
and rct1.transaction_type = 'CORRECT'
and rct1.parent_transaction_id = rct.transaction_id
and rct1.po_line_location_id = pll.line_location_id
and rct.po_line_id = pol.po_line_id
and nvl(pol.order_type_lookup_code,'QUANTITY') IN ('RATE','FIXED PRICE')
group by pol.po_header_id,pol.po_line_id,rct.po_line_location_id

Read More