43778726 oracle question answer

7/31/2019 43778726 Oracle Question Answer

http://slidepdf.com/reader/full/43778726-oracle-question-answer 1/44

Re: What are the matching Po options in AP Invoice Workbench and what

is the different b\w them?there are 2 ways,3 ways and 4 ways matching for PO.

In 2-way: what ever you have ordered for the PO you willmake the payment for the suppliers in 2- way i.e we willcompare two documents PO and Invoice.2-way matching verifies that Purchase order and invoiceinformation match within your tolerances:Quantity billed <= Quantity OrderedInvoice price <= Purchase order priceEg:Suppose we Had given PO for 100 items ,for that we willreceive invoice for 100 items. so that we will make paymentfor that 100 items.

In 3-Way you will compare 3 documents i.ePO+reciept+Invoice.3-way matching verifies that the receipt and invoice

information match with the quantity tolerances defined:Quantity billed <= Quantity received.Eg:Suppose we have ordered 100 items in PO. But we hadreceived only 75 items ,But we had received invoice for 100items. so, we will make payment for only 75 items.

In 4-Way you will compare 4 documents i.ePO+Receipt+Invoice+Inspection.4-way matching verifies that acceptance documents andinvoice information match within the quantity tolerancesdefined:Quantity billed <= Quantity accepted.Eg:Suppose we have 100 items in PO. Suppers send us 75

items We will do inspection on those items what ever wehave received, If 15items got damaged. finally, we aregoing to make payment to the 60 items only.

We have raised the requisition and PO,and also raised the Invoice and made the payment but did notmatch with PO.What we need to do with that pending PO ?1)again mtach PO with invoice2) Void the Payment, Cancel the Invoice, raise a new invoiceand match it against the PO

Can you split an Invoice?u can split an invoice.in the invoice workbench windowselect the invoice and click the split option.Basically You doesn't split the invoice . You split theshedule payment of the invoice . You will get this optionwhen you click the tab of schedule payments of the invoice

Re: What are the types of requitions?Purchase Requisition is used for making PO



Internal requisition is used for Internal sale order

Re: What are the steps to define a Bank?there are 3 types of bank account1.internal2.customer

3.supplier

if ur defining internal and customer bank accounts u needto define payament format.

steps-----setup>payment>format1.payment format describes in which method u want to make

payment to the supplier2.how many invoices are to printed in a cheque.3.how the cheque has to be printedafter defing this save ur work.

step 2------setup>payment>bank

1. enter ur bank name & branch name.2. click on bank accounts3. select internal4. give gl accounts cash & cash clearning5. click on payables doucument6. define name of doc & attach ur payment format which wedefined in step one.7. give the numbering from where to start.this are the mandatory setup's

Re: What are the types of Invoices , what is prepayment & steps to apply it to an Invoice ?Invoices can be of many types viz.standard , debit memocredit memo, prepayment , employess expense report, mixedinvoices and so on...

Prepayment is liek an advance payment to supplier...innormal parlance prepayment means you have made payment forsomethin even though you havent enjoyed the benefit of thesame.

Frst you have to create a prepaymnet invoce and then makethe payment for the saem.

when you ll create an invoice for the same supplier a popup will come which will provide you with the informationthat one prepayment can be apllied to this invoice.

Go to "actions" then "Apply or unapply prepayment"A form will open where in you will have to check the box inthe applied section.You can apply the enitre amount in one invoice or multipleinvoice.The amounts can be changed as per your requirement.



in payables 11 types of Invoices are there

that is1. Standard Invoice2. Debit memo3. Credit memo4. Expencess report5. Mixed Invoice6. Prepayment7. PO defualt8. With holding tax9. Reccuring Invoice10.Interest Invoice11.Quick match

prepayment : advance payment you make to a suppliers oremployee. If you enter Temporary for the Prepayment typefield, 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 advanceto the supplier and will be adjusted againest any invoiceon or after the settlement date but in case of later one,it is treated as deposit with the supplier.

Re: What are the Accounting Entries in P2P.in OracleFinancial terminology ?

he Accounting Entries in P2P cycle when we receive the goods.

A.Inventory Item:-----------------

1.When we receive the goods(for staging areas)

Receiving Inventory A/c DrInventory AP Accural A/c Cr

2.When we transfer the goods (to sub-inventory)

Inventory A/c DrReceiving Inventory A/c Cr

3.When We create AP Invoice matched to Purchase Order

Inventory AP Accrual A/c DrLiability A/c Cr

4.(a)When we make the payment and follows Reconciliation...

Liability A/c DrCash Clearing A/c Cr

(b)When payment is cleared....

Cash Clearing A/c DrCash A/c Cr



OR

4. When we make the payment and we are not followingReconciliation.......

Liability A/c DrCash A/c Cr

And the Final When issued to Dept........

Expencse A/c DrInvemtory A/c Cr

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

B.Expense Item:---------------1.When we receive the goods(for staging areas)

Receiving Inventory A/c DrInventory AP Accural A/c Cr

2.When we transfer the goods (to sub-inventory)

Expense A/c DrReceiving Inventory A/c Cr

3.When We create AP Invoice matched to Purchase Order

Inventory AP Accrual A/c DrLiability A/c Cr

4.(a)When we make the payment and follows Reconciliation...

Liability A/c DrCash Clearing A/c Cr

(b)When payment is cleared....

Cash Clearing A/c DrCash A/c Cr

OR

4. When we make the payment and we are not following

Reconciliation.......

Liability A/c DrCash A/c Cr

Re: What is meant by RFQ?RFQ terms is widely used in Purchasing context,it meansrequest for quotation . This is prepared to requestsupplier to send his quotation for mentioned items andquantities. Supplier send its quotation to buyer, which



buyer enters into application.there are three types of rfq

standard rfq--- one time purchasebid rfq --- when the items are less & cost is more

ex- diamondcatalog rfq --- when the items are more & cost is less

ex- nuts ,bolts, ect

if we enable rfq at the site level we cant riase a qfq fromthat site.

Re: what is meant by accural report? it consist of ?hey are two Accrual methods1 Accrue on Recepit2 Accre at period end

Accre on receipt means that when a receipt is saved,accrual transactions are immeditely recorded and sent to glinterface. This is also known as "online" accruals.Accrue at periond end means that when a receipt is saved,

the accrual transactions are not immediately recorded andsent to gl; instead the accounting entries are generatedand sent at the end of the month by running the ReceiptAccrual-Period End process

Re: How to make an Item as a Stock Item but not forSale.Change the Item Attributes to Y for InventoryItem/Stockable (Inventory Tab) and N for CustomerOrdered/Customer Orders Enabled (Order Management Tab)

Re: define the difference between cycle counting and physical inventory?Cycle Count : Periodic counting of inventory items at

regular intervalsPhysical Inventory : Counting is done once / twice a year

Cycle Count : We can schedule the countPhysical Inventory : We cannot schedule this.

Cycle Count : We cannot have a snap shotPhysical Inventory : We can have a snap shot

Cycle Count : We can view the qty in the systemPhysical Inventory : We can not view the qty in system

Cycle Count : We cane select the items using ABC analysis.

Physical Inventory : It is done for all the items.

Cycle Count : We need not to freeze inventory transactions.Physical Inventory : Need to freeze inventory transactions.

Cycle Count : Recount is possiblePhysical Inventory : Recount is not possible.

Cycle Count : We can maintain recount history.Physical Inventory : No recount, hence no history.



Cycle Count : Adjustments can be procesed on approval.Physical Inventory : Can be done using adjustment concurrentA physical inventory is done once a year to check andcorrect the accuracy of your inventory. Often used bybanks to audit their investment into your company or tosimply reset your stock levels so that inventory is correctand customer service is not impacted by wrong information.

A cycle counts purpose is to find systemic problems, it isNOT intended to ensure your inventory accuracy or fix youron hand quantities. Those are mere bi-products of a cyclecount.

All inventories will have different classification ofproducts called A,B,C,D classification. These classes aredefined by the criticalness and movement of a product wherean A item is high dollar / high mover, and a D item issomething that is identified by the dust it has on theshelf.

A cycle count filters through your inventory over a courseof a year. A company may choose to count all their A items4 times a year, B items 3 times a year, C items twice, andD once.

The theory behind the Cycle Count is to monitor yoursystems (processes and proceedures). Are you pulling partscorrectly, are they marked correctly, is paperwork beingprocessed, is the receiving dept. counting items on theinbound, are product bar coded correctly, is a bill ofmaterial correct, theft, and a hundred other things thatcould possibly cause your inventory to go out of balance.

A cycle count finds those flaws and offers you a chance tocorrect them.

The reason an A item is counted more often than a D is notbecause of Value $$, yet because it is subjected to yourprocesses a lot more. Assuming you have a very solidsystem/process, you constantly test it (via Cycle Counts),and you apply that same exact process to an A item as youdo a D, there is a very high probablility that yourinventory accuracy on the D item will be as accurate asyour A, even though you only counted it once in a yearsspan.

Lastly, a good cycle count has a Hit of Miss criteria.There are always going to be acceptable levels oftolerance. Simply put, do we really care if we are off by1 or 2 pcs. of a $0.01 part that we stock THOUSANDS of?NO! So we identify those tolerances. If your counts fallwith in those tolerances, you have a HIT (good thing). IFthey fall outside of the tolerance you have a MISS (badthing).

