Thursday, December 15, 2011

APPS FAQs

1.WHAT IS THE DIFFERENCE BETWEEM APPS SCHEMA AND OTHER SCHEMAS?

ANS: APPS SCHEMA DOESN'T CONTAIN DATABASE OBJECTS, IT CONTAINS ONLY SYNONYMS AND THESE SCHEMA WILL HAVE THE RIGHTS TO ACCESS OTHER SCHEMA DATABASE OBJECTS.


2.WHAT IS MEANT BY CUSTOM TOP? WHATS THE PUPOSE?

ANS: CUSTOM TOP WILL BE CREATED OR DEVELOPED BY CLIENT FOR CUSTOMER DEVELOPMENT AND CUSTOMIZATION.
IF WE DONT HAVE CUSTOM TOP, WE CAN ALSO USE THE PRODUCT TOP FOR DEVELOPMENT AND CUSTOMIZATION.
EVERY CLIENT WILL HAVE ATLEAST ONE CUSTOM TOP OR MULTIPLE CUSTOM TOPS...

3.WHAT THE SIGNIFICANCE OF US FOLDER?

ANS: THIS IS LANGUAGE SPECIFIC FOLDER. WHEN WE ARE USING MULTIPLE LANGUAGES FOR THE CLIENT, WE WILL USE THIS US FOLDER.BY DEFAULT AMERICAN LANGUAGE. US FOLDER IS AVAILABLE ONLY FOR FORMS AND REPORTS, BECAUSE BOTH ARE GUI(GRAPHICAL USER INTERFACE)'S.

4.WHAT ARE THE FOLDERS WE WILL FIND BELOW 11.5.0 FOLDER?

ANS: AVAILABLE FOLDERS
ADMIN,BIN,FORMS,REPORTS,LOG,OUT,SQL........




5.WHAT IS MEANT BY CONCURRENT PROGRAM?

ANS: THIS IS INSTANCE OF EXECUTION FILE ALONG WITH PARAMETERS AND INCOMPATABLE PROGRAMS..
WE CAN REGISTER 11 TYPES OF EXECUTABLE AS CONCURRENT PROGRAMS..
LIKE FORMS,REPORTS,PL/SQL STORED PROCEDURE,SQL *LODER,SQL *PLUS....


6.WHAT ARE THE STEPS WILL FOLLOW TO REGISTER REPORTS AS CONCURRENT PROGRAM?

ANS: 1)DEVELOP THE REPORT(.RDF) AS PER CLIENT REQUIREMENT BY USING REPORTS 6I BUILDER.
2)MOVE THE REPORT FROM LOCAL MACHINE INTO SERVER.
3)SELECT SYSTEM ADMINSTRATOR AND CREATE EXECUTABLE
4)CREATE CONCURRENT PROGRAM AND ATTACH
A)EXECUTABLE
B)PARAMETERS
C)INCOMPATIBILITIES
5)CREATE REQUEST GROUP AND ATTACH CONCURRENT PROGRAM
6)CREATE RESPONSIBILITY AND ATTACH REQUEST GROUP.
7)CREATE USER, ATTACH RESPONSIBILITY TO USER.
8)USER SELECT THE RESPONSIBILITY AND GOTO SRS WINDOW,SUBMIT THE REQUEST

7.WHAT IS MEANT BY REQUEST GROUP?

ANS: GROUPS OF CONCURRENT PROGRAMS..

8.WHAT IS USER EXIT?

ANS: THIS ONE OF BUILT-IN PROGRAM IN REPORT 6I, IT WILL BE USED TO TRANFER THE REPORT BUILDER CONTROL TO SOME OTHER 3RD GENERATION LANGUAGE GET SOME INFORMATION COMPLETE THE REMAING EXECUTION PROCESS.

9.TYPES OF USER EXITS?

ANS: TYPES OF USER EXISTS ARE
FND SRWINIT
FND SRWEXIT
FND FLEXSQL
FND FLEXIDVAL
FND FORMATCURRENCY

10.WHAT ARE MANDITORY STEPS WE HAVE TO FOLLOW WHILE REGISTERING THE REPORT?

