Download sample Oracle Apps Technical CV

As I could not provide the sample oracle apps cv in my previous post which actually speaks about the rough structure of it and may not help you to build a perfect CV.

Now, I have prepare a sample CV which you can download here. Just Click Here
And, I have given the hints in the attached CV what content you need to add in your resume.

Also, keep in mind that the project description can be some thing about the client and thier present requirement. Also provide the important tasks you have been performing in the project. This will help the recruiter to find what exactly they are looking for. Suppose if a company looking for a interface developer, they search for the profiles who has extensive experience in interfaces. It matters what type of interfaces and on which modules you worked on and any integration interfaces you developed / customized among the modules/different applications.

Enabling Decompiler in Jdeveloper

During OA framework extensions or understanding the java code we need to decompile the java class. That we can achieve using any decompiler which are available. One of them is Jad.exe which is very popular.

But when you have opened your J developer and you want to see the code in the Jdev, you need to follow the below steps to achive that.

1. Locate your jdev.conf file. This will be always under your jdev main folder/jdevbin/bin.

2. Open in notepad and add the below line at the end

AddVMOption -Djcncmd= -& -p -b -ff -nl -pi99999 -space -t2 -noinner

can be some thing like c:/Java/jad.exe

3. Save and open J developer

How to use the decompile in Jdev?
Open Jdeveloper
Select Navigate from menu, select "go to java class" and select the class you would like to open as .java

Jdeveloper settings - such as copying class files, xml files

When you are working on any OA framework page development.

Copy all the classes (.class) files from web tier into myclasses/oracle/apps/...

Copy the xml files in myprojects/oracle/apps/

Also copy the xml files(region, page etc) from $_TOP/mds/ ex: $AP_TOP/mds to myprojects/oracle/apps

Now, if you perform rebuild or make on your custom project, you do not get any errors (some times if due to ambiguity in usage of class files, when you compile/run custom/standard page you may end up with errors. To avoid this, all the classes should be moved to myclasses as if all the objects are compiled and moved to respective tops.

Since all the region xml files are moved to myprojects you can run the page/region.

Unable to view Oracle apps tables in Ms Access

Problem: When a table is build based on Oracle apps views such as fnd views , multiorg tables, language specific environment variable restrict this views to be able to open in Microsoft access.

When a table is built on it and try to open, we can only see the table headers not the data.

Resolution:
Right clik on My computer
Click Properties
Select Advanced tab
Select environment variables
select New button under User Variables
provide variable name: NLS_LANG
variable value: AMERICAN_AMERICA.WE8MSWIN1252


This inablility is caused by userenv('LANG') condition on the views for the tables _TL.

Accounts Receivables FAQs

1 Name some of the Oracle receivables Interfaces?
A a) Auto Invoice
b) Auto Lockbox
c) Customer Interface
d) Sales Tax rate Interface
e) Tax Vendor Extension

2. Name the interface tables used for the customer interface?
A. 1 RA_CUSTOMER_INTERFACE
2. RA_CUSTOMER_BANK_INTERFACE
3. RA_CUST_PAY_METHOD_INTERFACE
4. RA_CUSTOMER_PROFILES_INTERFACE
5. RA_CONTACT_CUSTOMER_INTERFACE

3 What is the name of the column in CUSTOMER_INTERFACE_TABLE that indicates whether you are
inserting new or updating existing information?
A When importing data into the interface tables, the column INSERT_UPDATE_FLAG indicates whether you
are inserting new or updating existing information.
This column is required in RA_CUSTOMERS_INTERFACE.

4 If the INSERT_UPDATE_FLAG is not set correctly or the required column is missing the value, will
CUSTOMER INTERFACE reject the entire record or just the attributes u want to update?
A Reject the entire record.

5 List some of the required columns for the RA_CUSTOMERS_INTERFACE?
A. ORIG_SYSTEM_CUSTOMER_REF
INSERT_UPDATE_FLAG
CUSTOMER_NAME
CUSTOMER_NUMBER (if you are not using Automatic Customer Numbering)
CUSTOMER_STATUS
LAST_UPDATED_BY
LAST_UPDATE_DATE
CREATED_BY
CREATION_DATE