Misses are investigated. Problems researched and solutions



secured. THEN as a final measure you would schedule theMISS for a future cycle count, say in a couple of weeks toensure the fix worked, the process is functioning and thesystem is good.

Basic idea behind conducting Stock Count thru Cycle Count (CC)orPhysical Inventory (PI) remains the same of streamlining yourinventory. Now it is not mandatory to conduct the CC or PI yearly onceor once in six months or 3 months so on and so forth, this is purelythe decision of the business (client).

Conducting the stock count process remains same in CC or PI on abroader level.Both processes;1.select the items for the count2.system snapshot3.printing report of system snapshot without item qty4.entering physical stock qty5.printing report for the qty variation between physical and system qty6.recounting the item quantities in case of variation above tolerancelevel (optional)

7.approving the qty varaitions8.posting the adjustment with appropriate transaction type andtransaction account

Differences in CC and PI:

CC - It is stock count method where you select item or list of itemswhich have to be counted.Now you can select the items either bymanually selecting for each CC or by creating item groups using ABCanalysis. By performing ABC Analysis you group the items and performthe CC for each group or collectively.You execute the CC programs andtake the system snapshot as on date. Later you either manually enterthe physical qty or import the physical qty using interface program.

PI - It is stock count method where you select items in an inventoryorg or subinventory/subinventories. Then you execute the generate tagsprogram to create unique tag no. for each item in the list andsubsequently take system snapshot. Then you manually enter the physicalqty against each item and find the variance and finally pass theadjustment on approval.

Re: what is the purpose of item master organisations?can we define more than one item master?In IMO we can define and Maintain items.The organization that contains your master list of items.

Yes,

One IMO is Must,and We can define more than One (IMO)Itemmaster OrgItem master orgnization is vertual organitions where notransaction will be carried out.Used only to define items.

Yes it is possible to have multiple IMOs but notrecommended.It may lead to confusions.



Re: Wanted to send the Notification to the Supplier by e-mail.At supplier site, mention the email id or on the PO whenyou click on 'Approve' Button, a form opens, enable theemail check box and enter the Supplier mail id. Ensurethat the length of the email id is less than 50 characters

as per 11.5.9 version.In addition to above

You can send the PO after creation or approval by -Use the PO Summary>Tool>Communicate functionality to sendthe PO to any one by Email Address.

You can also have supplier role setup in iSupplier throughwhich you can send the emails to supplier without anycustomization in Oracle Workflow

Re: What is the different between 11i and R12 inoracle ?•Multi-Org Access Control•Ledger and Ledger Sets•Subledger Accounting•Tax Engine•Intercompany•Bank Model

Re: How do i generate Taxes when i'm doing Return To Vendor Transaction?There is one option in the supplier for automatic creditmemo when we reverse the grn

Re: What is meant by Position Hierarchy and

Supervisor Hierarchy ????

* Position Hierarchy :

X can see the position below him in the hierarchy . He canalso see the reporting positions.Y has a second assignment for a different position .Because assignment-level security is disabled, X can seethis assignment. X cannot see the positions below theposition for Y second assignment.

** Supervisor Hierarchy :

This means that when a manager logs on to Oracle HRMS, theapplication uses assignment or supervisor attributes tobuild a person tree with the manager at the top level. Theperson tree shows the direct reports for the manager andalso any direct reports at lower levels of the hierarchy towhich the manager has access.

The structure of the person tree depends on whether you areusing an assignment-based or person-based supervisorsecurity profile



Re: Can i assign a supplier type of bank account to more than one supplier ?Yes..we can assign the supplier bank account to more thanone supplier. For this, we have to enable the "allowassignment to multiple suppliers" option at bank accountlevel.

In R12 the bank model is totally changed.

> Centralized bank model.

> Banks are at LE level unlike OU level in 11i

> There is no concept of supplier or customer. Instead called as"Trading Partner" (naming convention).

>A Trading Partner can be a Seller (supplier) or a buyer(customer) forthe organization.

> A bank can be used for both AP and AR or any of these modules.

Hope this brief points can help you.

Re: Which interface tables are used for InvoiceImport , give the important columns?Interface Tables are:

AP_INVOICES_INTERFACE

Important Columns are:INVOICE_ID, GL_DATE, INVOICE_AMOUNT, INVOICE_DATE,INVOICE_NUM, INVOICE_TYPE_LOOKUP_CODE, ORG_ID, TERMS_ID,VENDOR_ID, VENDOR_SITE_ID, ACCTS_PAY_CODE_COMBINATION_ID

AP_INVOICE_LINES_INTERFACE

Important Columns are:INVOICE_ID, INVOICE_LINE_ID, LINE_TYPE_LOOKUP_CODE,LINE_NUMBER, AMOUNT, ACCOUNTING_DATE,DIST_CODE_COMBINATION_ID, ORG_ID

Re: Payment Methods?batches.

electronic--- organisation makes payment through e-commercegateway.they send file to bank and bank makes the paymentto the suppier.

wire---A payment method where you pay invoices outside ofPayables by notifying your bank that you want to debit youraccount and credit your supplier's account with appropriatefunds.

Re: I paid 10,000 Rs in advance to the employee for meeting his expenses. The employee met only 5000



expenses and the remaining 5000 he has to retern tothe company. How will you define it.Employeer is defined as Supplier in expenses so we need to create Credimemo for that remaining 5000 amount. Re: What is meant by pay on receipt auto invoice?Pay on Receipt- You can enter this if the supplier site isa purchasing site.

If you want to use the Pay on ReceiptAutoInvoice Program to automatically create invoices basedon receipts you enter for this supplier site, enter Receipt.

Navigation : Payables->Supplier->Supplier Sites->Purchasing->Self Billing [DFF].

When option is enabled, Invoice will be createdautomatically at the time of receiving goods/receiptcreation. This is a feature of AP to PO cycle.

Re: What is the difference between Operating ID and Org. ID.Org_id: to represent Operating Unit

Organization_id : to represent Inventory Org –confirm

Re: difference between manual payment and quick payment?Manual payment is used to pay the invoices manually usingout checks,whereas quick payments are made thru EDI/EFT orinside clearing or bank transfers in a batch

Re: Why shud we run Expense report import programmein AP..where are we importing from??To import the expense invoice details from 'Expense report'window to 'Invoice' workbench. Once we enter the expensedetails in expense window we need to generate one standardinvoice based on the expense information. Unless we can'tconvert the expense report as std invoice we can't pay tothe emp. As it's a std application feature , withoutinvoice we can't make a single payment in application.

Expense report is also just like another source (internal),to create std invoice from expense report we need to runthe 'Payable invoice import program' (parameter sourceas 'Expense report').

Re: What is meant by void payments?void means useless.

u can use void funtion after payment of invoice, so when uvoid a payament payables automatically reverses theaccounting. void payments restrictions



--------------------------1. when payment paid by third party.2. when payment got clearence from bank3. when the related invoices has prepayment to it.4. partially paid

interest on income will come in adjusting periodOnce Calander is set for 12 months we cannot change it.If you change one "C" you will have problem in SOB.

Re: different phases of aim methodologyDIFINATION PHASEOPERATION ANALYSISSOLUTION DESIGNBUILDTRANSITION

PRODUCTION Re: purchasing and payables done at what level?

means operating unit level or SOB level?The modules like po, ap,ar are come under operating levelthis modules are also called multiorgmodules because thismodules table have column ord_id and have multipleorganization information._all is last we can identify is multiorgtable

Re: purchasing and payables done at what level? meansoperating unit level or SOB level?

HR - Business Group levelGL, FA - Legal Entity LevelAP, AR, Purchasing - Operating Unit LevelInventory - Inventory Unit Level Re: What is Interest Invoice and how it can becreated?Created automatically by payables, for the amount ofinterest calculated on the overdue amount of an oirginalinvoice, for the overdue period. these types of invoicecannot be manuaaly created.

Re: What are the different types of Value sets (or) Validation types ?The Validation type are 8 types

1. Idipendent2. Dependent3. None4. Special5. Table6. Pair



7. Translatable Indipendent8. Transatable dependent Re: What is the purpose of MO: Security Option profile option ?MO:Operating Unit Profile Option is used to Link

Responsiblity with Operating unit.

MO: Security Profile option is used to enable "MOAC" - Multi-Org AccessControl.

Example Case:Payment manager wants to pay for 2 different OUs.

In 11i:--------* We should have 2 different responsibility. ie.,OU1_payables manager &OU2_Payables manager.

* These responsibilities has to be assigned to that particular user

(Payment manager)

* That particular user (Payment manager) will login to theOU1_payables manager responsibility and does the payment.

*Similarly, will login to the OU2_payables manager responsibility anddoes the payment.

In R12:-------* Create only one responsibility. say, Payables manager resposibility.

* Assign this responsibility to the user (payment manager)

* Define a 'security profile' in HR in which you will attach the OUsthat needs MOAC (Multi-Org Access Control)

* Now go into the " MO: Security Profile" option and attache that'security profile' at responsibilty level.