ANS: 1)DEVELOP THE REPORT(.RDF) AS PER CLIENT REQUIREMENT BY USING REPORTS 6I BUILDER.
2)MOVE THE REPORT FROM LOCAL MACHINE INTO SERVER.
3)SELECT SYSTEM ADMINSTRATOR AND CREATE EXECUTABLE
4)CREATE CONCURRENT PROGRAM AND ATTACH
A)EXECUTABLE

5)CREATE REQUEST GROUP AND ATTACH CONCURRENT PROGRAM
6)USER SELECT THE RESPONSIBILITY AND GOTO SRS WINDOW,SUBMIT THE REQUEST

11.HOW TO PRINT REQUEST_ID IN THE OUTPUT?

ANS: P_CONC_REQUEST_ID CAPTURES CONCURRENT PROGRAM REQUEST ID WHEN EVER WE SUBMIT AT SRS WINDOW.

12.WHAT IS MEANT BY RESPONSIBILITY?

ANS: THIS IS GROUP OF FORMS,CONCURRENT PROGRAMS,USERS. THIS IS USED FOR POSITION REQUIREMENTS.


13.WHAT ARE THE THINGS ARE MANDITORY AT THE TIME CREATING RESPONSIBILITY?

ANS: MANDITORY FIELDS ARE RESPONSIBILITY NAME,APPLICATION,RESPONSIBILITY KEY, DATA GROUP,REQUEST GROUP,MENU

14.WHAT IS MEANT BY DATA GROUP?

ANS: GROUPS OF USERS.

15.CAN WE DELETE THE RESPONSIBILITY?

ANS: NO WE CANN'T DELETE..WE CAN DISABLE AND ENABLE THE RESPONSIBILITY USING EFFECTIVE DATES(FROM AND TO)


16.WHAT IS ERRBUF AND RETCODE?

ANS: ERRBUF:THIS IS ONE OF THE OUT PARAMETER WILL BE USED TO GET ERROR MESSEGES INTO LOG FILE
RETCODE: THIS PARAMETER RETURNS STATUS OF CONCURRENT PROGRAM
'0' FOR NORMAL
'1' FOR WARNING AND '2' FOR ERROR.

17.HOW TO WRITE THE MESSEGE INTO THE OUT PUT FILE FROM PL/SQL PROCEDURE?

ANS:FND_FILE.PUT_LINE()

18.WHAT IS CONTROL FILE? SYNTAX?

ANS: IT IS SQL LOADER PROGRAM,WE WILL DEVELOP AND EXECUTE AT THE TIME OF DEVELOPMENT, WE WILL SPECIFY DATA FILE PATH, DATABASE ABLE NAME AND COLUMN MAPPING, WHEN WE EXECUTE THE CONTROL FILE FOLLOWING 3 FILES WILL BE CREATED AUTOMATICALLY.
3 FILES ARE 1. BAD FILE
DISCARD FILE
LOG FILE
EXTENSION OF CONTROL FILE IS .CTL.
SYNTAX: LOAD DATA
INFILE 'DATA FILE PATH'
INSERT INTO TABLE
FIELDS TERMINATED BY ',' (COLUMN1,COLUMN2....)

19.WHAT IS THE DIFFERENCE BETWEEN BAD FILE AND DISCARD FILE?

ANS: BAD FILE IT CONTAINS RECORDS WHICH ARE REJECTED BY THE SQL LOADER, SQL LOADER WILL REJECT RECORDS IF THERE IS ANY DATA TYPE ISMATCH OR ANY BAD FORMAT. EXTENSION OF BAD FILE IS .BAD

DISCARD FILE CONTAINS THE RECORDS WHICH ARE REJECTED BY CONTROL FILES, CONTROL FILE WILL REJECT THE RECORD IF IT CONTAINS ANY CONDITIONS. EXTENSION OF DISCARD FILE IS .DIS .

20.HOW TO ISSUE COMMIT IN CONTROL FILE?

ANS: WE CANN'T ISSUE THE COMMIT INSIDE OF THE CONTROL FILE, INSTEAD OF THAT WE WILL USE AUTO COMMIT BY USING 'ROWS COMMAND'.
IF WE SPECIFY ROWS=10 FOR EVERY 10 RECORDS COMMIT WILL BE EXECUTED.

