How to know the Table name of OAF pages

Please Visit http://www.conacent.com/?page_id=218

How to know the Table name of OAF (Oracle Application Framework)

Step 1. Set the profile option "FND: Diagnostics" at UserLevel to "Yes".
Step 2. Go to the respective OAF form page.
Step 3. Click on "About this Page" link will appear on Left bottom corner of the OAF Page.
Step 4. Either View Object or Flexfield Name will contain the table name.

LogFile Location in R12

Finding Oracle Concurrent Request Log Files:
Concurrent Requests Log And Out Files
$LOG_HOME/APPL/CONC/log
$LOG_HOME/APPL/CONC/out

Mid Tier Startup Scripts Log Files
$LOG_HOME/APPL/ADMIN

Startup/Shutdown error message text files
$INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log



Finding Oracle Apache Log Files:
Apache Error and Access log files
$LOG_HOME/ora/10.1.3/apache

J2EE related log files
$LOG_HOME/ora/10.1.3/j2ee

OPMN related log files
$LOG_HOME/ora/10.1.3/opmn


Finding Forms & Reports Log Files:
Forms related log files
$LOG_HOME/ora/10.1.2/forms

Reports related log files
$LOG_HOME/ora/10.1.2/reports


Finding Oracle Alert Log Files:
$ORACLE_HOME/admin/$CONTEXT_NAME/diag/rdbms/$ORACLE_SID/$ORACLE_SID/trace

Finding Oracle Cloning Related Log Files:
These are pre-cloned log files in source instance
Database Tier
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(STAGEDBTIER_MMDDHHMM.log)
Application Tier
$INST_TOP/apps/$CONTEXT_NAME/admin/log/(STAGEAPPSTIER_MMDDHHMM.log)

These are cloned log files in target instance
Database Tier
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/APPLDBTIER_ .log
Application Tier
$INST_TOP/apps/$CONTEXT_NAME/admin/log/APPLYAPPSTIER_ .log



find *.xml -mtime +100 -print -exec rm {} \;

Note that there are spaces between rm, {}, and \;
Explanation

• The first argument is the path to the files. This can be a path, a directory, or a wildcard as in the example above. I would recommend using the full path, and make sure that you run the command without the exec rm to make sure you are getting the right results.
• The second argument, -mtime, is used to specify the number of days old that the file is. If you enter +5, it will find files older than 5 days.
•  The third argument, -print, will print the file which are been deleted.
• The fourth argument, -exec, allows you to pass in a command such as rm. The {} \; at the end is required to end the command.

How to Assign all the items from Item Master to a diffrent Organization

Prerequisite:- Organization Hierarchy need to setup

Need to run a request :- Item Organization Assignment from Inventory responsibility.
Parameter:- Source Organization as Item Master or any other organization(From where you want to assign)
Hierarchy Origin:- Destination Organization(Where you want to assign all the item)
Hierarchy:- Organization Hierarchy Name
Request Count:-1
Submit the request

HOW WE CAN USE DBLINK BETWEEN TWO ORACLE APPS INSTANCE

How we can get data from another oracle apps database/instance using DBLINK?

1) First we need to connect in TEST instance(192.168.1.2) as SYSTEM/password
2) select name from v$database;  Note the result, It will display TEST database Name
3) Run this command to connect the production instance where PROD is Production instance:-
CREATE PUBLIC DATABASE LINK "PROD" CONNECT TO apps IDENTIFIED BY apps
USING '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))(CONNECT_DATA = (SID = PROD)))';
3) Now run command for testing and check the result :- select name from v$database@PROD ;
It will display PROD database Name
Now you will get the data from Production Server.

Scope of Stand Alone Payable Invoice

Charge Service Tax in AP Standalone Invoice:

Standalone AP Invoices will be raised for non-item based expense or service activities. As Item information is not available for such invoices, regimes like Excise, Customs and VAT that are Item-based tax regimes will not be associated with Standalone AP Invoices. Similarly other tax types such as Octroi, Insurance, and Entry Tax etc. are all Item movement related and hence not applicable to Standalone AP Invoices. Hence the only Indirect Tax regime applicable on Stand-alone invoices will be the Service Tax Regime (Direct Tax regimes such as Tax Deduction at Source shall continue to be supported with the existing Global Flex field basis approach for standalone invoices also).

Value Added Tax (VAT) recovery requirements of India Localization VAT recovery process is currently linked to receipt of goods and also on Item attributes. As AP Standalone Invoice does not carry the Item information, VAT recovery is kept out of scope of this project. User should use the VAT Manual recovery entry mechanism for handling exceptional scenarios where a stand-alone invoice is carrying recoverable VAT taxes.

Check the Balance of India Service Tax Credit Register Report

1. Create a Standalone Payable Invoice
2. Attach the Service Tax Category
3. Validate, Approve, Account the Invoice
4. Pay and Account the Payment
5. Run the India Service Tax processing Concurrent.
6. Check the India Service Tax Credit Register Report