* Now the user can access two different OUs and make payments, sittingat a single responsibility without changing the responsibility.

I hope it will help you.

Re: How to transfer the funds between internal banksIn Cash Management Module u can transfer funds between

internal banks

In R12 Cash Management module, This can be done.There is an option called " Bank Account Transfers", through which youcan do fund transfer between two internal banks.To Do:1. Cash Management > Bank Account Transfers2. Click on 'Create' button.3. Give details of transfer date & transfer amount



4. Enter the Source Bank account Number5. Enter the Destination Bank Account Number6. Apply.

Re: Why Retained Earning Account is necessary for theset of book creation while implementing oracle new

business.HI,RETAINED EARNING IS AN ACCOUNT WHICH BELONGS TO FUNDBALANCE QUALIFIER.AT THE TIME OF YEAR END CLOSING WE NEED TOTRANSFER THE DIFFERENCE BETWEEN REVENUE AND EXPENDITURE TORETAINED EARNING ACCOUNTthen where the difference of Earning and expenditure willgo. This account is also called as Profit and Loss account(P&L). As the balance in this account reflect the Profitand loss of company.

Re: What all elements is set for the Responsibilities?

data grouprequst groupmenu

Re: Can I find out which invoices are matched to aPO?To find Invoices(more then one) to a particular PO going byscreen would be tedious.

This can be done by a simple SQL on AP_INVOICES_LINES_ALLwhere po_header_id is equal to the PO in question. Thisshould list all the invoice lines.

Re: What are the mandatory setups in AP?there are nearly 7 to 8 setups which are mandatory

financial options ---- where we define the mandatoryaccounts 1. liability

2. discount taken3. prepayment

if u r not using INVENTORY OR IF THE OR IS NOT HAVING MULTIORG STRUCTURE THIS IS OPTIONAL

payables option,supplier & bank.control payables periods.

bank format.payment termsdistrubution are also optional u can carry work with outdefining.

There are several mandatary steps in AP1. Set up Payables Options2. Bank3. Supplier (Site level information)4. Open payables Period



5. Payment Terms6. Payment Method7. Distribuation Set

Re: What difference between position hierarchyand Employee Hierarchy ?in Oracle there are 2 types of approval heirarchies whichare as follows:

1. Employee or Supervisor relationships.

If you choose to use employee/supervisor relationships, youdefine your approval routing structures as you enteremployees using the Enter Person window. In this case,Purchasing does not require that you set up positions.

For example when you enter an employee in HR you will alsoenter his supervisor.Now in PO if the employee is a buyerthen approver will be his supervisor.

2. Position Hierarchy

If you choose to use position hierarchies, you must set upboth jobs and positions. While positions and positionhierarchies require more initial effort to set up, they areeasy to maintain and allow you to define approval routingstructures that remain stable regardless of how frequentlyindividual employees leave your organization or relocatewithin it.1. Position Approval hierarchyPosition Hierarchies are hierarchies that have a positionrelationship. By position, we mean position that are

attached to employees. Purchasing utilizes positions as aroadmap to determine how and where documents will be routedonce the approval process has been initiated. It is firstnecessary to have created all positions that are going tobe used in the system. Once all positions have beencreated, it is necessary to build the position hierarchy.Each position has approval limits, so when a purchase orderexceeds the limits of the position, the purchase order isforwarded onto the next position in the Hierarchy.

2. Employee/Supervisor approval hierarchyEmployee/Supervisor approval hierarchy uses the employee-supervisor relationships.

To implement this form of approval routing, you need onlyto define jobs. The job will then serve as the tie to theApproval group, and based on the approval limits from theApproval Group, the Document will either be Approved orForwarded to the Employees’ Supervisor. If no Supervisor isable to be located and the jobassigned to the employee doesnot have Approval Authority, then the Approving employeemust enter a Forward-to person, or the Document will bereturned to an Incomplete status and a notification will besent to the Approving employee, stating - 'No Approver



Found'

Re: What is Zero-Payment in APThere are certain cirumstances wherein we record a debitmemo to reduce the laibility, (What ever may be the reason)though the payable balance decreses, the invoice stillshows the orginal amount to be paid, to correct this

position we make a zero payment and account is nullified.

In order to do this we need to enable Zero payments Checkbox at Bank Account Defnition.

site,payment batch will pick up standard invoices as wellas debit memos created for the same supplier site. It mayhappen that invoice amount is exactly equal to the debitmemo amount so at the time of payment confirmation therewill not be any amount to pay but still it will beregistered as a zero payment to track the accountingentries in the payable accounting. At the time of GLtransfer it will also get reflected for that specificliability account.

Enable Allow Zero Payment checkbox at the bank accountlevel first. Re: Can anybody tell me, What is the ImplementationProcess?Implementations process as follows:1.Definitions phasein this phase the project team plan the implementationsproject and the project team oraganised.kick of meetingbetween superuser,key user and Imp team.it is justintroductions phase.

2.Operations and Analysis PhaseAS IS STUDY AND TO BE STUDY DO DONE and GAP is definedBP40,BP80,RD10,RD20,RD50 AIM's Docs prepare.3.Solutions design.High Gap level find out and full fill the GAP to doneWorkround and Customaizations.Business Requirements Map toApplications.BR10,BR30,MD50,MD70 to be prepared.4.Build PhaseDevelop the development instance and Test instancesuch as BR100,TE20,TE50 to be prepared5.TransitionsTesting done in test InstanceCRP will done.

UAT will done.6.productions.sucessfull done in UAT,it goes to LIVEFind data migrations.support to Post Productions for particular period.(as percustomer discussion)

Re: What in Invoice Variance in A.P.What is Invoice Variance in Accounts Payable ?



Invoice Variance is the difference between the SupplierInvoie and a mix of PO and GRN. What does it mean is thatwhen a supplier's invoice is recorded in the system, systemautomatically compares it with the Price of PO and theQuantity of GRN. Any difference between the purchase pricein PO and Price in Supplier's Invoice, plus the differencebetween the GRN Qty. and the Invoice Qty. toh=gether makesInvoice Variance.

Re: what is a flexfield qualifier ?A flexfield is made of segments and oracle identifies ifparticular segment in the accounting flexfield is anaccount segment or a company segment, based on somepredefined values called as flexfield qualifiers which areassigned to the segments to look meaningful for definingthe accounting flexfield. Eg: Account segment uses NaturalAccount segment and the company segment uses Balancingsegment are mandatory for defining the accounting flexfield.Other values are Cost center segment, Inter companysegment, secondary tracking segment.

Hi AllIn Release R12 , There are 6 Flexfiled Qualifier.They are:-1. Cost Center Segment2. Natural Account Segment3. Balancing Segment4. Intercompany Segment5. Management Segment6. Secondary Tracking Segment

Re: What Transactions are captured in Oparating unitlevel and What at Inventory org level ?OU level:1) AR & AP invoices2) PO3) Sales Order

Inventory Level:1) Material Transactoins2) Receiving Transactions

Re: Please explain: • Automation of Accounts Payableactivities (Evaluated Receipt settlement)Pay on Receipt (also known as ERS (Evaluated Receipt Settlement) orSelf-Billing) is an Oracle Purchasing concurrent program, whichautomatically creates invoices in Oracle Payables and matches them with

PO's automatically for the received amount. The short name for theprogram is POXPOIV. The Concurrent program Name is :“Pay On Receipt AutoInvoice”

Re: What is the use of Cost centerCost center is useful to determine the total cost of aparticular dept/biz center, for a given period[may bemonthly,quarterly or annualy] in order to analyse the pasttrend and to use for budgeting/forecasting purpose for aparticular center



Re: What is the use of pay group in AP?Pay group used to payment to selectd supplier .for example : company have one Paygroup (Employe)for Salary, company will atteched Employe Pay Group wITH all Employe ,

when Accounts will pay claims etc TO employe Then AccountWill Select only Employe Paygroups then System will Selectsall Validate Invoice of Employe for Payments

Re: Is Operating unit have branches in differentlocation. I.e. same operating unit have One branch atDelhi and another one at Mumbai.An operating unit can have "n" number of braches but thequestion is at what level do you want to segregate the subledgers data?

If both Delhi and Mumbai branches are within one operatingunit, then the AP Accountant sitting at Mumbai can accessthe data peratining to Delhi Suppliers and Invoices andvice-versa. If this is not a constraint and ok with thebusiness, then one operating unit can be used for both thebranches. But, if the business wants to segregate the dataand have a control on the same, then they have to go fortwo seperate operating units. So, though it is possible tohave as many branches as required within the same operatingunit, it the business requirement which decides as towhether to go or not to go with a single operating unit formultiple branches.

Re: what is MD050 & wat specifications are included

in itMD050 is functional document. When ever customizationrequire or any new updates comming for intract with 3rdparty applications then only you need to prepare MD050document.

or MD50 technical consultant will prepare MD70MD50 -------> MD70

Re: What is PO rate variance Gain/Loss]this account is used to record exchange rate variancegain/loss for your inventory items.this variance is

calculated between the invoice and either the purchaseorder or the receipt, depending on how you matched theinvoicPayables uses these accounts to record the exchange ratevariance gains/losses for your inventory items. Thevariance is calculated between the invoice and either thepurchase order or the receipt, depending on how you matchedthe invoice. These accounts are not used to recordvariances for your expense items.