21.HOW TO INSERT DATA INTO MULTIPLE TABLES AT A TIME?

ANS: WE ARE CREATING THE TWO OR MORE TABLES.
BASED ON THE POSITIONS WE HAVE TO WRITE THE PROGRAM.

22.HOW TO PASS THE PARAMETERS TO THE CONTROL FILE?

ANS: BY USING THE '&' EX: &1,&2.....UPTO 100. WE CANN'T SKIP THE SEQUENCE, WE CANN'T USE ANOTHER USER DEFINED PARAMETERS. SOME PARAMER VALUES WE CAN USE IN THE MULTIPLE LOCATIONS


23.)WHAT IS THE VALUE SET? TYPES OF VALUE SETS?

ANS: LIST OF VALUES WITH VALIDATION WILL BE USED TO RESTRICT THE USER WITHOUT ENTERING INVALID VALUES.
THERE ARE 8 SET OF VALUES

NONE
INDEPENDENT
DEPENDENT
TABLE
TRANSLATED INDEPENDENT
TRANSLATED DEPENDENT
SPECIAL
PAIR

24.WHAT IS TOKEN?

ANS: CONCURRENT PROGRAM PARAMETERS MAPPING WITH REPORT BUILDER BIND VARIABLES


25.IS TOKEN IS REQUIRED FOR PROCEDURE PARAMETERS?

ANS: NOT REQUIRED. IT IS ONLY USED IN REPORT BUILDER BIND VARIABLES MAPPING. REPORT BUILDER BIND VARIABLE MAY OR MAYNOT BE IN SEQUENCE. WHERE AS IN PROCEDURE PARAMETERS WILL BE IN THE SEQUENCE ORDER, FIRST PARAMETER VALUE WILL BE PASSED TO THE FIRST VARIABLE...

28)CAN WE DEFINE PARAMETERS FOR LEXICAL PARAMETERS?

ANS:

29)WHAT ARE THE DEFAULT TYPES WE HAVE?

ANS: DEFAULT TYPES: CONSTANT,SQL STATEMENT,SEGMENT,CURRENT DATE, CURRENT TIME.

30)HOW TO MAKE THE PARAMETERS AS MANDITORY OR OPTIONAL?

ANS: WHEN WE ARE DEFINING THE PARAMETERS AT THE TIME WE HAVE TO CHECK THE CHECK BOX CALLED 'REQUIRED' FOR MANDITORY, OTHERWISE OPTIONAL.

31)HOW TO DISPLAY THE ONE COLUMN DATA TO THE USER AND PASSWORD OTHER COLUMN DATA INTERNALLY?

ANS:

32)HOW TO REGISTER PROGRAM FROM BACKEND?

ANS: FOR EXECUTABLE

BEGIN
FND_PROGRAM.EXECUTABLE('EXECUTABLE NAME','APPLICATION NAME','SHORT NAME','DESCRIPTION','EXECUTION METHOD','EXECUTION FILE NAME','','','US','');
COMMIT;
END;

33)HOW TO SUBMIT CONCURRENT PROGRAM FORM BACKEND?

ANS: DECLARE
L_REQUEST_ID NUMBER(8);
BEGIN
FND_GLOBAL.APPS_INITIALIZE(USER_ID,RESP_ID,RESP_APPL_ID);
L_REQUEST_ID:=FND_REQUEST.SUBMIT_REQUEST('APPLICATION NAME',
'CONCURRENT PROGRAM NAME'
'DESCRIPTION'
'STARTING TIME DEFAULT NULL',
'SUB REQUEST DEFAULT FALSE'
PARAMETER1,PARAMETER2......);
COMMIT;
IF L_REQUEST_ID!=0 THEN
FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'PROGRAM SUCCESSFULLY COMPLETED');
ELSE
FND_FILE.PUT_LINE(FND_FILE.LOG,'PROGRAM NOT SUCCESSFULLY COMPLETED');
END IF;
EXCEPTION
WHEN OTHERS THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR OCCURED AT THE TIME OF SUBMISSION');
END;

34)DO U NEED TO ISSUE THE COMMIT STATEMENT AFTER CALLING CONCURRENT PROGRAM?

ANS:

