More emmanue
Home FUSION AP AR GL INV PO OM HR PA FAQS PL-SQL TECH SCRIPTS OA
Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.
If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@[Link] or message me at @apps
or +91 905 957 4321 in telegram.
SATURDAY, DECEMBER 21, 2013
Oracle Receivable Interview Questions
--> Name some Flexfields in AR.
Sales Tax Location, Territory
--> Explain the steps involved in Transfer to GL from AR.
Transfer the transactions to GL_Interface Import the Journals Post the Journals
--> What is the dbnumber of a particular cusotmer TCA?
It is a unique number used to identify the Customers.
--> Where can you find the Customer payment terms?
In the table hz_customer_profiles
--> What is the link between OM and AR?
To relate the Order Number (ONT) to the Invoice (AR) we use the LINE TRANSACTION FLEX FIELDS. In RA_CUSTOMER_TRX_ALL,
INTERFACE_HEADER_ATTRIBUTE1 to INTERFACE_HEADER_ATTRIBUTE15 store this Information that uniquely identifies the Sales Order (HEADER
INFO). In RA_CUSTOMER_TRX_LINES_ALL, INTERFACE_LINE_ATTRIBUTE1 to INTERFACE_LINE_ATTRIBUTE15 store this Information that uniquely
identifies the Sales Order.(LINE INFO)
--> What kind of transactions can be created using AutoInvoice?
Invoices, credit memos, debit memos, and on¿account credits can be imported using AutoInvoice.
--> What are the different Transaction types in AR?
Invoice, Credit Memo, Debit Memo,Charge back, commitments
Explain the different steps in implementing Autolockbox.
Import, Validate, Post Quick Cash
--> What are the different Invoice matching types?
2-way matching: 2-way matching verifies that Purchase order and invoice quantities must match within your tolerances 3-way matching
3-way matching verifies that the receipt and invoice information match with the quantity tolerances 4-way matching: 4-way matching
verifies that acceptance documents and invoice information match within the quantity tolerances
--> What are the underlying tables and validations required during AutoInvoice Interface?
Interface tables: RA_INTERFACE_LINES_ALL Base tables: RA_CUSTOMER_TRX_ALL RA_BATCHES RA_CUSTOMER_TRX_LINES_ALL
AR_PAYMENT_SCHEDULES_ALL RA_CUSTOMER_TRX_LINE_SALESREPS RA_CUST_TRX_GL_DIST_ALL AR_RECEIVABLES_APPLICATIONS AR_ADJUSTMENTS
RA_CUSTOMER_TRX_TYPES_ALL Concurrent Program: Auto invoice master program Validations: check for amount, batch source name,
conversion rate, conversion type. Validate orig_system_bill_customer_id, orig_system_bill_address_id, quantity. Validate if the
amount includes tax flag.
--> Tell me about TCA?
TCA canbe used to import or modify Customers related data.
Best Blogger Gadgets
Posted by Raju Chinthapatla at [Link] PM
Labels: AR, FAQS
No comments:
Post a Comment
Enter Comment
Newer Post Home Older P
Subscribe to: Post Comments (Atom)
If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@[Link] or message me at @apps88 or +91 905 957 4321 in telegr
S/W (3)
SANDBOX (1)
SCM (5)
SCRIPTS (596)
SEPA (1)
SETUPS (31)
SHELL (2)
SLA (15)
SOURCING (1)
SQL (169)
SQL SERVER (1)
SQL*LOADER (9)
SQLDEVELOPER (3)
SR (7)
SSHR (1)
SUPPLIERS (51)
TABLES (105)
TAX (16)
TCA (19)
TRAINING (3)
UNIX (26)
UPGRADE (9)
UTL_FILE (1)
VALUE SETS (15)
VIEWS (3)
WIP (9)
WORK FLOWS (31)
XLA (7)
XMLP (94)
XSL (1)
XXOA (2)
XYZ (30)
BLOG ARCHIVE
December 2013 (20)
If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@[Link] or message me at @apps88 in telegram.
Email : OracleApps88@[Link]. Picture Window theme. Theme images by konradlew. Powered by Blogger.
Get Flower Effect