Any exchange rate variance for your expense items isrecorded to the charge account of the purchase order.Payables calculates these amounts during Payables InvoiceValidation.

Re: What is a Hold? Explain the types of Hold Hold is term payable manually apply. to prevent invoices

from payament.There are 3 types of holds.1. Invoice Hold.- you can manually apply one or more holdson invoice name by using the invoice hold tab on invoicework bench2. schedule payament Hold- you can hold payament oninvoices by placing holds on one or more schedule payments.

3. sulpplier Hold - In supplier site ypu can defaualt thefoloowing holdsa)Hold all invoices- It holds all invoices relating to

the supplier name where this optiuon is defaulted.b)Hold Unmatched invoices- It holds the unmatched

invoices i,e if the invoices do not match PO Or PO recipts

the invoice is prevented from payament.c) Invoice Amt Limit- If the amoount exceeds the invoice

amount limmit. then the invoice is prevented from payament.d)Invoice Unvalidated- Its prevents the payament for

unvalidated invoices, Unvalidated are those invoices inwhich the distrubution amount does not match with theamonth entered on work bench, or If the tax amount does notmatch.

Re: What is meant by receipt routing?Means how the material will receive by the Organization.Receipt routing are of three types1. Direct delivery

2. standard receipt3. inspection required

1. Direct deliveryThe material direct come to sub-inv.2. Here 1st come to stagging then inv3. inspection required1st it will inspect then store in sub-inv

Re: Can you hold the partial payment if yes then how?Yes We can Hold Partitial payment. Hold on Partial paymentcan be applied using "Schedule payment" SPlit the payamentinto two. this way one line can place hold the other one

made payment.

Re: What are all the standard interfaces in theGL,AP,AR,PO,OM and INV?What are Interface table in AP, AR,GL ? AP INTERFACE TABLE:

1). AP_INTERFACE_CONTROLS.2). AP_INTERFACE_REJECTIONS3). AP_INVOICE_INTERFACE



4). AP_INVOICE_LINES_INTERFACE.

AR INTERFACE TABLE:

1). AR_PAYMENTS_INTERFACE_ALL2). AR_TAX_INTERFACE3). HZ_PARTY_INTERFACE4). HZ_PARTY_INTERFACE_ERRORS5). RA_CUSTOMERS_INTERFACE_ALL6). RA_INTERFACE_DISTRIBUTIONS_ALL7). RA_INTERFACE_ERRORS_ALL8). RA_INTERFACE_LINES_ALL9). RA_INTERFACE_SALESCREDITS_ALL

GLINTERFACE TABLE:

1). GL_BUDGET_INTERFACE2). GL_DAILY_RATES_INTERFACE3). GL_IEA_INTERFACE4). GL_interface

5). GL_INTERFACE_CONTROL6). GL_INTERFACE_HISTORY

Re: On what basis you will define accountingstructureThe accounting structure is defined considering differentparameters.The two major parameters are :The level at which balance sheet is prepared.The levels at which profitability has to be tracked - thiscould be provisional as well as net. Re: whichever documents prepaired by the FUNCTIONALCONSULTANT while implementing project by using AIM

Firt Preparing The RD-20 Doeument

RD-20: Business Requirement gathering (Like this DocumentQuestioner)

MD-50 This Module Disign Document.

BR-30 Mapping Document

TE-40 Test Casess(Unit Testing ,Integrating Testing.......

BR-100 Setup Document Re: Why should we run "Replicate seed data" program??If we runs replicate seed data program all the seededinformation will be reported to new operating unit. seededinformation means default information in oracleapplications.



Re: what is the difference between balance, account,none (automatic offset methods)?Automatic offset method:If you enter invoices for expenses or Asset purchases formore than one balancing segment, you might want to useaotomatic offset method to keep your payables transactions

accounting entries balances.Balance : The liabilty account for balancing segment valuetake from invoice distribution & rest segment values willtake from invoice headerAccount: The libility account for account segment valuetakem from invoce header & rest segment values will takefrom invoice distribution.None : The liability account for all segment values takefrom invoice header.

1)If you enable "Balance": It will replace the BalancingSegment level only while generating an accounting entry fordistributing the invoice. For example, you have raised an

invoice to purchase stationary for company two (02)and yourdefault liability account is 01.000.000.1241 where is 1241is a liability account. Now in distribution line you havegiven the accounting code combination as 02.111.111.1300where 1300 is a expenditure account. Now an entry will begenerated in GL as follows:02.111.111.1300 Dr.02.000.000.1241 Cr. That means this option willautomatically offset the Balancing segment from the defaultsegment 01 to 02 in your liability account.2)If you enbale "Account" the entry will be as follows forthe above example:02.111.111.1300 Dr.02.111.111.1241 Cr. That means this option will

automatically offset the all other segments alongwith thebalancing segment in the accounting code combinationwithout effecting the account head.3)If you enable "None" then the accounting entry for theabove example will be as follows:02.111.111.1300 Dr.01.000.000.1241 Cr That means nothing will be offseted atany segment in the accounting code combination.Then thiswill be an inter-company transaction. Re: What is meant by quotation and quotationanalysis?quotation = is a statement consisting of current price ofthe commodity which the supplier will be sending to theorganisation, when we place RFQ

quotation analysis = after getting the quotation fromdifferent suppliers we select the best quotation , theprocess of selecting the best is know as quotation analysis.



Re: In Accounts Payable credit memo and debit memoare entered with -ve amount but in AccountsReceivable why credit memo has -ve amonut and debit memo + ve?In Oracle terms

credit memo and debit memo decrease the liability and theyare applied against an invoice.The only difference iscredit memo is initiated from supplier endDebit memo is initiated from our end.

If we want to increase the liability in payables either youhave to create a seperate invoice or do some workaround toachieve it through DM/CM.

IN Receivables the concept is pretty clear as credit memohas -ve amount and debit memo is +ve.

In Payable we are receving the material from supplier.so we have to pay the amount to the supplier.in case supplier has send the good more than what we orderat the point of we have to return the goods reduce theaccounting balance.

we send a memo to the supplier is called as debit memomor supplier send a memo is called as credit memo. both ofthe reducing our liability.

In AR module.

we are selling the product to the customer.

either we may forgot to added a freight charges or someother thing. So we have to increase the balance of thecustomer. so we add debit memo

in case we charge more than the product value so we havereduce the amout.

Re: What is Profile ?Profile is a option which will change the way ofapplication running we can set the profile value at 4 level

1. Site level2. Responsibility level

3. Application level4. User level

User level is top most level

1.SITE : If we set the profile at site level that willapplicable all the user

2.RESPONSIBILITY : If we set the profile value asresponsibility that will applicable to the users who are



having access to the specific responsibility. If userhaving access to site,application and responsibility thenresponsibility will overwrite the site and application

3.APPLICATION : If we set the profile value as applicationto the user who are having access to that specificapplication if user having both access to site andapplication level then application overwrite site level

4.USER : User is a top most level. If we set profile valueif user having access to site, application, responsibilityand user then user will overwrite site, application andresponsibility

Re: What reports should I run before closing the period?BEFORE CLOSING A PERIOD IN PAYABLES U NEED TO RUN THEFALLOWING REPORTS,

INVOIVE VALIDATION REPORT---> IT VALIDATES ALL THE INVOICES

INVOICE ON HOLD--->IT WILL SHOW ANY HOLDS, SO THAT U CAN REMOVE THE HOLDS ANDDO REVALIDATION.

IF ANY FUTURE PAYMENTS ARE THERE ?---------------------------------RUN UPDATE MATURED FUTURE PAYMENT ----->THIS WILL CHANGETHE STATUS TO Negotiable .

SUBMITT PAYABLES ACCOUNTING PROCESS-----> THIS REPORT LISTSTRANSACTION WITH ERRORS.

CHECKS FOR PAYMENT BATCHES ---> RUN FINAL PAYMENTREGISTER ,IT LISTS AL THE PAYMENTS.

DO THE RECONCILIATION PROCESS ---> WITH CASH MANAGEMENT

TRANSFER TO GL --> TRANSFER TO GL

CLOSE THE PERIOD AND OPEN FOR NEXT PERIOD

Re: What is difference between match and quick match?PO Default :

Enter PO Default as the invoice type if you know thepurchase order you want to match to, but you do not know to

which purchase order shipments or distributions you want tomatch. When you enter a PO Default invoice in the InvoiceWorkbench, Payables prompts you to enter the purchase ordernumber and automatically enters the supplier name, suppliernumber, supplier site, and the purchase order currency forthe invoice currency. When you choose the Match button,Payables will retrieve all purchase order shipmentsassociated with the specified purchase order. You can thenmatch to any shipment or distribution.



QuickMatch:Enter QuickMatch as the invoice type if you want to

match an invoice to all shipments on a purchase order. Whenyou enter a QuickMatch invoice in the Invoice Workbench,Payables prompts you to enter the purchase order number andautomatically enters the supplier name, supplier number,supplier site, and the purchase order currency for theinvoice currency. When you choose the Match button, Payablesautomatically matches to each shipment. You can choose tocomplete the match or override the matching information.