35)WHAT ARE THE TYPES OF PO'S WE HAVE?

ANS: 1.BLANKET PUCHASE AGREEMENT
2.CONTRACT PURCHASE AGREEMENT
3.PLANNED PURCHASE ORDER
4.STANDARD PURCHASE ORDER

36)WHAT ARE THE MATCH APPROVALS WE HAVE?

ANS: AT THE TIME OF CREATING PURCHASE ORDER WE WILL SPECIFY THE MATCH APPROVAL AT SHIPPMENT LEVEL IN THE MORE TAB.
THE MATCH APPORVALS ARE:
2-WAY---PO, INVOICE
3-WAY---PO, RECEIPT,INVOICE
4-WAY---PO, RECEIPT,INSPECTION,INVOICE


37)WHERE THE ITEM NAME WILL BE STORED?

ANS: CREATED ITEM CAN BE AVAILABLE IN THE TABLE 'MTL_SYSTEM_ITEMS_B'.. ITEM NAME WILL BE STORED IN 'SEGMENT1' COLUMN.

38)WHAT ARE THE LEVELS WE HAVE IN PURCHASE ORDERS FORM?

ANS: THERE ARE 4 LEVELS

HEADERS
LINES
SHIPPMENTS
DISTRIBUTIONS

39)WHAT ARE THE PO MAIN TABLES? LIKE REQUISITION,RFQ,PO,RECEIPT,SUPPLIER TABLES?

ANS: PO MAIN TABLES ARE

PO_HEADERS_ALL
PO_VENDORS
PO_VENDOR_SITES_ALL
PO_VENDOR_CONTACTS

REQUISITION,RFQ,PO THESE ROWS WILL APPEARED IN 'SELECT TYPE_LOOKUP_CODE FROM PO_HEADERS_ALL'
SUPPLIERS WILL BE AVAILABLE IN 'SELECT VENDOR_NAME FROM PO_VENDORS'
RECEIPT WILL BE AVILABLE IN 'SELECT RECEIPT_NUM FROM RCV_SHIPMENT_HEADERS'

40)WHAT IS AUTO CREATE?

ANS: THIS IS ONE OF THE PURCHASING APPLICATION FEATURE WILL BE USED TO CREATE RFQ DOCUMENTS AUTOMATICALLY BASED ON REQUISATION NUMBER.

41)WHAT ARE THINGS WE HAVE TO SPECIFY IN TERMS AND CONDITIONS?

ANS: TERMS & CONDITIONS ARE
PAYMENT,FREIGHT,CARRIER,FOB(FOOT ON BOARD),PAY ON

42)WHAT IS THE DIFFERENCE BETWEEN STANDARD AND BLANKET PO?

ANS: STANDARD PURCHASE ORDER TYPE WILL BE CREATED FOR THE MOST OF THE ITEMS.
IT INCLUDES TERMS&CONDITIONS, ITEMS,PRICE AND QUANTITY...

BLANKET AGREEMENT CONTAINS TERMS& CONDITIONS AND GOODS PRICE MAY OR MAYNOT BE AVAILABLE AT THE TIME OF RELEASING THE AGREEMENT WE WILL SPECIFY THE QUANTITY & PRICE OTHER DETAILS.

43)WHERE THE BLANKET PO DATA WILL BE STORED?

ANS: EG: SELECT *FROM PO_HEADERS_ALL WHERE SEGMENT1=501

SELECT *FROM PO_HEADERS_ALL WHERE PO_HEADER_ID=61

44)WHY WHILE CREATION OF EXECUTABLE,WE ARE GIVEN THE APPLICATION NAME AND ALSO AT THE TIME OF CREATING THE CONCURRENT PROGRAM, WE ARE GIVING APPLICATION NAME, WHAT IS THE DIFFERENCE BETWEEN THESE TWO?

ANS: AT THE TIME OF CREATING CONCURRENT PROGRAM, WE HAVE COPY THE EXECUTABLE FILE INTO THE APPLICATION TOP LIKE PO,INV. THATS WHY WE HAVE TO GIVE APPLICATION NAME IN EXECUTABLE,CONCURRENT PROGRAM CREATION.


