Q: Give the structure of the trigger? |
A: Triggers are simply stored procedures that are ran automatically by the database whenever some event happens. The general structure of triggers is: CREATE [OR REPLACE] TRIGGER trigger_name BEFORE (or AFTER) INSERT OR UPDATE [OF COLUMNS] OR DELETE ON tablename [FOR EACH ROW [WHEN (condition)]] BEGIN ... END; |
Q: What is an autonomous transaction ? |
A: An autonomous transaction is an independent transaction that is initiated by another transaction (the parent transaction). An autonomous transaction can modify data and commit or rollback independent of the state of the parent transaction. |
Q: What are the different cursors available in PL/SQL ? |
A: Explicit Cursors, Implicit Cursors, Ref Cursors |
Q: How do you submit a concurrent program from PL/SQL Procedure? |
A: FND_REQUEST.SUBMIT_REQUEST() |
Q: What is the difference between View and Materialized view? |
A: Materialized view will not be refreshed everytime you query the view so to have good performance when data is not changed so rapidly we use Materialized views rather than normal views which always fetches data from tables everytime you run a query on it. |
Q: What is RAISE_APPLICATION_ERROR used for? |
A: The RAISE_APPLICATION_ERROR is a procedure defined by Oracle that allows to raise an exception and associate an error number and message with the procedure. |
Q: What are the three files that are generated when you load data using SQL Loader? |
A: .log .bad .discard |
Q: What is dynamic SQL? |
A: Dynamic SQL allows you to construct a query, a DELETE statement, a CREATE TABLE statement, or even a PL/SQL block as a string and then execute it at runtime. |
Q: What are the types of Exceptions? |
A: System defined and user defined Exceptions |
Q: What are the differences between Function and Procedure? |
A: Function has to return a value where procedure may or maynot return values. Function can be used in SQL statements and procedures can not. |
Q: What is the difference between TRUNCATE and DELETE? |
A: TRUNCATE will completely erase the data where as in DELETE you have the option to delete only few rows. TRUNCATE is DDL command where as DELETE is DML command |
Q: How do you set the profile option from a PL/SQL procedure? |
A: No answer yet! |
Q: Name the different database triggers? |
A: No answer yet! |
Q: What is the SQL statement used to display the text of a procedure stored in database? |
A: select text from dba_source where name = 'Procedurename' |
Q: How do you retrieve the last N records from a table? |
A: No answer yet! |
Q: Can you use COMMIT in a trigger? |
A: Yes but by defining an autonomous transaction. |
Q: What is Ref Cursor? |
A: A ref cursor is a variable, defined as a cursor type, which will point to a cursor result. The advantage that a ref cursor has over a plain cursor is that is can be passed as a variable to a procedure or a function. Ref Cursors are of 2 types: Weak and Strong. In the case of Strong type, the data type of the returned cursor result is defined whereas in Weak type, it is not defined. Eg:type erp_cursor is ref cursor; -- weak type erp_cursor is ref cursor returning erp%rowtype; --strong declare 2 type erp_cursor is ref cursor; 3 c1 erp_cursor; 4 r_c1 articles%rowtype; 5 r2_c1 scripts%rowtype; 6 7 begin 8 open c1 for select * from articles; 9 fetch c1 into r_c1; 10 close c1; 11 open c1 for select * from scripts; 12 fetch c1 into r2_c1; 13 close c1; 14 end; |
Q: Can triggers be used on views? If so How? |
A: Yes only INSTEAD OF trigger can be used to modify a view. CREATE OR REPLACE TRIGGER trigger_name INSTEAD OF INSERT ON view name begin ... end; |
Q: Can you call a sequence in SQL Loader? |
A: Yes |
Q: How do you declare user defined Exception? |
A: Declare ... Excep_name exception; procedure Excep_name is begin raise some_exc; end Excep_name; Begin .... end; |
Q: How do you eliminate duplicate rows from a table? |
A: No answer yet! |
Q: What is a mutating table? |
A: No answer yet! |
Q: "UPDATE …..; CREATE TABLE E(….); ROLL BACK;" To which save point will the changes be Rolled Back? |
A: Updates done wouldn't be Rolled Back as CREATE statement which is a DDL would issue a COMMIT after the creation of the table. |
Q: What is tkprof and the syntax? |
A: When Trace option is Enabled, the .trc file is created in Udump folder which is not in readable format. Tkprof utility is used to convert this .trc file into a readable format. syntax: tkprof trcfilename outputfilename |
Q: How do you set profile options from PL/SQL procedure? |
A: By calling the standard fnd_profile procedure. |
Q: Have you ever used TABLE datatype and what is it used for? |
A: TABLES are like Arrays, used for temporary storage. The declaration of TABLE involves 2 steps: Declare the table structure using TYPE statement and then declare the actual table. |
Q: What do you know about Trace and Tuning? |
A: No answer yet! |
Q: What is conditional filtering at database level? (Hint: New feature released in 10g) |
A: No answer yet! |
Q: How do you set the profile option in PL/SQL Procedure? |
A: No answer yet! |
Q: how to find out duplicate records from the table? |
A: No answer yet! |
Q: Can two users update the same row at the same time? if so how? |
A: No answer yet! |
Q: what is External table? |
A: External tables can be used to load flat files into the database. Steps: First create a directory say ext_dir and place the flat file (file.csv) in it and grant read/write access to it. Then create the table as below: create table erp_ext_table ( i Number, n Varchar2(20), m Varchar2(20) ) organization external ( type oracle_loader default directory ext_dir access parameters ( records delimited by newline fields terminated by , missing field values are null ) location (file.csv) ) reject limit unlimited; |
Q: What is global temporary table? |
A: Global temporary tables are session specific, meaning the users in other sessions cannot see or manipulate the data in the temporary table you have created. Only you can access or insert or delete or perform anything with the data in the temporary table in your session and the other users cannot use or access this. Once you end your session, the data in the temporary table will be purged. |
Q: How do you retrieve the last N records from a table? |
A: The RANK() and DENSE_RANK() functions can be used to determine the LAST N or BOTTOM N rows. |
Q: What is difference between TRUNCATE & DELETE |
A: TRUNCATE commits after deleting entire table i.e., cannot be rolled back. Database triggers do not fire on TRUNCATE |
Q: What is ROWID? |
A: ROWID is a pseudo column attached to each row of a table. It is 18 characters long, blockno, rownumber are the components of ROWID |
Q: What are the advantages of VIEW? |
A: To protect some of the columns of a table from other users. - To hide complexity of a query. - To hide complexity of calculations. |
Q: What are SQLCODE and SQLERRM and why are they important for PL/SQL developers? |
A: SQLCODE returns the value of the error number for the last error encountered. The SQLERRM returns the actual error message for the last error encountered. They can be used in exception handling to report, or, store in an error log table, the error that occurred in the code. These are especially useful for the WHEN OTHERS exception. |
Q: What is tkprof and how is it used? |
A: The tkprof tool is a tuning tool used to determine cpu and execution times for SQL statements. You use it by first setting timed_statistics to true in the initialization file and then turning on tracing for either the entire database via the sql_trace parameter or for the session using the ALTER SESSION command. Once the trace file is generated you run the tkprof tool against the trace file and then look at the output from the tkprof tool. This can also be used to generate explain plan output. |
Q: What is Blanket PO? |
A: A Blanket PO is created when you know the detail of the goods or services you plan to buy from a specific supplier in a period, but you do not know the detail of your delivery schedules. |
Q: What are different types of PO’s ? |
A: Standard, Blanket, Contract, Planned |
Q: How does workflow determines whom to send the PO for approval? |
A: It Depends on the setup whether it is position based or supervisor based. |
Q: Can you create PO in iProcurement ? |
A: No |
Q: Give me some PO tables |
A: PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL,PO_DISTRIBUTIONS_ALL |
Q: Tell me about PO cycle? |
A: Create PO Submit it for Approval Receive Goods against the PO (when order is delivered by the vendor) Close the PO after the invoice is created in AP and teh payments have been made to the vendor. |
Q: Explain Approval Heirarchies in PO. |
A: Approval hierarchies let you automatically route documents for approval. There are two kinds of approval hierarchies in Purchasing: position hierarchy and employee/supervisor relationships. If an employee/supervisor relationship is used, the approval routing structures are defined as you enter employees using the Enter Person window. In this case, positions are not required to be setup. If you choose to use position hierarchies, you must set up positions. Even though the position hierarchies require more initial effort to set up, they are easy to maintain and allow you to define approval routing structures that remain stable regardless of how frequently individual employees leave your organization or relocate within it. |
Q: What functions you do from iProcurement? |
A: Create Requisition, Receive the goods. |
Q: What is difference between positional hierarchy and supervisor hierarchy? |
A: If an employee/supervisor relationship is used, the approval routing structures are defined as you enter employees using the Enter Person window. In this case, positions are not required to be setup. If you choose to use position hierarchies, you must set up positions. Even though the position hierarchies require more initial effort to set up, they are easy to maintain and allow you to define approval routing structures that remain stable regardless of how frequently individual employees leave your organization or relocate within it. |
Q: What is the difference between purchasing module and iProcurement module? |
A: Iprocurement is a self service application with a web shopping interface. WE can only create and manage requisitions and receipts. Purchasing module is form based and also lets you create PO and many other functions are possible other than requisitions and receiving. |
Q: What is dollar limit and how can you change it? |
A: An approval group is defined which is nothing but a set of authorization rules comprised of include/exclude and amount limit criteria for the following Object Types: Document Total, Account Range, Item Range, Item Category Range, and Location that are required to approve a PO. You can always change the rules by doing the below: Navigation: Purchasing Responsibility > Setup > Approvals > Approval Groups Query the Approval group and change teh rules accordingly. |
Q: What is Planned PO? |
A: A Planned PO is a long–term agreement committing to buy items or services from a single source. You must specify tentative delivery schedules and all details for goods or services that you want to buy, including charge account, quantities, and estimated cost. |
Q: What is Purchase order workflow ? |
A: No answer yet! |
Q: what are the tables link between PO & Gl technically? |
A: No answer yet! |
Q: What is backdated Receipt? |
A: Creating a Receipt with "Receipt Date" less than sysdate or today's date is referred to as 'Backdated Receipt". |
Q: Is it possible to create a backdated receipt with a receipt date falling in closed GL period? |
A: No. The receipt date has to be with in open GL period. |
Q: What is Receipt Date Tolerance? |
A: The buffer time during which receipts can be created with out warning/error prior or later to receipt due date. |
Q: How do we set the Receipt Tolerance? |
A: Receipt Tolerance can be set in three different places. 1. Master Item Form (Item Level) 2. setup, organization form (Organization Level) 3. Purchase Order, Receiving controls. (shipment level). |
Q: After done contact purchase order . we can Create standard order for contract ., in that we mention Contract Po No. in Reff Doc column. In which table and what column that value is stored ? |
A: No answer yet! |
Q: What is common Id for Requisition and po ? |
A: No answer yet! |
Q: Can any on give me tha detailed tables & theire relationship....in detail.... |
A: No answer yet! |
Q: EXPLAIN ABOUT PO FLOW |
A: CREATE REQUISTION, RAISE RFQ(REQUEST FOR QUOTATION),QUOTATIONS,PURCHASE ORDER,RECIEPTS |
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
|
Q: what is the 4th c in r12 Set of books. |
A: No answer yet! |
Q: What are the 4 C's in Accounting? |
A: In Oracle 11i 3c's i.e Currency Calendar Char of Account In R12 4c's include sub-ledger account along the above |
Q: After done Credit invoice . we can create standard Invoice, how to find out whether that in standard invoice on perform credit invoice ? |
A: No answer yet! |
Q: Hi needhelp, Could you please provide the Project Billing, Project costing interview questions. Thanks Rajesh |
A: No answer yet! |
Q: We use 3 way match and the Auto JE posting. When we use this all the credits go into once account. I would like to know how can i have the credits into different accounts instead of one account. |
A: No answer yet! |
Q: What is delegation in iExpense? |
A: You can authorize an employee to enter expense reports for another employee. An employee who is assigned the responsibility to enter expense reports for another employee is an authorized delegate. |
Q: What is the process/steps for Vendor Conversion? |
A: Insert the Vendor info into the interface tables and perform the required validations: AP_SUPPLIERS_INT AP_SUPPLIER_SITES_INT AP_SUP_SITE_CONTACT_INT Run the below programs to load the data into the Base tables: Supplier Open Interface Import Supplier Sites Open Interface Import Supplier Site Contacts Open Interface Import |
Q: What is Debit Memo & Credit Memo in Payables? |
A: Credit Memo is a negative amount invoice you receive from a supplier representing a credit. Debit Memo is a negative amount invoice you send to notify a supplier of a credit you recorded for goods or services purchased. |
Q: Explain the set up used for Automatic or Manual Supplier Numbering. |
A: In the Financials Options window, you can set the Supplier Number entry option to either Autimoatic or Manual • Automatic: The system automatically assigns a unique sequential number to each supplier when you enter a new supplier. • Manual: You enter the supplier number when you enter a supplier |
Q: What is Contract PO? |
A: Contract PO is created when you agree with your suppliers on specific terms and conditions without indicating the goods and services that you will be purchasing. |
Q: What is a Payable Document? |
A: A medium you use to instruct your bank to disburse funds from your bank account to the bank account or site location of a supplier. |
Q: In which table we can find the vendor number? |
A: PO_VENDORS |
Q: Give the cycle from creating an invoice to transferring it to GL in AP. |
A: 1)Create Invoice 2)Validate Invoice 3)Create Accounting entries using Payables Accounting Process 4)Submit the Payables Transfer to General Ledger program to send invoice and payment accounting entries to the General Ledger interface. 4)Journal Import (GL) 5)Journal Post (GL) |
Q: What are the different types of Invoices in Payables? |
A: Standard, Credit Memo, Debit Memo, Expense Report,PrePayment, Mixed, PO Default |
Q: You have created a new SOB. How will you attach this SOB to AP? |
A: Go to Payables Manager for the appropriate Operating Unit. Navigation:Setup--->Set of Books--->choose. |
Q: How many key flexfields are there in Payables? |
A: No Key Flexfields in AP |
Q: What is the Distribution Type while entering the Invoice? |
A: Item, Tax, Miscellaneous,Freight, Withholding Tax |
Q: What are the Prepayment types? |
A: Temporary and Permanent |
Q: What is Aging Periods? |
A: Aging Periods window are the time periods for the Invoice Aging Report. The Invoice Aging Report provides information about invoice payments due during four periods you specify. |
Q: Whats the difference between the "Payables Open Interface Import" Program and the "Payables Invoice Import" program? |
A: Payables Open Interface -- for importing regular invoices Payables Invoice Import -- for importing expense reports. In 11i renamed as Expense Report Import. |
Q: What is prepayment & steps to apply it to an Invoice? |
A: Prepayment is a type pf invoice that you enter to make an advance payment to a supplier or employee. To Apply it to an Invoice ,in the Invoices window, query either the prepayment or the invoice to which you want to apply it. Choose the Actions button and select the Apply/Unapply Prepayment check box. Click OK. |
Q: Can you hold the partial payment if yes then how? |
A: Yes. 1.Go to the Invoice window. Go to the scheduled payments tab. 2.Click "Split" to split the scheduled payment into as many payments as you wish. 3.Check "Hold" against the Payment line you wish to hold. |
Q: How you will transfer payables to general ledger? |
A: Create Accounting. Transfer the transactions to GL_Interface Import the Journals Post the Journals |
Q: What program is used to transfer AP transactions to GL? |
A: Payables Transfer to General Ledger Program |
Q: What is use of AP Accounting Periods? |
A: In Payables accounting periods have to be defined to enter and account for transactions in these open periods. Payables does not allow transaction processing in a period that has never been opened. These periods are restricted to Payables only. The period statuses available in Payables are Never Opened, Future,Open, Closed, and Permanently Closed. |
Q: What are the different interface programs in AP? |
A: Payables Open Interface Import to load Invoices and other transactions. Supplier Open Interface Import to load Suppliers. Supplier Sites Open Interface Import to load Supplier sites. Supplier Site Contacts Open Interface Import to load Supplier Site contacts. |
Q: What is Invoice Tolerance? |
A: We can define the matching and tax tolerances i.e how much to allow for variances between invoice, purchase order, receipt, and tax information during matching. You can define both percentage–based and amount–based tolerances. |
Q: What will accrue in Payables? |
A: Expenses and Liabilities |
Q: What is a Hold? Explain the types of Hold. |
A: Payables lets you apply holds manually on an invoice, Payments etc to prevent the payment from being made or to prevent the accounting entries to be created etc. Some of the Payable holds are -- Invoice Hold, Accounts Hold, Funds Hold, Matching Hold, Variance Hold, Misc hold. |
Q: Which module is the owner of Vendor/Supplier tables? |
A: Purchasing |
Q: What is Payment Terms? |
A: Payment Terms let you define the due date or the discount date , due amount or discount amount. Once the payment terms are defined, you can attach these to the suppliers and supplier sites and these terms will be automatically populated once the invoice is entered for a supplier site. |
Q: can we make a half payment in payables? then how? |
A: No answer yet! |
Q: can we create invoice without PO in payables? then how? |
A: No answer yet! |
Q: In AP the suppliers didn’t visible in India Creditors Ledger Report Parameter? |
A: pls check whether that particular supplier is available in Suppliers addition inforamtion or not. |
Q: What kind of transactions can be created using AutoInvoice? |
A: Invoices, credit memos, debit memos, and on–account credits can be imported using AutoInvoice. |
Q: What are the underlying tables and validations required during AutoInvoice Interface? |
A: 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. |
Q: Explain the different steps in implementing Autolockbox. |
A: Import, Validate, Post Quick Cash |
Q: What are the different Invoice matching types? |
A: 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 |
Q: What are the different Transaction types in AR? |
A: Invoice, Credit Memo, Debit Memo,Charge back, commitments |
Q: Tell me about TCA? |
A: TCA canbe used to import or modify Customers related data. |
Q: Name some Flexfields in AR. |
A: Sales Tax Location, Territory |
Q: Explain the steps involved in Transfer to GL from AR. |
A: Transfer the transactions to GL_Interface Import the Journals Post the Journals |
Q: What is the dbnumber of a particular cusotmer TCA? |
A: It is a unique number used to identify the Customers. |
Q: Where can you find the Customer payment terms? |
A: In the table hz_customer_profiles |
Q: What is the link between OM and AR? |
A: 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) |
Q: how can we adjust the money in AR? |
A: No answer yet! |
Q: What is Blanket PO? |
A: A Blanket PO is created when you know the detail of the goods or services you plan to buy from a specific supplier in a period, but you do not know the detail of your delivery schedules. |
Q: What are different types of PO’s ? |
A: Standard, Blanket, Contract, Planned |
Q: How does workflow determines whom to send the PO for approval? |
A: It Depends on the setup whether it is position based or supervisor based. |
Q: Can you create PO in iProcurement ? |
A: No |
Q: Give me some PO tables |
A: PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL,PO_DISTRIBUTIONS_ALL |
Q: Tell me about PO cycle? |
A: Create PO Submit it for Approval Receive Goods against the PO (when order is delivered by the vendor) Close the PO after the invoice is created in AP and teh payments have been made to the vendor. |
Q: Explain Approval Heirarchies in PO. |
A: Approval hierarchies let you automatically route documents for approval. There are two kinds of approval hierarchies in Purchasing: position hierarchy and employee/supervisor relationships. If an employee/supervisor relationship is used, the approval routing structures are defined as you enter employees using the Enter Person window. In this case, positions are not required to be setup. If you choose to use position hierarchies, you must set up positions. Even though the position hierarchies require more initial effort to set up, they are easy to maintain and allow you to define approval routing structures that remain stable regardless of how frequently individual employees leave your organization or relocate within it. |
Q: What functions you do from iProcurement? |
A: Create Requisition, Receive the goods. |
Q: What is difference between positional hierarchy and supervisor hierarchy? |
A: If an employee/supervisor relationship is used, the approval routing structures are defined as you enter employees using the Enter Person window. In this case, positions are not required to be setup. If you choose to use position hierarchies, you must set up positions. Even though the position hierarchies require more initial effort to set up, they are easy to maintain and allow you to define approval routing structures that remain stable regardless of how frequently individual employees leave your organization or relocate within it. |
Q: What is the difference between purchasing module and iProcurement module? |
A: Iprocurement is a self service application with a web shopping interface. WE can only create and manage requisitions and receipts. Purchasing module is form based and also lets you create PO and many other functions are possible other than requisitions and receiving. |
Q: What is dollar limit and how can you change it? |
A: An approval group is defined which is nothing but a set of authorization rules comprised of include/exclude and amount limit criteria for the following Object Types: Document Total, Account Range, Item Range, Item Category Range, and Location that are required to approve a PO. You can always change the rules by doing the below: Navigation: Purchasing Responsibility > Setup > Approvals > Approval Groups Query the Approval group and change teh rules accordingly. |
Q: What is Planned PO? |
A: A Planned PO is a long–term agreement committing to buy items or services from a single source. You must specify tentative delivery schedules and all details for goods or services that you want to buy, including charge account, quantities, and estimated cost. |
Q: What is Purchase order workflow ? |
A: No answer yet! |
Q: what are the tables link between PO & Gl technically? |
A: No answer yet! |
Q: What is backdated Receipt? |
A: Creating a Receipt with "Receipt Date" less than sysdate or today's date is referred to as 'Backdated Receipt". |
Q: Is it possible to create a backdated receipt with a receipt date falling in closed GL period? |
A: No. The receipt date has to be with in open GL period. |
Q: What is Receipt Date Tolerance? |
A: The buffer time during which receipts can be created with out warning/error prior or later to receipt due date. |
Q: How do we set the Receipt Tolerance? |
A: Receipt Tolerance can be set in three different places. 1. Master Item Form (Item Level) 2. setup, organization form (Organization Level) 3. Purchase Order, Receiving controls. (shipment level). |
Q: After done contact purchase order . we can Create standard order for contract ., in that we mention Contract Po No. in Reff Doc column. In which table and what column that value is stored ? |
A: No answer yet! |
Q: What is common Id for Requisition and po ? |
A: No answer yet! |
Q: Can any on give me tha detailed tables & theire relationship....in detail.... |
A: No answer yet! |
Q: EXPLAIN ABOUT PO FLOW |
A: CREATE REQUISTION, RAISE RFQ(REQUEST FOR QUOTATION),QUOTATIONS,PURCHASE ORDER,RECIEPTS |
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
|
No comments:
Post a Comment