Re: What is the difference between Electronic fund transfer and wire?Wire transfers and Electronic Funds Transfer (EFT) systems are similarin many ways, and yet differ greatly in terms of their uses andevolution. While wire transfers have long been and continue to be areliable and popular means for transmitting large sums of money, EFTsystems have grown so large that they permeate nearly all aspects ofmodern business and employment. EFT has become so popular that even the

IRS now accepts electronic payments online for both individual andbusiness taxes.

Wire TransfersA wire transfer is simply a transfer of money between two banks througha secure system such as Fedwire for banks within the Federal Reservesystem, or Clearing House Interbank Payments System (CHIPS), which isowned jointly by its members. Traditionally, for an individual (orbusiness entity) to conduct a wire transfer, he must furnish his bankwith the receiving information of the recipient's bank in order toinitiate the transaction. Generally the sending and receiving banksmust hold reciprocal accounts with each other, but the use of a thirdbank (and thus the payment of additional fees) that holds an accountwith both may be used. There are, however, several consumer-oriented

wire transfer services that will allow you to transmit money over greatdistances without holding an account with any bank, often at higher feerates. The most popular example of this type of service is WesternUnion.Electronic Funds TransfersEFT systems simply take the traditional paper check transaction cycleand bring it into the Digital Age. Instead of the receiver's bank usinga paper check to initiate a transfer from the sender's bank, a digitalsignal is generated upon the execution of a transaction and sentthrough an intermediary known as a clearinghouse.

Read more: Wire Transfer Vs. EFT | eHow.com

http://www.ehow.com/about_5412170_wire-transfer-vs-eft.html#ixzz0wKPKLH75

Re: When the Internal Requisition will get generateif I define an OSP operation in sequence 30. 10 & 20 will be other than OSP operations.It all depends on how u set the Requisition Creation Timeparameter in WIP Parameters' Outside Processing Tab.1. At Job/ Schedule Release



2. At Operation3. Manual

Re: What are the master datas in Manufacturing process of Oracle Apps ???- Organizations- Subinventory

- Locators- Items- Suppliers- Optional BPA- Sourcing Rules- ASLs

- Department- Resources (Man, Machine, etc)- BOM & Routing

Re: User is trying to post a journal but the "POST" button is greyed out.What could be the problem?we need to enable the journal approval button after approvalof general then button will be enableSystem admin might have not given him the right to post ajournal. He might have only given him the right to enterjoournals.

Re: In R12 How many key attributes and otherattributes are there ????n R12 Total 10 Item Attributes, where as in 11i it was 8item attributes.

1.Invoice enabled.2.Internal order enabled.3.Transactable.4.Build in WIP.

5.BOM allowed.6.Customer order enabled.7.Purchasable.8.Stockable.9.Process execution enabled10.Reciepe enabled

Re: What do u mean by item category , item catalogue& item type ????Item Category is grouping of items.Item catalogue- List of items available for purchase.Item type- Describes the nature of the item being displayed.

Re: What is the difference between expense item and inventory item ????Expense item- It is the item which is not for sale.(Inventory - It is a Godown where material is stored)Inventory item- It is the item which is available ininventory.

Re: What is the manufacturing part number ??????A manufacturing part number is a unique identifier of apart manufactured in an industry.ex:- bar code(ex:"100-440-0.750-3434-A")



Re: What is the item relationship and item crossrelationship ???? what is the purpose of it ?????Item Relationship- Allows you to search for items throughthese relationships.Item cross Relationship- It is the relationship youestablish between an item and some entitity like old item

numbers, supplier item numbers.

Purpose- These relationships are for inquiry and reportingpurposes only.

Can we maintain 2 sob's for one company, how?Yes we can .if ur company is in different location then urset of books is going to different . let us suppose urorganization location is in INDIA and in US then urfinancila calender is going to be diffrent then u have tocreate 2 set of books for this .accounting flexfield inoracle financials have multiple structures.

Re: If i want to map a organization structure, wherei hv 1 operating unit that is looking after only purchasing and payables activities, whereas anotheroperating unit is looking after OM as well asreceivables. I hv one more warehouse or say plant, where i am manufacturing & despatching the goods. Wiil it be solved by setting up purchasing at one OU

and OM at another OU. Do I need to perform anyadditional setups? Please Suggest.I could not get the reason for having diff OU forPurchasing and OM seperately. Anyway if this what isrequired, then this can be created as seperate OUs e.g Afor PO,AP and B for OM,AR respectively. Also MFG &dispatching warehouse can be setup as inventoryorganization in B OU (OM,AR) and internal sales order setuphas to be done between OU A and OU B to transfer the rawmaterial required for manufacturing . Then dispatchign canbe done from B OU (mfg warehouse)

Re: What are the Inventory Key flex fields?account alias,item catalogs,item categies,salesorders,stock locators,system items and oracle service itemflex field

Re: How do you identify model Type and Option TypeBOM in Bill of Material Pages?You define this in Inventory while defining item master andnot in BOM

Re: Types of Calendar? where we are define it?



prorate calendar in FAAcounting cal in GLTransaction cal in GLWorday cal in INVAccounting Calendar&Transaction Calendar are in GL.Workday Calendar in Inventory Module.

Re: What is difference between Sub inventory Transferand Move order Transfer?For Sub inventory there is no ‘Approval’ is requiredIn Move order Transfer we can transfer Material in stepsthat we can’t in Sub inventory Transfer.correct, sub inventory transfers are unregulated. where asa move order requires and approval depending on the set upthat we provide during inventory organization set up.However, there is an option that if a prticular move orderrequest is not approved within a specific limit, then itshould be approved automatically.sub inventory transfer:

->we can transfer material between sub inventories->we can't cancell the SI transfer->we can't track the transaction

move order transfer:->we can cancell move order->we can track the M O->we can set approval processin Mo transactions we should follow three steps1. approve the transaction2. allocate the quanity

and3. transact the quanity

but subinventory transaction doesn't have these steps

Re: How many type of BOM are availabe?1)Model2)Option class3)Planning4)Standard5)Product family

Re: i have around 10 organisations in our instance .how we can restrict oraganizations access to users .

out of 10 mhe has to access /can see only 4Use Organization access funcionality in Inventory Module.This functionality will restrict the responsibility atorganization levelIn Release 12, Oracle Apps introduces concept of Multi OrgAccess COntrol(MOAC). Making use of it you can restrict orgaccess to a particular user.



Re: what is an attribute from which we candistingwish an orgnisation and master item organisation?In Organization Parameters, Under Inventory Parameters tab,Column 'Item Master Organization' should have the samevalue as the Organization itself. Then this will be theMaster Organization.

For other Organizations, the Org Code and Item Master Orgare different.

Re: Cycle Count?Cycle counting is the periodic counting of individual itemsin your inventory throughout the year based on theirranging.

Count items of higher value more frequently than items oflower value.

You can perform cycle counting instead of performingphysical inventory, or your can use both techniques toverify the accuracy of on-hand quantities and values.

Cycle Count is divided into two primary functions: ABCAnalysis andDefining a Cycle Count.

ABC Analysis:ABC analysis is a method of determining the value of itemsin your inventory, ranking your items according to acriterion and then grouping items into classes. "ABC"refers to the rankings you assign your items as a result of

this analysis, where "A" items are more valuable than "B"items and so on.

Re: what setups are done in BOM?There are 19 setup available in the BOM.but only 4 isMandatory that are :1) Profile Option2) Workday Calendar3) Workday Calendar assign to Organization4) Define parameter (BOM parameter)1.Set Profile Options(Required)2.Define Exception Templates(Optional)3.Define and Build your Workday Calender(Required)4.Assign Workday Calender to organization(Required)

5.Define Bills of Material Parameters(Required)6.Define Department Classes(Optional)7.Define Resources(Optional)8.Define Resources Groups(Optional)9.Define Simulation Sets(Optional)10.Define Locations(Optional)11.Define Departments(Optional)12.Assign Resources and Resource Shifts to Departments(Optional)13.Define Overheads(Optional)



14.Associate Overheads with Departments(Optional)15.Define Alternates(Optional)16.Define Bills of Material Components(Optional)17.Define Standard Instructions(Optional)18.Define Change Order Types(Optional)19.Define Delete Constraints(Optional)

Re: What is Reorder point and Reorder quantity? and what is its significance?Recorder Point is a minimum level of the on-hand inventorystock; when the onhand stock reaches this point, anautomatic requisition is generated. Reorder quantity is thegoverned by multiple factors like - safety stock or maximumquantity; supplier BOD; Lead time, minimum order quantiyetc.The significance is to ensure handling of shortages whichenables smooth manufacturing.Reorder Point = Safety stock + planned receipts during leadtime.

Reorder Qty = How much quantuty to be ordered when stockreached below reorder point.

Significance- Ther are used in reorder planning.

Re: What is accouting class and where is it defined iN WIP?Accounting classes are assigned and used when jobs, workorders,and repetive assemblies associated with productionlines are defined.

Generally standard discrete, asset non-standard discreteand expense non-standard discrete.We need to assign an accounting class all your discrete

jobs.

