1. Which modules you trained
in oracle apps?
A: Financial modules : AP,AR,GL
SCM Modules : PO,OM,INV
2.Which reports you've done?
i. Stack Summary Report
ii.Return to Vendor Reprot
iii.Goods Receipt Note (GRN)
iv.Approved Requisition Report
v.Back Order Report
vi.GL Report
vii.Sales OrderReport.
viii.Vendorwise PO Approved Report
ix.AR Receipt Information Report.
3.Which Interfaces have you done?
AP Interface
PO Interface
GL Interface
4.What is Interface?
Interface is the process of transferring
data from one system to another system.
5.what is the use of Inbound Interface?
It is used to transfer the data
from legacy system to oracle applications.
6.Explain about AP Interface?
Client give us data file
Then we have design 2 temporary staging tables one for invoices and
another one for invoices lines.
Then we dump the data from data/f
lat file to staging tables through SQL *loader.
Then we will create one Package
with 2 procedures, In that we create 2 cursors one for invoices and another one
for invoices lines.
Take 2 variables and validate
mandatory columns and send data into variables.
Then insert the data into Interface tables.
Run Standard Concurrent Program
"Payables Open Interface Import " through SRS window.
Then finally we will see data in
base tables.
7.What are mandatory columns in AP Interface?
Invoice Header level.
Operating Unit, Vendor, Invoice
Number, Vendor Site, Invoice type, Invoice amount, Invoice Date, Invoice Source
Invoice Line Level.
Invoice line Type, Account, Line
Number, Line Amount.
8.Which tables did you used in AP Interface?
Interface Tables :
AP_INVOICES_INTERFACE
AP_INVOICE_LINES_INTERFACE
AP_INTERFACE_REJECTIONS
Base Tables :
AP_INVOICES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL
9.Difference between Conversion and Interface?
Interface Conversion
|
To transfer daily transactions from Legacy system
to Oracle Apps
|
To transfer old data from Legacy
system to oracle Apps or Lower Version to Higher version
(11i -->R12)
|
|
It is on demand process/scheduled process
|
It is one time process
|
|
It is applicable in After Implementation
|
It is applicable in Conversion Projects and Up gradation Projects.
|
|
We don't know data volume
|
We know the data volume
|
10.When will we use conversion?
11.How to display vendor details in GL Report and what is the link?
We will display vendor details in
GL Report by taking AP tables.
link is
PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID =
AP_INVOICE_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID
Then
AP_AE_LINES.GL_SL_LINK_ID=GL_JE_LINES.GL_SL_LINK_ID
12.What is Procedure?
is a named pl/sql block
to perform a specific task.
---- A procedure may have
DML statements.
---- It may or may not
return a value.
---- Procedure can return
more than one value.
13.What is Function? When will we use it?
is a named pl/sql block to perform a specific task, is mainly
used for calculation purpose.
---- A function is called as part of an exception.
---- Every function should return a value
If u want to do any calculations then we will use Function.
14.XML
Registration steps?
1.
Register
the E-business suite report as a Data Definition in the Template Manager.
Create
a Data definition in the Template Manager for E-business Suite reports that
We wish to customize using XML Publisher. When you create the Data Definition
Code
must match the E-Business Suite report short name.
2.
Design
our template
Our template files can be either in Rich Text Format (RTF) or Portable
Document.
RTF is a specification used by many word processing applications, such as
Microsoft word. We design the template using our desktop word processing
Application and save the file as an RTF file type (.rtf extension). Insert
basic
Markup tags to the document to prepare it for merging with the XML data. XML
Recognizes the formatting features that we apply and converts them to XSL-FO.
Use Adobe Acrobat to apply markup tags to your custom-designed or
Downloaded PDF template
3.
Register
out template in the Template Manager
When we create the Template Manager, we register and upload our RTF
Or PDF template files. The template must be assigned to the Data definition
Code of the
E-Business Suite report with which it will be merged.
4.
Add
desired translations of your RTF template
XML Publisher’s translation utility allows us to extract the translatable
strings
From your template into an XLIFF file. Translate the strings in this file and
re-
upload to the Template Manager to make translation available at runtime.
Run
Time: -
1. Set the concurrent program to
generate XML.
2. Run the concurrent program using
standard request submission to obtain the XML
Output.
3. Run the XML Publisher Concurrent
Request .
The
XML Publisher Concurrent Request will prompt us to enter the Request ID from
the previous step, and t select a template, template locale, and output type.
Available templates are those associated to the report Data Definition in the
Template Manager. XML Publisher merges our design template with the XML data to
generate your customized output.
15.PO
Process?
16.RDF Registration
steps?
17.What is Form
Personalization? Which pages you personalize?
18.Which
triggers you use in Form Personalization?
19.What is
exception? How many types?
20. Difference
between Predefined exceptions and User defined exceptions?
21.If we write
any exception after when others then what will be the error?
22.Can we create
Package Body without specification?
23.Can we
create Package Specification without Body?
24.Form
Customization steps? When will we give form name in Registration?
25.What is
Profile? How many levels?
26.Whar are
Site level Profiles?
27.Which
profile in GL?
28.Which
Profile added in R12?
29.What is
Sql*loader? Which command used in Sql*loader to load data?
30.What is
TCA? What are the changes made in TCA in R12?
31. What are PO
Tables?
31. What are Inventory
Tables?
33.What are
Sub ledger Accounting Tables?
No comments:
Post a Comment