How to find Trace file location when you are given Trace ID

select name,value from v$parameter where name='user_dump_dest';


SELECT 'Request id: '||request_id ,
'Trace id: '||oracle_Process_id,
'Trace Flag: '||req.enable_trace,
'Trace Name:
'||dest.value||'/'||lower(dbnm.value)||'_ora_'||oracle_process_id||'.trc',
'Prog. Name: '||prog.user_concurrent_program_name,
'File Name: '||execname.execution_file_name|| execname.subroutine_name ,
'Status : '||decode(phase_code,'R','Running')
||'-'||decode(status_code,'R','Normal'),
'SID Serial: '||ses.sid||','|| ses.serial#,
'Module : '||ses.module
from fnd_concurrent_requests req, v$session ses, v$process proc,
v$parameter dest, v$parameter dbnm, fnd_concurrent_programs_vl prog,
fnd_executables execname
where req.request_id = 65791130
and req.oracle_process_id=proc.spid(+)
and proc.addr = ses.paddr(+)
and dest.name='user_dump_dest'
and dbnm.name='db_name'
and req.concurrent_program_id = prog.concurrent_program_id
and req.program_application_id = prog.application_id
and prog.application_id = execname.application_id
and prog.executable_id=execname.executable_id;

Replace Trace ID with your trace ID and find the location of trace file and extract

How to set profile options to enable personalization?

System Administrator -->Profile-->System-


Ensure to set system profile 'Hide Diagnostics menu entry' to 'No' and 'Utilities:Diagnostics' to 'Yes' at the user level

Full Forms

EBS - E - Business Suite
ERP - Enterprise Resource Planning
P2P - Procure to Pay
TNS - Transparent Network Substrate
OM - Order Management
CRM - Customer Relationship Management
ASL - Approved Suppliers List
DFF - Descriptive Flex Fields
KFF- Key Flex Fields
PO - Purchase Order
SO - Sales Order
PLL - Program Link Library
COA - Chart of Accounts
MRP - Material Requirement Planning
SR - Service Request
WIP - Work in Progress
WMS - Warehouse Management Systems
RMA - Return Material Authorization
AFF - Accounting Flex Fields
PLL - PL/SQL Link Module Library
FMB - Form Module Binary
MMB - Menu Module Binary

How to Find UTL File Directory in Apps

Type the following command in SQLDeveloper or TOAD or SQL*Plus

show parameter UTL_FILE_DIR;

It displays UTL_FILE_DIR in apps

How to login to WinSCP and Putty?

The username and password of WinSCP and Putty are the same

Hostname can be the name of the host found in TNS or even you can use the IP Address as well and password is given by the DBA. Make sure the connection type is SSH and the port number usually gets defualted to 22. Save the credentials and login to the unix box.

To change the password using putty. You can use passwd command

New API's for Suppliers in R12

Name of Package: AP_VENDOR_PUB_PKG (apvndrs.pls and apvndrb.pls) 

AP_VENDOR_PUB_PKG.Create_Vendor

This is used to create new vendors in R12

AP_VENDOR_PUB_PKG.r_vendor_rec_type

If the TCA Party ID is provided in record type, the system will validate and create the new record in AP_SUPPLIERS else system calls TCA API to create API then create records in AP_Suppliers

AP_VENDOR_PUB_PKG.Update_Vendor_Public

Use to update vendor in R12

 AP_VENDOR_PUB_PKG.Create_Vendor_Site

 This is the new API to create new vendor sites in Release 12.

AP_VENDOR_PUB_PKG.Update_Vendor_Site_Public

        This is the new API to update Vendor Sites in Release 12.

AP_VENDOR_PUB_PKG.Create_Vendor_Contact

        This is the new API to create new vendor site contacts in Release 12. 

AP_VENDOR_PUB_PKG.Update_Vendor_Contact_Public

        This is the new API to update Vendor Contacts in Release 12.

 

CONCURRENT PROGRAMS IN R12 SUPPLIERS

       APXSUIMP - SUPPLIER OPEN INTERFACE IMPORT 

Supplier Open Interface Import program is extended to create Parties in TCA when creating the suppliers based on the information in AP_SUPPLIERS_INT. If records are populated in the IBY External Payee Accounts table, then the program will call the necessary APIs from Oracle Payments to create the Supplier Bank Accounts.


 APXSSIMP -- Supplier Sites Open Interface Import Supplier Sites Open Interface Import program is extended to create Locations, Party Sites, and Party Site Uses in TCA based on the information provided in AP_SUPPLIER_SITES_INT. If records are populated in the Payments External Payee Accounts table, then the program will call the necessary APIs from Oracle Payments to create the Supplier Bank Accounts for the site. 

APXSCIMP -- Supplier Site Contacts Open Interface Import Supplier Sites Contacts Open Interface Import program is extended to create Person Parties, Contact Relationships, Org Contacts, Contact Party Sites, and Contact Points in TCA based on the information provided in AP_SUPPLIER_SITES_INT.