Standard DiscreteStandard discrete accounting classes can be used to groupjob costs. For example, if youbuild subassemblies and finished goods, you can define youraccounting classes so thatyou can separately value and report the costs associatedwith subassembly and finishedgoods production. Standard discrete accounting classes canbe automatically defaultedwhen you create discrete jobs.

Non-Standard DiscreteNon-standard discrete accounting classes can be used togroup and report various typesof non-standard production costs, such as field servicerepair or engineering projects.For example to track recurring expenses - machinemaintenance or engineering projects- with non-standard jobs, you can define and assign anaccounting class with a type ofexpense non-standard to these jobs.



Repetitive Accounting ClassesRepetitive accounting classes are used to group productioncosts and must be assignedto each repetitive line/assembly association that iscreated. Every schedule for thatassembly on that line uses these accounts. The accounts arecharged whenever youtransact against the line/assembly association. Repetitiveaccounting classes can beautomatically defaulted when you associate repetitiveassemblies with production lines

Negigation is -Work in process-->setup-->Wip accountingclasses

Re: What are the master datas in Manufacturing process of Oracle Apps ???Organizations- Subinventory

- Locators- Items- Suppliers- Optional BPA- Sourcing Rules- ASLs

- Department- Resources (Man, Machine, etc)- BOM & Routing

Re: what is differnce between Tomanufactring leadtimeand total lead time and total cumulative lead time?Cumulative Manufacturing Lead Time:The total time required to make an item if you had all raw

materials in stock but had to make all subassemblies levelby level.

Cumulative Total Lead TimeThe total time required to make an item if no inventoryexisted and you had to order all the raw materials and makeall subassemblies level by level. Re: What are phetom item? How are they user in business case?It is the non-stockable item .phantom items are treatedjust like assemblies except that the phantom item itselfdoes not show up when an assembly is exploded. The child

items of the phantom are blown through and appear aschildren of the parent item to the phantom.

For example, I have an assembly called 5887M which containsa phantom item called 445-0001. When I add the 5887M to awork order and explode the 5887M ,the 445-0001 will notappear in the pick list, but it's children will appear.

ERP handles phantom items in work orders in the following



way. A phantom item will be exploded so that all it'schild items will be in the work order. After the work orderis exploded, you will notice that the phantom item will notappear in the exploded BOM of the work order.

ope this post find you well.Phantom means That which has only an apparent existence.

Tyre Assembly ( Phantom) = Type + Flapper + Rim + tube

But you never buy it, only Type + Flapper + Rim + tubeare baught.Only get it prepared on the shopfloor for thefaster production.

When it will be exploded in the WIP Job, the 4 item willappear and will be consumed not this phantom assembly.As a manufactureditem, a BOM (Bill of Material) and Routing exist, but forproduction efficiency this item has been chosen to be builtas part of the parent process, and therefore no longer

stocked and issued. This eliminates unnecessary workorders, stocking and issuing, streamlines the productionprocess and reduces costly labor hours.

Re: If any person ask what you know about AIM? How briefly we can explain b'coz we cont expalin AIM inshort time.AIM methodology consists of 6 phases

DefinitionOperation AnalysisSolution DesignBuildTransition, AndProduction

Re: What setups are done in WIP?Below is general WIP set up.

1.Define WIP parameters (Req.)2.Define WIP Accounting Classes (Req.)3.Set WIP Profile Options (Req.)4.Define Production Lines (Optional)5.Define Repetitive assembly (Optional)6.Define Schedule Groups (Optional)7.Define Employees (Optional)8.Define Employee Labor Rates (Optional)9.Define Shop Floor Statuses (Optional)11.Define Job/Schedule Docs (Optional)12.Define Operation Documents (Optional)There are some many settings are there but 4settings arerequired for making any transations1)wip parameter setting2)wip profile setting3) Wip account alias settings - very imp while running OSPcycle

Re: What is work order less Transaction in WIP?



Work order less completion in WIP helps us to complete thejob manually without creating a job.

example.

Suppose client wants to continue a job creation function inother ERP like peoplesoft,SAP but they wants to trackinventory in Oracle apps at that we used to go for Workorder less completion.You can do all of the following on the Work Order-lessCompletions window:

-Complete unscheduled or scheduled assemblies to Inventory

-Return unscheduled or scheduled assemblies from Inventory

-Scrap assemblies from and return scrapped assemblies to anyoperation

-Explode the assembly's bill of material and add, delete,and change components-and review items under lot and serialnumber control

-Specify lot, serial, and lot and serial information forassemblies and components.

-Create material reservations for assemblies that are linkedto sales orders

-Replenish production kanbans

Re: How do you ensure on and availability are daily base for min max planning?Schedule Min-max planning report daily basisRe: hOW CAN We define bY Product in Discrete mfg

By Product can be defined as item in the item master and thesame is assiged to the respective BOM with negative quantity.

Re: What you about ‘Mutually Exclusive’ in BOM?Mutually Exclusive is applied to the Option Class. Thismeans that only one option under the option class can beselected. Re: What are step included to make a final assembly?Define all items in inventory.Define the resources,which are going to work on it.

Define the Departments.Define the Standard operations.Define the Routing.Define the Bill.In WIP,define the parameters and Discrete Job.Then in Movetransaction,complete the job,this above process make urfinal assembly to complete.

Re: Explain the OSP cycle?



Let me complete this answer : -1) Create Item and enable the OutSide Processing attributeunder Purchasing Tab and apply the Purchasing Template onit and assign the item to manufacturing Organization.2) Go to BOM-->Routings-->Resources :: Create Resource withfollowing attributes : -Resource Name : Item created in step 1 (recomended but notmandatory)Resource Type : PersonCharge Type : PO ReceiptOutside Processing : Enable itItem = Item Created in step 1Make cost enabled and enter the OSP account.

3) Create Department but remember : -a) Naming like CM (Contract Manufacturing - only

recomended)b) Location (Mandatory) otherwise WIP will have problem.c) Go to Resource (Button) enter resource creted in step 2.d) Enter Shift ( this is related to the calander for this

mfg org). If the resource if 24 hours available, then notrequired.

4) Create Operations :a) Name ( like OSP)b) Department ( created in step 3)c) you can enter the resource(s) requried at this

operation ( created at step 2, but optional). if entered,will default at your routing. You can enter the usase hereor at routing level also.5) Create Routing (normal process, assembly code. rememberthis is not the item created in step 1) and add theOperation where you need osp service.Pls note that you can attached this OSP Operation at Masterrouting or can create another routing with an alternate.Genarally alternate is recomended.6) Create BOM and enter routing created at step 5.Note thatif the routing is on alternate, then, try to have the BOMalso on alternate. This will be your OSP BOM.7) WIP-->Descrete-->Creat Job and enter the assembly atoperation 6.Release the Job, if the ASL is created and Blanket isavailable, requisition and release will be createdautomically after the job is released. If the ASL andBlanket is not available then only requisition, provided initem, use only ASL flag is unchecked.

Re: What is yield point?It is nothing but how much output we can get from the input

Re: What do you mean by Planning Item?A planning item can represent a product family or demandchannel. Its bill of material facilitatesmaster scheduling and/or material planning.The total component planning percentages ona planning bill can exceed 100%. Oracle Order



Management does not allow ordering of Planning Bills Re: What to mean by Multi Org? what are all the multiorg setups?It uses a Single installation to support any number oforganizations, even if those organizations use different

set of books.

Setup : 1) Business Group2) Set of Books3) Legal Entity post to a set of books4) Operating unit are part of a Legal Entity5) Inventory Org are part of a Operating unit

Re: What all diffrent type of supply type are threeand what are there use?There are following supply types:1. Operation Pull2. Assembly Pull3. Push4. Supplier5. Bulk6. Phantom7. Based On Bill

The purpose of putting a supply type is how you want systemto consume the material is right as described byNavdeepinder above.

As if you give PUSH type supply the material will consumedand reduced from sub inventory as soon as u release thejob.

For Operation pull , material will be consumed as soon asyou do first operation on the job while doing the MOVE TXN.

For assembly pull the material will be consumed when youwill complete the assembly.

Bulk is issued in bulk and they are low value item likenuts, Bolts etc.

Phantom : Always used against Phantom Items .

Based On Bill: The supply type defaults to Based on Bill.This supply type indicates that component requirements aresupplied based upon their individual supply types. You canoverride this default by choosing one of the followingsupply types: Push, Assembly Pull,Operation Pull, Bulk, or Supplier

Re: What is an ATP and what are there rules?

Re: how to give an decimal and fraction quantity intransaction like 1.25,3.5,1.999.



We can enter a decimal / fractional quantity on sales orderby ensuring 'OM indivisible' flag checked in the itemdefinition (Physical attributes tab)

Re: What is the diffrance between std job and non std job?Standard Job (WO):: For manufacting a fresh product on the

shopfloor. Mandatory to have routing, BOM etc. You sellthis product to customer using OM.

Non Standard :: When product is returned by the customerfor some defects, it is received through RMA and a WO(Repair Work Order) is created to repair it. This time theJob is Non Standard Job.

Standard Job: This is used for the manufacturing orProcessing of regular Assemblies.

Non-Standard Job: This is used for Rework, Service Item or