45)HOW TO FIND THE RECEIPT NUMBER, WE GIVE PO NUMBER?

ANS: SELECT RECEIPT_NUM
FROM RCV_SHIPMENT_HEADERS
WHERE SHIPMENT_HEADER_ID
IN
(SELECT SHIPMENT_HEADER_ID
FROM RCV_SHIPMENT_LINES
WHERE PO_HEADER_ID
IN
(SELECT PO_HEADER_ID
FROM PO_HEADERS_ALL
WHERE SEGMENT1='3482'))

46)WHAT ARE THE RECEIPT TABLES AND AS WELL AS RECEIPT TYPES?

ANS: RECEIPT TABLES ARE

RCV_SHIPMENT_HEADERS
RCV_SHIPMENT_LINES
RCV_TRANSACTIONS




47)IN THE SAME TABLE RFQ,QUOTATIONS,PO DATA WILL BE STORED.THEN HOW TO IDENTIFY THE INFORMATION WETHER IT IS RFQ DATA OR QUOTAION DATA OR PO DATA?

ANS: WE HAVE TO FIND THE ABOVE DATA THROUGH 'TYPE_LOOKUP_CODE' COLUMN IN PO_HEADERS_ALL TABLE.


48)IS ITEM FIELD IS MANDITORY IN PO FORM?

ANS: MANDITARY...WITH OUT ITEM NAME WE WILL NOT SPECIFY THE CATEGORY...

49.WHERE SHIPTO BILL TO DATA WILL BE STORED?

ANS: HR_LOCATIONS

=======================================================

Topic: Purchasing

1.What are different documents that can be created by using ‘Auto create’ based on Requisition?
The 4 types of documents are created by using auto create based on requisition.
The following documents are
  1. Standard Purchase order
  2. Blanket release
  3. Planned Purchase order
  4. RFQ
2.What are different types of Requisitions? Explain each in brief.
Internal Requisitions
Unlike purchase requisitions, which are supplied from purchase orders, internal requisitions are supplied from internal sales orders. Internal requisitions are not picked up when you Auto Create RFQs or purchase orders, nor can they be assigned to a buyer in the Assign Requisitions window
Purchase Requisitions
Use the Requisitions window to create requisitions. You must choose the requisition type (internal or purchase). You can also provide a description, unlimited notes, and defaults for requisition lines. For each requisition line, you choose the item you want to order along with the quantity and delivery location. You can get sourced pricing from catalog quotations or open blanket purchase agreements. You can also choose a price from a list of historical purchase order prices. In the Distributions window, you can charge the item to the appropriate accounts, or you can let the Account Generator create the accounts for you. Once you complete the requisition, you send it through the approval process.
3.What are different types of RFQ’s? Explain each in Brief.
There are three types of RFQs that come with Purchasing by default:
• Catalog: Used for high–volume items or items for which your supplier sends you information regularly. A Catalog or RFQ also includes price breaks at different quantity levels.
• Standard: Used for items you’ll need only once or not very often, but not necessarily for a specific, fixed quantity, location, and date. For example, you could use a Catalog RFQ for office supplies, but use a Standard RFQ for a special type of pen you don’t order very often. A Standard RFQ also includes price breaks at different quantity levels.
• Bid: Used for a specific, fixed quantity, location, and date. For example, a Bid would be used for a large or expensive piece of equipment that you’ve never ordered before, or for an item that incurs transportation or other special costs. You cannot specify price breaks for a Bid RFQ.
4.What are different types of purchase orders? Explain each in brief.

Purchase Order Types