If you are importing an address and a business purpose, you must also populate the following columns:
PRIMARY_SITE_USE_FLAG (if you are inserting an address)
LOCATION (if you are not using Automatic Site Numbering)
SITE_USE_CODE (if you are inserting an address)
ADDRESS1

6 List some of the production tables that Customer Interface transfers customer data from the
interface tables into?
A. AR_CUSTOMER_PROFILES
AR_CUSTOMER_PROFILE_AMOUNTS
RA_ADDRESSES
RA_CONTACTS
RA_CUSTOMERS
RA_CUSTOMER_RELATIONSHIPS
RA_CUST_RECEIPT_METHODS
RA_PHONES
RA_SITE_USES
AP_BANK_ACCOUNT_USES
AP_BANK_ACCOUNTS
AP_BANK_BRANCHES

7 What validation must be given on the customer_number?
A Must be null if you are using Automatic Customer Numbering. Must exist if you are not using Automatic Customer Numbering. This value must be unique within RA_CUSTOMERS.

8 What validation must be given on the CUSTOMER_STATUS?
A Must equal ’A’ for Active or ’I’ for Inactive.

9 What is the use of Auto lock Box?
A Auto Lockbox (or Lockbox) is a service that commercial banks offer corporate customers to enable
them to outsource their accounts receivable payment processing.

10 Auto Lockbox is a three-step process, what are those?
A. a) Import
b) Validation
c) PostQuickCash

11 What is the order in which Autolock box searches for the types of the matching number?
A. 1. Transaction Number
2. Sales Order Number
3. Purchase Order Number
4. Consolidated Billing Invoice Number
5. Other, user-defined number.

12 Name the interface tables used for the LockBox Interface
A Interface table :
AR_PAYMENTS_INTERFACE_ALL
Lockbox transfers the receipts that pass validation to the Receivables interim tables AR_INTERIM_CASH_RECEIPTS_ALL and AR_INTERIM_CASH_RCPT_LINES_ALL
When you run Post QuickCash, the receipt data is transferred from the QuickCash tables to the following Receipt tables:
AR_CASH_RECEIPTS_ALL
AR_RECEIVABLES_APPLICATIONS_ALL
AR_CASH_RECEIPT_HISTORY_ALL

13 Name the interface tables used for the AutoInvoice Interface.
A AutoInvoice transfers transaction data from the interface tables
RA_INTERFACE_LINES_ALL,
RA_INTERFACE_SALESCREDITS_ALL, and
RA_INTERFACE_DISTRIBUTIONS_ALL
into the following Receivables tables:
RA_BATCHES_ALL
RA_CUSTOMER_TRX _ALL
RA_CUSTOMER_TRX_LINES _ALL
RA_CUST_TRX_LINE_GL_DIST_ALL
RA_CUST_TRX_LINE_SALESREPS_ALL
AR_PAYMENT_SCHEDULES_ALL
AR_RECEIVABLE_APPLICATIONS_ALL
AR_ADJUSTMENTS_ALL


Q Give some of the Oracle Payables interface?
A. a) Credit Card Transaction Interface
b) Invoice Import Interface
c) Payables Open Interface
d) Purchase Order Matching

Q Name some of the oracle general ledger Interface?
A a) Budget Upload
b) Importing Journals
c) Loading Daily rates

Upload binary files (JPG, GIF, DOC, XLS, PDF) into Oracle database

Steps to upload GIF, XLS, PDF, JPG and DOC files into oracle database

Step 1
======
Create or replace directory my_files as '/usr/temp';
Create table demo(sno number, filedata blob);
Copy any file (jpg,gif,pdf,xls....) into /usr/temp

Execute the below code. Change the file name according to your requirement


Step 2
======

declare
l_blob blob;
l_bfile bfile;
begin
insert into demo values ( 3, empty_blob() )
returning filedata into l_blob;
l_bfile := bfilename( 'MY_FILES', 'water.jpg' );
dbms_lob.fileopen( l_bfile );
dbms_lob.loadfromfile( l_blob, l_bfile, dbms_lob.getlength( l_bfile ) );
dbms_lob.fileclose( l_bfile );
commit;
end;

Step 3
======
Check the file length to ensure whether file loaded successfully or not

Select sno,dbms_lob.getlength(filedata) from demo

Reference: http://www.sql.ru/forum/actualthread.aspx?tid=202867