Expense Item. Re: What all diffrent typw of resources are there?A Resource is anything required to perform, schedule orcost an operation for example an employee or machine.A resource and usage rate for all scheduled activities isrequired in a routing. Scheduled resources can includequeue, setup, run, and move time.

Different types of resource can be created to reflect theactual staging or manufacturing resource being planned.A resource type can be a person (e.g. technician,specialist, etc.), a machine or physical space.Other types are available (amount, currency, miscellaneous)but only the prior ones will be used at this point .

Re: you have create a purchase order, it is approved also. now you want to change in the purchase order,hoe can you do that?Once approve the purchase order u can change amount orquantity. This is called Revision of the purchase order.Once you revision the purchase order purchase order numberwill go like this "1201-1". You need again sent forapproval of this purchase order.

Re: you have received excess money from thecustomer. now you want to refund the excess money. what is the set up for that?In Oracle Apps 11i, 1st create a credit memo against thecustomer invoice and apply the credit memo with thisinvoice. Then create the customer as a supplier in AP andcreate a invoice and do the payment.

In Oracle Apps R12, 1st create 1 Refund activity called"Customer Refund". Then query the receipt in receipt window,and click on the apply button, select the "Refund" in apply



to column and click the Refund attribute button. Enter therequired field in the new window, and save the record. Asyou save the record "Refund Status" button will visible onthe screen. Click on "Refund Status" button, systemautomatically create a AP invoice against the trading partner.

Re: MIN and MAX number of segments in Chart of

accounts ?You can have min 2 if you are not implementingAssets/Project.(Balancing & natural Account)

If you are implementing Assets.Projects then u have to have3 minimum segments.(Balancing, Cost Center & naturalAccount)

Re: If balancing account is not assigned to company &is assigned to department wat will be the effectsThen the accounts have to balanced at dept level, and notat company level in most cases which is desirable tobalance account a9t company lev

Re: What's the difference between cross validationrules and security rules?a. Cross Validation rules – Rules that restrict theuser from entering invalid key-flexfield segment valuecombinations while data entry. E.g. you may set up a crossvalidation rule that disallows using department segmentswith balance sheet accountsb. Security Rules – A rule that allows restriction onsegment values or ranges of segment values for a specificuser responsibility

Re: What is the Mondatory profile options used in

Multi Org ?Five profile options are mondatory

1. HR: Security Profile2. MO: Security Profile3. GL Set of books name4. MO: Operating Unit5. HR: User type

Re: What is the order in setting up GL ? Which comesfirst - COA, Calendar & Currency ?I feel there is no specific order in which u have to definethem. they are independent and can be defined in any order.

Re: Define the Multi Org ? What is difference between 11i and 12i Multi Org Structure ?The multiorg architecture is meant to allow multiplecompanies or subsidiaries to store their records within asingle database. The multiple Organization architectureallows this by partitioning data through views in the APPSschema. Multiorg also allows you to maintain multiple sets



of books. Implementation of multiorg generally includesdefining more than one Business Group.

Basically the different entities in multi-org are:• Business Group (BG)• Sets of Books (SOB)• Legal entities (LE)• Operating units (OU)• Inventory organizations (IO)

Hi,

If the org has more than an operating unit (least level)then the org structure can be called as multi-org.

The difference in multi-org in 11i & R12i is "MOAC"concept(Multi-Org Access Control)

MOAC provided the role based access, shared services, toperform multiple tasks across different operation units from

within single application responsiblity.

It is controlled by MO: Security profile.

FYI:

R12 Architecture itself completely different and changedfrom 11i.

Re: Accounting methods?Accounting MethodsWhen you set up Payables you choose a primary accountingmethod. In the Payables Options window you can also choosea secondary accounting method. The accounting method

determines the types of accounting entries Payablescreates. For each accounting method, cash or accrual, youchoose a set of books in which you will account fortransactions.Attention: Carefully consider these settings atimplementation time because you cannot change them afteraccounting events occur (for example, after any invoice hasbeen validated in your system.)Set up Payables to create accounting entries in compliancewith one of the following accounting methods:o Cash Basis Accounting. You account only forpayments, and do not record liability information forinvoices. The payment accounting entries typically debityour expense or asset account and credit your cash or cashclearing account. When you create accounting entries,Payables might also create entries for discount taken andforeign currency exchange gain or loss.Payables uses the payment date as the accounting date foryour expense and cash journal entries.o Accrual Basis Accounting. You create accountingentries for invoices and payments. The invoice accountingentries generally debit your expense or asset account andcredit your liability account. For prepayments, Payables



creates accounting entries that debit your prepaymentaccount and credit your liability account. For prepaymentapplications, Payables creates accounting entries thatdebit your liability account and credit your prepaymentaccount.Payment accounting entries typically debit the liabilityaccount and credit the cash or cash clearing account.Payables might also create accounting entries for discounttaken and foreign currency exchange gain or loss.When you reconcile payments using Oracle Cash Management,Payables might also create accounting entries for cashclearing, bank charges, bank errors, and foreign currencyexchange gain or loss between payment and reconciliationtime.o Combined Basis Accounting. You maintain one set ofbooks for cash accounting and one set of books for accrualaccounting. You choose which will be your primary and yoursecondary set of books. Invoice accounting entries arerecorded for your accrual set of books, and paymentaccounting entries are recorded in both your cash set of

books and accrual set of books.Combined basis accounting allows you to produce financialreports for either your cash or accrual set of books. Forexample, you may want to manage your company on an accrualbasis, but require cash basis accounting information forcertain regulatory reporting on a periodic basis.Accrual Basis Accounting ExamplesIn the following examples, US Dollars is the functionalcurrency for your set of books and you use accrual basisaccounting. You account for payments at issue time only.Example 1You enter and validate an invoice for $100 with paymentterms that allow you to take a 10% discount on the invoiceif paid within 10 days. When Payables creates accountingentries for the invoice, it debits the expense account andcredits the liability account.You pay the invoice five days later, taking the 10%discount. When Payables creates accounting entries, itrecords the liability and cash transactions along with theappropriate discount transaction.Example 2You enter and validate a $25 prepayment for a suppliersite. You then enter and validate a $100 invoice for thesame supplier site. When you account for the prepayment andinvoice, Payables records the expense and liabilitytransactions for the invoices.You then pay the prepayment and apply the prepayment to the

invoice, reducing the amount due on the invoice. You paythe remaining amount of the invoice and create accountingentries for the prepayment application and the invoice. Theprepayment application accounting entry debits theliability account for the amount of the prepayment andcredits your prepayment account. The invoice paymentaccounting entry debits your liability account for thereduced invoice amount and credits your cash account. Cash Basis Accounting Examples



In the following examples, US dollars is the functionalcurrency for your set of books and you use cash basisaccounting. You account for payments at issue time only.Example 1You enter and validate an invoice for $100 with paymentterms that allow you to take a 10% discount on the invoiceif paid within 10 days. Payables creates no accountingentries for the invoice.You pay the invoice five days later, taking the 10%discount. When Payables creates accounting entries, itrecords the expense and cash transactions along with theappropriate discount transaction.Example 2You enter and validate a $25 prepayment for a suppliersite. You then enter and validate a $100 invoice for thesame supplier site. Payables records no accounting entriesfor the prepayment and invoice.You then pay the prepayment and apply the prepayment to theinvoice, reducing the amount due on the invoice. You paythe remaining amount of the invoice and create payment

accounting entries. The accounting entry prepaymentapplication debits the expense account and credits theprepayment account for the amount of the prepayment. Thepayment accounting entry debits your expense account andcredits your cash account for the reduced invoice amount.

In AR perspective -Accounting method would be ACCRUAL if you want your billingsystem to record revenue from invoices, debit memos, andchargebacks. When you use this method, Receivables debitsyour cash account and credits your receivables account uponpayment of a debit item.Accounting method would be CASH BASIS if you want torecognize revenue at the time you receive payment for aninvoice, debit memo, or chargeback. Receivables debits cashand credits revenue when using the Cash Basis method.

Re: WHAT IS MONDATORY STEPS FOR PAYABLE MODULE BEFOREENTERING TRANSACTION ?1, Choose Set of Book2, Financial Option3, Payables Option4, Bank Setup5, Supplier Setup6, Payment Terms

These are the main mandatory set-ups which we need to

follow before entering any transactionsRe: How tp determaine that multi org is alreadyimplemented ?Run the following query connected to SQL* plus as the appsuser

Sql> select Milti_org_flag from fnd_product_groups;

If this query returns 'y' then multi org is implamented



If this query returns 'n' then multi org is not implimented

Re: What are the types of receipts?THERE ARE THREE TYPE OF RECEIPTS in receivingi)UNORDERED Receiptii)substitute receipt

iii)Blind Receiptthere are two types of receipts in purchasing

1)express2)cascade

Re: How many views are generated when compilingflexfield structure ?Two views are generates will compiling flexfield

one is user defined and another is system defined

GL_CODE_COMBINATION_KFV (KEY FLEXFIELD VIEW)