Purchasing provides the following purchase order types: Standard Purchase Order, Planned Purchase Order, Blanket Purchase Agreement, and Contract Purchase agreement. you can use the Document Name field in the Document Types window to change the names of these documents. For example, if you enter Regular Purchase Order in the Document Name field for the Standard Purchase Order type, your choices in the Type field in the Purchase Orders window will be Regular Purchase Order, Planned Purchase Order, Blanket Purchase Agreement, and Contract Purchase Agreement.
Standard Purchase Orders
You generally create standard purchase orders for one–time purchase of various items. You create standard purchase orders when you know the details of the goods or services you require, estimated costs, quantities, delivery schedules, and accounting distributions. If you use encumbrance accounting, the purchase order may be encumbered since the required information is known.
Blanket Purchase Agreements
You create blanket purchase agreements 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 yet know the detail of your delivery schedules. You can use blanket purchase agreements to specify negotiated prices for your items before actually purchasing them.
Blanket Releases
You can issue a blanket release against a blanket purchase agreement to place the actual order (as long as the release is within the blanket agreement affectivity dates). If you use encumbrance accounting, you can encumber each release.
Contract Purchase Agreements
You create contract purchase agreements with your suppliers to agree on specific terms and conditions without indicating the goods and services that you will be purchasing. You can later issue standard purchase orders referencing your contracts, and you can encumber these purchase orders if you use encumbrance accounting. 4 – 5 Purchase Orders
Planned Purchase Orders
A planned purchase order 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.
Scheduled Releases
You can issue scheduled releases against a planned purchase order to place the actual orders. If you use encumbrance accounting, you can use the planned purchase order to reserve funds for long term agreements. You can also change the accounting distributions on each release and the system will reverse the encumbrance for the planned purchase order and create a new encumbrance for the release.
5.What are five different Tax defaults in Purchasing options?
  1. Financial options
  2. Ship-to location
  3. Item
  4. Supplier site
  5. Supplier
6.What is the difference between Contract purchase Agreement and Planned purchase Agreement?
Contract Purchase Agreement:
You create contract purchase agreements with your suppliers to agree on specific terms and conditions without indicating the goods and services that you will be purchasing. You can later issue standard purchase orders referencing your contracts, and you can encumber these purchase orders if you use encumbrance accounting.
Planned Purchase Agreement:
A planned purchase order 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. You can later issue schedule release.
7.What do you mean by requisition Template? How to copy a requisition template to requisition?
A feature that lets you define a list of commonly purchased items from which a requestor can create a requisition. You can define the list of items by referencing an existing purchase order. Requestors use the requisition template to create simple, pre–sourced requisitions.
The requisition template are selected in requisition form click (B) catalog. In this form we are given requisition template number.
8.What is the difference between standard Purchase order and Blanket release?
Standard Purchase order:
You generally create standard purchase orders for one–time purchase of various items. You create standard purchase orders when you know the details of the goods or services you require, estimated costs, quantities, delivery schedules, and accounting distributions. If you use encumbrance accounting, the purchase order ay be encumbered since the required information is known.
Blanket release:
You can issue a blanket release against a blanket purchase agreement to place the actual order (as long as the release is within the blanket agreement affectivity dates). If you use encumbrance accounting, you
can encumber each release.
9.Explain the different match approval levels?
Two–Way: Purchase order and invoice quantities must match within tolerance before the corresponding invoice can be paid.
Three–Way: Purchase order, receipt, and invoice quantities must match within tolerance before the corresponding invoice can be paid.
Four–Way: Purchase order, receipt, inspection, and invoice quantities must match within tolerance before the corresponding invoice can be paid.
10.What do you mean by Receiving Controls?
11.What are different statuses of RFQ?
  1. Active
  2. Closed
  3. In process
12.What type of RFQ’ s can be auto-created based on Requisition?
  1. Standard
  2. Catalog
  3. Bid
13.What are different invoice match Options?
  1. Purchase order
  2. Receipt
14.List the different types of Quotations that can be auto-copied from RFQ?
This is depends on base document. If we are select the standard RFQ then it will create Standard (or) Catalog Quotations. Otherwise we are selected Bid RFQ it will create only Bid Quotation.
15.At what level below things are specific in Multi-Org structure:
  1. Category codes : Global
  2. Category sets : Inventory Org
  3. Approval Assignment : Inventory Org
  4. Location : Global
  5. Approved Supplier : Inventory Org
  6. Approval Group : Inventory Org
  7. Supplier Site : Operating Unit
  8. Bank : Global
  9. Master Item : Inventory Org
  10. Supplier List : Operating Unit