Re: dear gurus i would like to know about Flex field qualifiersit describes the nature of the individual segments..two qualifiers are mandatory..1 natural accounting FF qualifier : for the accountsegment,cos we cant enter any journals without theseaccounts ,means proper account is must for any entry..2 balancing FF qualifier: for company segment,cos we need totrack all the reports under company level only and mostimportant is journals are balanced at balancing segment,means debit = credits.

Re: What are the mandatory accounts that need to be

setup in Set of Books?The first mandatory account is Retained Earnings Account.But based on other Standard Options selected, the othermandatory accounts are,a. Suspense Accountb. Rounding Differences Accountc. Cumulative Translation Adjustment Accountd. Reserve for Encumbrance Accounte. Net Income Account

Re: What are the different type of Specialcalendars ?Four type of Special calendars in payables

1.Reccuring calendar2.Withholding Tax calendar3.Payment term calendar4.Key indicator calendar

Re: Can I Change the Value set once i attache to MYCOA and can i post the journal entries with assigingthe valuesets ti the COA



YA U CAN CHANGE THE VALUE SET EVEN AFTER ATACHING IT TO ACOA,PROVIDED U HAVE NOT MAKE ANY TRANSACTION WITH THIS COA.JUST UNFREEDGE THE ACCOUNTING FLEXFILD AND U WILL ABLE TOCHANGE THE VALUE SET.AFTER CHANGINH RECOMPILE THE A/CFLEXFIELD.BUT U IF CHANGE THE VALUE SET AFTER MAKING TRANSACTION INTHE COA.IT WILL CREATE DATA INCONSISSTENT PROBLEM.

Re: Is Operating unit have branches in differentlocation. I.e. same operating unit have One branch atDelhi and another one at Mumbai.An operating unit can have "n" number of braches but thequestion is at what level do you want to segregate the subledgers data?

If both Delhi and Mumbai branches are within one operatingunit, then the AP Accountant sitting at Mumbai can accessthe data peratining to Delhi Suppliers and Invoices andvice-versa. If this is not a constraint and ok with the

business, then one operating unit can be used for both thebranches. But, if the business wants to segregate the dataand have a control on the same, then they have to go fortwo seperate operating units. So, though it is possible tohave as many branches as required within the same operatingunit, it the business requirement which decides as towhether to go or not to go with a single operating unit formultiple branches.

Re: What in Invoice Variance in A.P.What is Invoice Variance in Accounts Payable ?

Invoice Variance is the difference between the SupplierInvoie and a mix of PO and GRN. What does it mean is that

when a supplier's invoice is recorded in the system, systemautomatically compares it with the Price of PO and theQuantity of GRN. Any difference between the purchase pricein PO and Price in Supplier's Invoice, plus the differencebetween the GRN Qty. and the Invoice Qty. toh=gether makesInvoice Variance.

Re: Can somebody provide me the various or atleast most frequent issues a support consultant deal with?t all depends on the nature of the project that u handelin support.

Some Issues are:

1) Holds on AP Invoices2) Partiall Acounted Invoices3) Partial accounted Payments4) Unaccounted Invoices5) Reporting Issues6) Month end closing issues

Re: Can anyone tell me why in some tables in AR , AP,GL modules they r using int_all after every table_all will represent the multiorg tables



Re: why we create diff calenders for each moduleIn Payables we define Special Calendars for controlling thetransaction, like payment terms, withholding tax etc.

In Assets we define dep calendar for to Calculatedeprication for the assets.

Re: what is withholding taxThe amount which is deducted from the supplier invoice and withheldwith the company for the purpose of paying that amount to the taxauthority on behalf of the supplier is called withholding tax.

SETUP

1. Create a Special Calendar for withholding tax

2. Create a supplier of Type Tax Authority

3. Create Tax Code

Give the Tax Code name and Select the type as withholding Tax.Give the GL Account for withholding tax.Provide the withholding tax details:Select the Tax Authority, site and the withholding special calendarRate Structure likeflat rate /amount ranges / period limitSelect the Tax type : Standard / PenaltyAnd give the rate.

4. Create a withholding tax group

Now allow the withholding tax for the suppliers to whom you want towithhold the amount for tax. This is achieved by enabling the allow

withholding while supplier creation step.

So, whenever you create an invoice the withholding tax will beapplicable for that supplier.

Re: What is Reccuring Invoice ? What is the defaultinvoice date for reccuring invoices ?When you are raising an invoice in each month for samesupplier and same amount. you can create recurring invoicesetup for accounts payable module. for this we need tocreate special calender.

Re: Is it possible to change the functional currency

during the mid of financial year ?Rule of thumb is once the ledger is created( whenever), youcan not change the functional currency. Only Choice will beto create the new ledger ..I may wrong though..oracle 12allows secondary ledger where you can change all 3 c..but Idonot think you can change functional currency after theledger creation.. In Relase 12 no more 3'cs that is 4c's



1.Chart of account2.Currency3.Calendar4.Accouting method/Accouting convention(New)

Re: Can a Flex field Qualifies be changed after it

has been created?Yes.. you can change it, subject to there is no journal entry isposted, and at the initial stage of set ups. But, not recommended ifthe transactions are stored for the said accounting flexfield. Oraclewill stop supporting then.

Re: Why are expenses items typically accrued at period end, and why are inventory items alwaysaccrued on receipt?As per Matching Concept all costs which are applicable tothe revenue of the period should be charged against thatrevenue in order to determine net income of the business.

Inventory items are always accrued at receipt bcos youcannot book liability without receiving the asset.

Re: What is terms date basis?Terms Date Basis is to calculate due date.

Due date is calculted 4way.Eg: payment term is 30days

Due date = Sysdate + 30days

Due date = Invoice date + 30days

Due date = Goods Receive Date + 30days

Due date = Invoice Recived date + 30days Terms Date Basis. Date from which Payables calculates ascheduled payment for a supplier. The default is one of thefollowing Payables option you defined for Terms Date Basis.o System. When you enter invoices, Payables defaultsthe system date as the terms date.o Goods Received. When you enter invoices, Payablesprompts you to enter the date you received the goods thatare included on the invoice as the terms date.o Invoice. When you enter invoices, Payables defaultsthe invoice date as the terms date.

o Invoice Received. When you enter invoices, Payablesprompts you to enter the date you received an invoice asthe terms date.

Re: What is the difference between Rollup Groups and Summary Accounts? What is the use of those?Rollup group & summary group they go together, and are notdifferent functionalites

If we have huge accounting structure with many child



account and parent during the process of trial balancegeneration it is faster if summary accounts are created.

Summary Accounts get updated Instantaneously, where as inthe normal course oracle needs calculate all the balances.

Define a Parent Value For a child range

Define a Rollup group

Assign a Rollup group to Parent Value

Define Summary Accounts and call the Rollup group.

Re: Tell me steps for Period closing Process in AP?1. Complete All Transactions for the Period BeingClosed2.Run the Payables Approval Process(Invoice ValidationProgram in 11i) for All Invoices/Invoice Batches.3.Review and Resolve Amounts to Post to the General Ledger.4If there is any Hold on the Invoice it will not accounted.

So we need to remove all the holds on the invoices.5.Review the Payables Accounting Entries Report6.Review the Unaccounted Transactions Report7.Confirm all Payment Batches8.Reconcile Payments to Bank Statement Activity for thePeriod9.Transfer All Approved Invoices and Payments to theGeneral Ledger.10.Review the Payables to General Ledger Posting processAfter Completion.11.Payables Accounting Process Report?(to review accoutingentries created by payable accounting process)12.Submit the Unaccounted Transactions Sweep Program.

13.Close the accounting period by using the ControlPayables Periods window to set the Period Status to Closed.

Re: Can i increse/Decrease ths size of value set ?You can increase the size of the value set but you cannotdecrease the size of the value set.

Re: What does the Unaccounted Transaction SweepReport do?The Unaccounted Transactions Sweep Program transfersunaccounted transactions from one accounting period toanother. The program redates all accounting dates of allunaccounted transactions to the first day of the openperiod you specify.

Re: How to transfer funds between your internal banks?Inter Bank transfers can be handeled in two ways.

1. By using the Cash Management functionality.

OR

2. You need to create a supplier and a customer in the name



of your company.These should be used only for fundtransfers (with fund transfer sites ) You can raise astandard invoice in AP on the Supplier ( Your Co. assupplier ) then make the payment selecting the bank accountfrom which u are transferring funds.

Now in AR you can create a Debit Memo on your company'sname (Customer) and book a receipt selecting the bank inwhich the funds are to be transferred and apply the DM tothe receipt.

Finally at the month end you can pass a manual JV in gl andclear off the balance remaining in these accounts.

Re: As Supplier Header Information can share from another operating unit. Not Sites and otherinformation...... but for a supplier if one OU(1) has made a prepayment..and other OU(2) of the same balancing segment has to make a payment to the same

supplier..the prepayment available with that supplieris overlooked or not considered….is it trueThe question is not quiet clear but from the abovestatements i infer that supplier site informations will notbe shared between operating units. Payables is at aoperating unit level. While making prepayment to asupplier the pay site has to be selected to where theprepayment has to be made. Hence when the same supplierwant to apply an invoice in another OU to the prepayment inthis OU it will not permit.

Yes it is true payables in apps is at operating unitlevel. So applying prepayments between OU's is not

considered.