1.What are different types of invoices?

  1. Credit Memo. An negative amount invoice you receive from a supplier representing a credit for goods or services purchased.
  2. Debit Memo. A negative amount invoice you send to notify a supplier of a credit you recorded for goods or services purchased.
  3. Interest. An invoice that Payables automatically creates invoices to pay interest for overdue invoices if you enable automatic interest calculation for a supplier, and if you pay an overdue invoice for the supplier in a payment batch or with a Quick payment.
  4. Expense Report. An invoice you enter to record business–related employee expenses.
  5. Mixed. A Standard or Credit/Debit Memo invoice for which you can enter both positive and negative amounts and perform both positive and negative matching.
  6. PO Default. A trade invoice you want to automatically match to a specified purchase order and then manually match to the individual shipments on the purchase order. After you use this invoice type to complete the match, the invoice will become a Standard type invoice.
  7. Prepayment. An advance payment you make to a supplier or employee. If you enter Temporary for the Prepayment Type field, then you can later apply prepayment to an invoice.
  8. QuickMatch. A trade invoice you want to automatically match to all the shipments of a specified purchase order.
  9. Standard. A trade invoice you receive from a supplier.
  10. Withholding Tax. An invoice you have generated to pay a tax authority.
2.What is Pre-payment invoice? What are the different types of Pre-payment invoice? What is the accounting entry for Pre-payment at different stages?
Prepayment. An advance payment you make to a supplier or employee. If you enter Temporary for the Prepayment Type field, then you can later apply prepayment to an invoice.
Two types of prepayments are there, namely, Temporary and Permanent. In case of earlier one, it is treated as advance to the supplier and will be adjusted against any invoice on or after the settlement date but in case of later one, it is treated as deposit with the supplier.
4.Explain the concept of ‘Pay Group”. Brief the steps to define and assign ‘Pay Group’.
Pay Group you want to assign to any suppliers that you create from employees during Invoice Import. You can define additional values for Pay Group in the Purchasing Lookups window.
Purchasing Lookups
Note that in the Oracle Public Sector Purchasing Lookups window you can add values for the following lookups that Payables uses:
  1. FOB
  2. Freight Terms.
  3. Minority Group
  4. Pay Group. Groups invoices in payment batches.
  5. Supplier Type.
Define pay group ay lookups-purchasing. It can be assigned at payable option - supplier tab page, supplier screen - payment tab page and supplier site - payment tab page.
5.What is the difference between PO default and Quick Match Invoices?
If you know the number and amount of the purchase order to which you want to match, Payables provides you with two invoice types, PO Default and QuickMatch, to help speed up invoice matching.
Enter PO Default as the invoice type if you know the purchase order you want to match to, but you do not know to which purchase order shipments or distributions you want to match. When you enter a PO Default invoice in the Invoice Workbench, Payables prompts you to enter the purchase order number and automatically copies the supplier name, supplier number, supplier site, and currency from that Purchase order to the invoice. When you choose the Match button, Payables will retrieve all purchase order shipments or receipt lines associated with the specified purchase order. You can then match to any shipment, distribution, or receipt line.
Enter Quick Match as the invoice type if you want to match an invoice to all shipments or receipt lines on a purchase order. When you enter a Quick Match invoice in the Invoice Workbench, Payables prompts you to enter the purchase order number and automatically enters the supplier name, supplier number, supplier site, and the purchase order currency for the invoice currency. When you choose the Match button, Payables automatically navigates to the match window, and selects all shipments that have an unbilled quantity. You can choose to complete the match or override the matching information.
6.What do you mean by Mixed Invoice?
Mixed Invoices are invoices or credit/debit memos for which you can perform both positive and negative matching to purchase orders and to other invoices.
For example, you can enter an invoice for –$100 with Invoice Type Mixed. You can match to an invoice for $–200, and match to a purchase order for $100.
To enter a Mixed invoice:
1. Enter the invoice or credit/debit memo in the Invoices window, and enter Mixed as the invoice Type.You can enter either a positive or negative invoice amount.
2. Match to purchase orders, and/or invoices
7.What are the different payment methods?
Payment Method.
Ø Check. Payment in a payment batch, Quick payment, or manual payment.
Ø Electronic. You pay electronic payments either through the e–Commerce Gateway, or by delivering a payment batch file to your bank. For both methods, Payables creates a file during payment batch creation. For e–Commerce Gateway payments, the file is processed through the e–Commerce Gateway and delivered to your bank to create payments. For electronic funds transfers, the file is formatted and delivered to your ap.out directory for you to deliver to your bank.
Ø Wire. A payment method where you pay invoices outside of Payables by notifying your bank that you want to debit your account and credit your supplier’s account with appropriate funds. You provide your bank with your supplier’s bank information, and your bank sends you confirmation of your transaction. Your supplier’s bank sends your supplier confirmation of the payment. You then record the transaction manually.
Ø Clearing. Payment method you use to account for interfund expenses when you do not actually disburse funds through banks. Generally, you do not generate a payment document with the Clearing payment method
8.What is cash clearing account? And when it will be used?
Cash Clearing. If you have enabled the Account for Payment When Payment Clears Payables option, enter the cash clearing account you are associating with a payment document. When you create a payment, Payables creates accounting entries for your unreconciled invoice payments to credit this cash clearing account using this account. After you reconcile your invoice payments using Oracle Cash Management, Payables creates accounting entries to debit this cash clearing account and credit this bank account’s cash account. The account you enter here overrides the Cash Clearing Account you entered in the GL Accounts region of the Bank Accounts window.
For future dated payments, when the payment is recorded as mature, Payables debits the future dated payment account and credits the cash clearing account. When you reconcile the payment, Payables debits the cash clearing account and credits the cash account.
9.What is payment format and what is it used for?
Payment Format. The format you want Payables to use to format payments for a payment document.
If you enable the Use Multiple Currencies Payables option, select your functional currency as your bank currency, and define your bank account as multiple currency, you can select any of the payment formats you defined, whether they are multiple currency or not. If you do not define your bank account as multiple currency, you can only select formats that are defined in the same currency as your bank account.
10.What is distribution hold? Can it be released manually?
Hold In Oracle Payables, an Oracle Applications feature that prevents a transaction from occurring or completing until the hold has been released. You can place a hold on an invoice or an invoice schedule line. All holds in Payables prevent payment; some holds also prevent posting to your general ledger.
Distribution hold arises due to imbalance of distribution total, this can be released only by correcting the distribution total. No, it cant be released manually from action window, as we have to correct the entry.
11.What is the selection criteria for concurrent program ‘payables approval’ to approve the invoices?
Parameters: Option, Invoice Batch Name, From Invoice date, to Invoice date, Supplier Name, Pay Group, Invoice Number, Entered By.
12.List the different ways of payment to invoices.
Through Invoice Work Bench & Payment Workbench
13.What are the different statuses of pre-payment invoice? What is the relevance of settlement date?
  1. Never approved
  2. Unapproved
  3. Unpaid
  4. Available – Temporary
  5. Fully Applied - Temporary
  6. Permanent
  7. Cancelled
Settlement Date The date before which you cannot apply a prepayment to an invoice. Payables prevent you from applying a temporary prepayment to an invoice until on or after the Settlement Date of the prepayment.
14.When I am trying to enter an invoice, ‘NEW’ button is disabled. What could be the reason for that?
If you checked the Use batch control Check box at Invoice tab Page in Payables Option ‘NEW’ button disabled.
15.Can I assign a supplier type of bank account to more than one supplier?
Yes,
Allow Assignment to Multiple Suppliers: Enable this option if your bank account belongs to an organization that receives payments for multiple suppliers (a factor organization). With this option enabled, Payables allows you to enter any combination of suppliers and sites in the Supplier Assignments region. It will make the account always available in the list of values for the fields (Bank) Name and (Bank) Number in the Bank Accounts region of the Suppliers and Suppliers Sites windows.
16.What is the request name to view the list of Credit memos?
The Concurrent program is Credit Memo Matching Report.
Parameters: Supplier From, Supplier To, Begin Credit Memo date and End Credit memo date.
17.List the different bank accounts uses in oracle payables.
1. Internal
2. Customer
3. Supplier
18.Even though I have defined a supplier and supplier site, I am not able to enter an invoice for that. Why?
If you are not checking the circled item in supplier site level.

19.On what basis Oracle payables caution the user while entering a Debit memo/Credit memo, as it is a Duplicate.
Those bases are, namely,

 
  1. Supplier
  2. Supplier site
  3. Currency
  4. Amount

 
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)