Oracle R12 P2P (Procure To Pay) - by Dinesh Kumar S

OracleR12:Procure2PayByDineshKumarS
Prerequisites:
FormultiorgsetupspleaserefermyOracleR12:MOAC.
CreateaMultiOrgStructureasbelow.PleaserefermyR12Multiorg(MOAC)materialfor
setupinformation.
PurchasingModuleSetups
BuyerSetup:
Navigation:POSetupPersonnelBuyers
SearchForbuyer,
IfnotfoundaddthebuyerbyclickingAddBuyer
ClickSave.
Employeesetupasbuyersuccessfully.
FinancialOptionsSetup:
Navigation:POSetupOrganizationsFinancialOptions
NowselecttheOperatingunit.ClickNew.
AccountingTab:
SupplierPurchasingTab:
EncumbranceTab:
TaxTab:
HumanResourcesTab:
Note**EnableUseApprovalHierarchiestofollowPositionHierarchyforapprovals.If
unchecked,itwillbefollowingSupervisorHierarchy.
Similarly,dofinancialoptionssetupforPowerOperatingUnit.
PurchasingOptionsSetup:
Navigation:POSetupOrganizationsPurchasingOptions
DocumentControl:
DocumentDefaults:
ReceiptAccounting:
DocumentNumbering:
Similarly,doPurchasingoptionssetupforPowerOperatingUnit.
Changetheoperatingunit,
DocumentTypeSetup:
Navigation:POSetupPurchasingDocumentTypes
ChooseOperatingUnit:
Note**UsedefaultsetupfordocumenttypesRFQandQuotation.
PurchasingRequisition:
Assignthehierarchytobefollowedforapprovalprocess.ClicktorchiconinDefaultHierarchy
field.
Applythechanges.
ChangeOrderRequest:Requisition:
StandardPurchaseOrder:
ContractPurchaseAgreement:
ContractPurchaseAgreement:
Similarly,dothesetupsforPowerOperatingUnit.
ApprovalGroupsCreation:
Navigation:POSetupApprovalsApprovalGroups
Note**Ifapprovalgroupisnotsetupthenrequisitioncannotbeapproved.ItwillbeinNoAction
Takenstatus.
Employee
Positions
DD1,user1
1001.A0_SALES
DD2,user2
2001.A1_SALES
DD3,user3
3001.A2_SALES
DD4,user4
4001.A3_SALES
POSITION
A0
A1
A2
A3
SALES
A0_SALES
A1_SALES
A2_SALES
A3_SALES
Similarlywecan/needtocreateapprovalgroupsforallthepositions.
Jobs
ApprovalLimit$
A0
5000
A1
10000
A2
25000
A3
999999999
GroupforA0Level:
GroupforA1Level:
GroupforA2Level:
GroupforA3Level:
ApprovalAssignmentsCreation:
Navigation:POSetupApprovalsApprovalAssignments
A0Position:
A1Position:
A2Position:
A3Position:
Similarly,createassignmentsgotallthepositionsforPowerOperatingUnit.
InventoryModuleSetups
InventoryItemCreation:
Navigation:INVItemsMasterItems
BeforecreatinganitemchangetheorganizationtoItemmasterusingchangeorganization
form.
CreatingInventoryItem:
Nowweneedtosetupitemattributes.Thebestoptionistocopytheattributevaluesfrom
existingitemattributetemplate.
CopyingtheAttributeTemplate:
Navigation:ToolMenuCopyFrom
SelectaTemplatePurchasedItem.
ClickApplyandthenDone.
AttributeDetails:
AssignItemstoOrganization:
Similarly,createanotheritemDD_INV_ITEM2.
ItemCrossReference:
Navigation:INVItemsCrossReferences
Assignitemstothereferencetowhichthealertshouldbetriggered.
ToActivatetheAlertthefollowingstepstobedone.
Setup1:Profileoptionsetup@ResponsibilityLevel.
Setup2:PurchasingOptionSetup.
DothesetupforbothAviationandPowerOperatingunit.
PayablesModuleSetups
SupplierCreation:
Navigation:APSuppliersEntry
ClickCreateSupplier.
ClickApply.NowtheQuickupdateswindowopens.
QuickUpdateWindow:
SupplierDetails:
CreateSupplierSite:
TocreateNewSiteweneedtodefineaddress.Firstwewillcreatethesame.
CreateAddressBook:
Createasupplier:
ConfirmAddressPage:
ClickApplyandManageSitePageOpens.
ManageSites:
ClickManageSites.
CreateContactDirectory:
TaxDetails:
Organization:
Terms&ControlAccounting:
Purchasing:
Receiving:
Payment:
Leaverestofthesetupasdefault.
InvoiceManagement:
APFinancialOptionSetup:
Navigation:APSetupOptionsFinancialsOptions
AccountingTab:
SupplierPurchasingTab:
PayablesSystemSetup:
Navigation:APSetupOptionsPayablesSystemSetup
PayableOptionSetup:
Navigation:APSetupOptionsPayablesOptions
AccountingOptionTab:
Nochangesinrestofthesetup.
AgingPeriods:
Navigation:APSetupCalendarAgingPeriod
Theothertypeofcalendarusedinpayablesdeterminesagingperiodthatappearsintheinvoice
agingreport.
QueryforStandardMonthlyCalendar.
CashManagementModuleSetups
Navigation:APSetupPaymentBankandBankBranches
Note**wearegoingtodefineBanksetupforLegalEntity.
TodefinenewbankclickBanks.
Note**InR12BankSetupsaredoneatCashManagementModule.
BankSetup
Navigation:APSetupPaymentBankandBankBranches
ClickCreate.
Step1:BankInformation
ClickSaveandNext.
Step2:BankAddress
ClickApply.
ClickSaveandNext.
ClickCreateContact.
Step3:BankContacts
ClickFinish.
BankBranchSetup
ClickCreateBranchicon.
Step1:BankBranchInformation
Step2:BranchAddress
Step3:BranchContact
ClickCreateContact.
ClickFinish.
BankAccountSetup
Navigation:APSetupPaymentBankAccount
CreateBankAccount:
ClickCreate.
ClickContinue.
SelectBankAccountOwnerName.
Note**Ifnovalidvaluesavailable,thebelowsetupstobedoneusingUserManagement
responsibility.
UserManagement:RoleSetup
Step1:LoginasSYSADMIN.
Step2:GotoResponsibilityUserManagementandselectRoles&RoleInheritancemenu
function.
Step3:CreateaNewRole,clickCreateRole.
ClickSaveandthenApply.
Step4:NowQuerytheRoleandRunSecurityWizard.
ClickUpdate.
Step5:RunWizardforCEUMXSecurityWizard
ClickAddLegalEntities.
EnableallthecheckboxesandclickApply.
ClickSaveandthenApply.
Step6:Assigntheroletotheuser.
ClickAssignRole.
EnterthejustificationandclickApply.
BankAccountSetup(Cont)
Navigation:APSetupPaymentBankAccount
CreateBankAccount:
ClickCreate.
ClickContinue.
SelecttheLegalEntityNameintheFieldBankAccountOwner.
Clicktorchicontoselectlegalentity.
Step1:AccountOwner&Use
EnablePayablescheckboxandclicknext.
Step2:AccountInformation
ClickSaveandNext.
Step3:AccountControls
ClickSaveandNext.
Step4:AccountAccess.
ClickAddOrganizationAccess.
ClickContinue.
ClickApply.
ClickSaveandNext.
Step5:AccountContact
ClickCreateContact.
ClickFinish.
NowwehavesuccessfullycreatedBanksetupforLegalEntity.
NowletsseehowtodoBanksetupforasupplier.
Navigation:APSuppliersEntry
QueryforthesupplierandgotoBankingDetails.
ClickGo.
ClickCreate.
ClickApply.
ClickSave.
BankCharges
Inordertocreatetransactionforabankchargeduringsettlement(bycreatingjournalentryor
reducingsettlementamount),theactualchargesmustbefirstdefinedinthesystem.
Navigation:APSetupPaymentBankChargeCalculation
DocumentTypeProcessing
Nowletusseethebelowprocessflow.
Requisition
RFQ
Quotation
PO
Step1:CreatingRequisition
Navigation:PORequisitionsRequisitions
DistributionInformation:
SavetheRequisition.Aftersavingrequisitionnumberwillbegeneratedautomatically.
NowApprovetheRequisitionClickApprove.
SincetheRequisitioniswithinRequesterApprovalLimithierarchyisnotbuilt.
Toverifythehierarchyclickforwardcheckbox.
IfApprovePathandForwardTowillbepopulatingbasedonthepositionhierarchy.
Ifnot,runtherequestFillEmployeeHierarchy.
NowunchecktheForwardcheckbox.
Requisitionsuccessfullygotapproved.
TypesofQuotationsandRFQs
TherearethreetypesofquotationsandRFQsthatcomewithPurchasingbydefault:
Catalog:Usedforhighvolumeitemsoritemsforwhichyoursuppliersendsyou
informationregularly.ACatalogquotationorRFQalsoincludespricebreaksatdifferent
quantitylevels.
Standard:Usedforitemsyou'llneedonlyonceornotveryoften,butnotnecessarilyfor
aspecific,fixedquantity,location,anddate.Forexample,youcoulduseaCatalog
quotationorRFQforofficesupplies,butuseaStandardquotationorRFQforaspecial
typeofpenyoudon'torderveryoften.AStandardquotationorRFQalsoincludesprice
breaksatdifferentquantitylevels.
Bid:Usedforaspecific,fixedquantity,location,anddate.Forexample,aBidwouldbe
usedforalargeorexpensivepieceofequipmentthatyou'veneverorderedbefore,or
foranitemthatincurstransportationorotherspecialcosts.Youcannotspecifyprice
breaksforaBidquotationorRFQ.
Forallthreetypes,youcandefineeffectivedatesattheheaderlevel.ForCatalogandStandard
quotations,youcanalsospecifyeffectivedatesforindividualpricebreaks.(ForaBid,you
cannotspecifyeffectivedatesattheshipmentlevel.)
Step2:CreateRFQ
Navigation:POAutoCreate
Queryfortherequisitioninautocreateform.
ClickFind.
CreateBIDRFQ
BID
Requisition
BID
RFQ
BID
Quotation
PlannedPO
Standard PO
BidRFQSuccessfullyCreated.
Nowweneedtogiveshipmentinformation.
ShipmentInformation:
AddthesuppliertowhomtheRFQtobesentbyclickingSuppliers.
Savetheinformation.
NowchangetheBidRFQtoActive.
Savetheinformation.
CreateBIDQuotation
Step3:CreateQuotationfromRFQfollowthebelowsteps.
ToolsCopyDocument
ClickOk
ChangethestatusofBidQuotationtoActiveandsavethedocument.
Whensaved,theapprovedbuttonwillbeenabled.
ApprovetheDocument.
ClickOK.
ClickOK.
Step4:CreatePOfromBIDQuotation
ToolsCopyDocument
ClickOK.
POSuccessfullyCreated.
POLine,Shipment&DistributionlevelDetails.
ClickApprove.
Note**SometimeswhentryingtoapprovethePOthefollowingerrormighttrigger.
Resolution:Queryforthesite&removethebelowsetup.
Alsointhebelowscreenalso.
NowApprovethePO.
Note**toverifythepositionhierarchy&ApprovalpathIhavecheckedForward.Now
uncheckthesameandsubmitthePO.
CreateCatalogRFQandQuotation
NowletsseehowtocreatecatalogRFQ&QuotationProcess.
Catalog
Requisition
Catalog
RFQ
Catalog
Quotation
Blanket
Purchase
Agreement
Step1:CreateRequisition
Requisitionsuccessfullycreated.
Step2:QueryforRequisitioninAutoCreateformandcreateRFQ.
SelectRFQtypeasCatalogRFQ.
CatalogRFQ
AddthesuppliertowhomtheRFQtobesent.
Note**forCatalogRFQ,pricebreakwillbeenabledandnoshipmentsavailable.
Committhechanges.
NowActivatetheCatalogRFQ.
CatalogQuotation
Step3:CreateCatalogQuotation
ToolsCopyDocument
CatalogQuotationSuccessfullycreated.
NowchangethestatustoActive.Nowtheapprovebuttonwillbeenabled.
ClickApprove.
ClickOK.
Thepricebreakstatusisapproved.
Step4:CreatePOfromcatalogquotation.
ToolsCopyDocument
ApprovetheBPA.
Step5:CreateBlanketReleasefortheBPA.
Navigation:POPurchaseOrdersReleases
ClickDistributiontoenterthedetails.
BlanketReleasesuccessfullyapproved.
SimilarlywecancreateStandardRFQandQuotationfollowingtheabovesteps.
Standard
Requisition
Standard
RFQ
Standard
Quotation
Blanket
Purchase
Agreement
3WayMatchingPOProcessing
Purchase
Requisition
Standard
PO
Receipt
Invoice
TransfertoGL
(Create Journal
Entry)
Create
Accounting
Invoice
Payment
CreateRequisition:
CreatePurchaseOrder:
CreateReceipts:
Navigation:POReceivingReceipts
SelecttheInventoryorganizationtoreceivethegoods.
ClickFind.
Enterthecommentsandclosethewindow.
Sometimesyoumightgetthiserror.
Resolution:Openthepurchasingperiods
Navigation:POSetupFinancialsAccountingControlPurchasingPeriods
PartialReceiving:
Savethedetails.
ClickHeadertoviewReceipt#.
CheckingonHandQuantity:
Navigation:INVOnHand,AvailabilityOnHand,Quantity
ClickFind.
ClickAvailability.
Belowyoucanviewthecompletedetailsofaninventoryitem.
InvoiceProcessing:
Create
Invoice
Match
Invoice
Validate
Invoice
Invoice
Payment
a)CreateInvoice:
Navigation:APInvoicesEntryInvoices
b)MatchInvoice:
ClickMatch.
EnterthereceiptdetailsandclickFind.
ClickMatch.
InvoiceSuccessfullyMatched.
c)ValidateInvoice:
ClickAction1tovalidatetheinvoice.
Note**Sometimesthevalidationcheckboxwillbedisabled.
Toenablethecheckboxthebelowsetupismandatory.
Navigation:APSetupOptionsPayablesOptions
CheckAllowOnlineValidationandsavethechanges.
Savethechanges.
Nowvalidatetheinvoice.
ClickOK.
d)Invoicepayment:
BeforemakingpaymentmakesurepaymentdocumentissetupfortheBankAccount.
SetupPaymentDocument:
Navigation:APSetupPaymentBankAccounts
Nowcreateanewpaymentdocument.
Navigation:APPaymentsEntryPayments
EnterthePaymentdetails.
NowclickEnter/AdjustInvoices.
EntertheinvoiceDetailsandsaveit.
ClosethewindowandopenInvoiceOverview:
InpaymentswindowclickAction.
ClickOK
Twoprogramswillbeexecuted,
1. CreateAccounting
2. TransferJournalEntriestoGL
CreateAccounting:
Validatesandcreatessubledgerjournalentries
TransfersthefinaljournalentriesinthecurrentbatchruntoGeneralLedgerandstarts
theGeneralLedgerpostingprocess
GeneratestheSubledgerAccountingProgramReport,whichdocumentstheresultsof
theCreateAccountingprogram
TransferJournalEntriestoGL:
Validatesandcreatessubledgerjournalentries
TransfersthefinaljournalentriesinthecurrentbatchruntoGeneralLedgerandstartsthe
GeneralLedgerpostingprocess
GeneratestheSubledgerAccountingProgramReport,whichdocumentstheresultsofthe
CreateAccountingprogram.
DocumentReference:
http://docs.oracle.com/cd/E18727_01/doc.121/e13628/T149412T283033.htm
4WayMatchingPOProcessing
Purchase
Requisition
Standard
PO
Transferto
GL
(Create
Create
Accounting
Receipt
Inspection
Invoice
Payment
Invoice
CreateRequisition:
CreatePurchaseOrder:
ReceivingControl:
ApprovethePO.
CreateReceipts:
GoodsInspection:
Beforeinspectinggoods,weneedtodothebelowsetups.
1) ProfileSetup:QA:POInspection
2) CreatingCollectionPlansusingresponsibilityQuality,VisionEnterprise
Step1:ProfileSetup
Navigation:SYSADMINProfileSystem
ProfileName :QA:POInspection
Level
:Site/OrganizationLevel
Step2:CreateCollectionPlan
Responsibility:Quality,VisionEnterprise
Navigation:SetupCollectionPlans
NowcopycollectionelementsbyclickingCopyElements...
Nowqualitycollectionelementswillbeautomaticallypopulated.
NowdefinetransactionsbyclickingTransactionsandCommitthesetup.
NowdefineactionsbyclickingActions.
Selectthecollectionelementsanddefinetheactionsforeachelement.
CollectionElement:Item
Nowstartinspectingthegoods.
Navigation:POReceivingReceivingTransactions
Queryusingreceiptnumber.
ClickFind.
Goodssuccessfullyinspected.
CreateInvoice:
Invoicesuccessfullymatchedandvalidated.
CreatePayments:
BuyerWorkCenter
TheBuyersWorkCenterisacentraldesktopfromwhichbuyerscanefficientlyperformtheir
dailytask,suchasviewingandactinguponrequisitiondemand,creatingandmodifyingorders
andagreements,initiatingnegotiationsifOracleSourcingislicensedandimplemented,and
managingthesupplybase.
MajorFeatures:
AccessrequisitiondemandintheDemandWorkbenchandcreateprocurement
documents
Createanewstandardpurchaseorder,blanketpurchaseagreement,orcontract
purchaseagreement
Updateanexistingstandardpurchaseorder,blanketpurchaseagreement,orcontract
purchaseagreement
Createandmaintainsupplierinformation
IfOracleSourcingislicensedandimplemented,createbuyer'sauctionsorsourcingRFQs
IfOracleServicesProcurementislicensedandimplemented,createandmaintain
purchaseordersforcomplexworkpayments
IfOracleProcurementContractsislicensedandimplemented,authorcontractterms
andmanagedeliverables
Usepredefineddocumentviews
Createandpersonalizeyourowndocumentviewsincludinglistofcolumns,where
conditions,andsortsequences
AccessrequisitiondemandintheDemandWorkbenchandcreate
procurementdocuments
Thisfeatureenablesbuyertoviewtherequisitionsavailableinbuyersqueue.
SearchRequisition:
Followingviewoptionsareavailableforbuyertoqueryforrequisition.
RequisitionsViews
Description
MyLateRequisitions
Thisviewdisplaysrequisitionsthatarepastthe
needbydateenteredbytherequester.Thatis,
theneedbydateontherequisitionispriorto
today'sdate.
MyRequisitions
Thisviewdisplaysallrequisitionsassignedtothe
buyer.Requisitionscanbeassignedtoa
particularbuyerwhentherequisitionwas
created.
MyRequisitionsforGoods
Thisviewdisplaysrequisitionsforgoodsassigned
tothebuyer.
Thisviewdisplaysrequisitionsforservices
assignedtothebuyer.
Thisviewdisplaysrequisitionslinesthatrequire
aRFQ.
Thisviewdisplaysrequisitionsthatsuggesta
supplierwhohasnotyetbeendefinedtothe
system(OracleiProcurementcancreate
requisitionsandsuggestasupplierthatdoesnot
yetexistinthesystem).
MyRequisitionsforServices
MyRequisitionsRequiringaRFQ
MyRequisitionswithaNewSupplier
MyRequisitionswithaSuggested
Supplier
MyUrgentRequests
UnassignedRequisitions
Thisviewdisplaysrequisitionsthataresourced
toasupplier.
Thisviewdisplaysrequisitionsthattherequester
markedasurgent.
Thisviewdisplaysrequisitionsthathavenot
beenassignedtoasourcingbuyer.
PersonalizedViews:
Step1:ClickSearchbutton.
Step2:ClickSaveSearchbuttontoopencreateviewpage.
Step3:CreateaView
SelecttheAttributeProperties.
Entersortingdetails.
SearchQueryinformation.
ClickApply.
SelecttheviewandclickApply.
Searchthecustomview.
Datapopulatedbasedonthequeryfiltercondition.
BuyerRequests:
Buyercanperform3requests,
1) Add:ClickAddtoDocumentBuildertoplacethelinesinyourdocument.
2) Return:ClickReturnLinestoremovetherequisitionlinesfromtherequisitionpooland
changetheirstatusinOraclePurchasingtoReturned.
3) Reassign:Iftherequisitionlinesshouldbeassignedtoadifferentbuyer,youcan
reassignthem.
AddRequest:
SelecttherequisitionandclickAdd.
RequisitionLineaddedtothedocumentbuilder.
Buyercanchoosebelowoptions,
Clear:clearthedocumentbuilderandstartcreatingthedocumentagainfromthebeginning,
clickClear.
Update:tomakeupdatestothedocumentbuilderparameter,enteryourchangesandclick
Update.
Create:CreateaNewPurchasingPODocument.
LetscreateaNewStandardPurchaseOrderclickCreate.Theuserwillberedirectedthe
Ordercreationpage.
ThePurchaseOrderSuccessfullycreated.
InputtheHeader,Line,Shipmentanddistributiondetails.
HeaderInformation:
LineInformation:
Buyercanperform3lineactions,
Update:ToupdateLineinfo,LineBillingandShippinginfo.
Duplicate:DuplicatetheLinesInformation.
Delete:DeletetheLine
ScheduleInformation:
BuyerscanPerform3ScheduleActions,
Update:Updatetheschedulinginformation.
Split:splitanexistingrequisitionlineintomultiplerequisitionlinesthatrepresentthe
sameordifferentitems.
Delete:Deletetheexistingschedule.
DistributionInformation:
BuyerscanPerform3DistributionActions,
Details:ToviewtheDistributiondetailsandUpdatethesame.
Split:splitanexistingrequisitionlineintomultipleDistributions.
Delete:Deletetheexistingschedule.
BuyercanupdatetheapprovaloptionsbyclickingApprovalOptions.
SubmittheDocument.
AccessingandmanagingthePurchasingPODocument
CreateStandardPurchaseOrder:
ClickOrderstabtoviewandmanageOrders.
TocreatenewOrder,SelecttheOrderTypeandclickGo.
EntertheHeaderInformation,
LineInformation,
ScheduleInformation,
SplittheLineasbelow.
DistributionInformation,
ApprovalOptions:
SubmitthePO.
AccessingandmanagingPurchasingAgreements
ClickAgreementstab,
ChooseBlanketPurchaseAgreementandclickGo,
HeaderInformation,
LineInformation,
ControlOptions
BPASuccessfullyCreated.
Belowagreementscanbecreatedusingthisworkbench,
ManagingDeliverables
AboutDeliverables:
Businessesenterintocontractualagreementswiththeirtradingpartners,andaspartofthe
contractualagreementwillhavecommitmentstofulfill.
Thecommitmentsonthebusinessdocuments,besidesproductsandservicesboughtorsoldare
classifiedasdeliverables,undertheTermsandConditionsofthebusinessdocument.
Inadditiontothecontractualcommitmentsthatbusinessesneedtofulfill,theymightdefine
otherinternaltasksthatcontributetotheoverallexecutionofthebusinessdocument.
Youcandefinedeliverablesaspartofthecontracttemplatecreationprocess.Ifabusiness
documentreferstoacontracttemplate,alldeliverablesassociatedtothatcontracttemplate
arecopiedtothebusinessdocument.
ManagingNegotiations
AboutNegotiations:
WhenOracleSourcingModuleisenabledforOraclepurchasing,thisoptionwillbehelpfulin
managingandmonitoringnegotiations.
SupplierAdministration
Reference:OracleHelp
Supplieradministrationenablesbuyingorganizationstomaintaincurrentinformationabout
theirsuppliersandsupplierusers.Authorizedbuyerscaninviteorregistersuppliers.Once
registered,supplierscanprovidedetailedinformationontheircompaniesintheformof
supplierprofiles.Supplierprofileinformationcanbeenteredandmaintainedbyboth
authorizedpersonnelatthebuyingcompanyaswellasauthorizedusersatthesupplier
companies.Updatesperformedbythesupplierusersarereviewedand,ifapprovedbybuyer
administrators,canbepromotedintothebuyingcompaniesprocurementsystems.This
removesmuchoftheadministrativeburdenfromthebuyeradministratorsandallowssuppliers
tomaintainmoreuptodateprofileinformationontheircompany.
SupplierAdministrationconsistsof
Supplierdefinitionandmaintenance
Supplierregistration
Supplieruserregistrationandmaintenance
Supplier Definition and Maintenance

Animportantareaofsupplieradministrationistheprocessofcompletelydefiningsuppliersto
theprocurementsystem.Thisincludes,butisnotlimitedto,detailedinformationofthe
supplier's:
Corporatestructure
Taxregulationsandreportingrequirements
Siteinformation
Contactinformation
Purchasingdefaultsandsettings
Payablesdefaultsandsettings
Invoicingprocedures
Receivingdefaults
Bankingdefinitions
Accountingdefinitions
Supplier Registration
Usingsupplierregistration,supplierscanregisterforaccesstoOracleSelfServiceapplications
suchaOracleSourcing,OracleiSupplierPortal,orOracleCollaborativePlanning.Oncethe
registrationrequestandbeencompletedandsubmitted,andasupplierprofileadministrator
hasapprovedtherequest,anotificationissenttothemainsuppliercontact,andusersatthe
companycanbeginregisteringandrequestingsystemaccess.
Supplier User Registration and Maintenance
Oncethesuppliercompanyisdefinedandregisteredwiththebuyer'sprocurementsystem,
usersatthesuppliercompanycanalsobeginregisteringaswell.Oncetheirregistration
requestsareapproved,thesupplieruserscanbeginaccessingthesystemsubjecttoany
securityrestrictionsappliedbytheapprover.
Afterthesupplierusersareregisteredwiththesystem,personalandaccessinformationis
maintainedforthemintheirindividualprofiles.Changestothisinformationcanbeenteredby
supplieruseradministratorsatyourcompany.Additionally,updatescanberequestedby
supplierusermanagersatasuppliercompanyforusersatthatcompany.Theseupdatesare
reviewedand,ifapproved,enteredbyasupplierprofileadministrator(usuallyduringthe
courseofupdatingthatcompany'scontactdirectory).
AccrualReconciliation
Accruals:
Accrualsareaccumulationofexpensethatisrecognizedbeforecashispaid.
Accrualsareliabilitiestopayforgoodsorservicesthathavebeenreceivedbuthavenotbeen
paidorinvoiced.
TypesofAccruals:
Thereare2typesofpurchasingaccruals,
1. OnlineAccrual
2. PeriodEndAccrual.
AccrualSetups:
DefineExpenseAPAccrualoption:
Thisaccountisusedtoaccruepayablesliabilityforexpenseitemsattimeofreceipt.
Thisaccountisusedtoaccruepayablesliabilityforexpenseitemsbyreceiptperiodend
accrualprocess.
Navigation:POSetupOrganizationsPurchasingOptions
Query:
SELECTEXPENSE_ACCRUAL_CODE,
INVENTORY_ACCRUAL_CODE,
ACCRUED_CODE_COMBINATION_ID
FROMPO_SYSTEM_PARAMETERS_ALL
WHEREORG_ID=:P_ORG_ID;
DefineInventoryAPAccrualoption:
Thisaccountisusedtoaccruepayablesliabilitywheninventoryitemsarereceived.
Navigation:INVSetupOrganizationsParameters
Query:
SELECTAP_ACCRUAL_ACCOUNT
FROMMTL_PARAMETERS
WHEREORGANIZATION_ID=:P_INV_ORG_ID;
DeclareAccrualAccounts:
Beforestartingthereconciliationdeclaretheaccounts.
Navigation:POAccountingAccrualWriteOffSelectAccrualAccounts
AccrualReconciliationPrograms
ProgramName
Usage
CreateAccountingReceiving/ *Transfersthedatafromreceiving/inventorysubledgersto
CostManagement
SLA.
*CreatejournalsinSLA.
*TransferandpostingjournalstoGLcanalsobedone.
TransferJournalentriestoGL
*TransfersjournalsentriestoGL
*Postingthetransferredjournalscanalsobedone.
AccrualReconciliationLoadRun *TheLoadprogramisusedtopopulatetheaccrual
reconciliationtableswithallthenecessarytransactiondata
neededtoperformthereconciliationprocess.
*AlltheaffectedPodistributionswithinthedaterangewillbe
deletedfirstandcurrent/updatedvaluesforthetransactions
inthedaterangewillbeappendedtoexistingdata
*InupgradedinstanceIgnorestheFromDatespecifiedand
runsfromthestartoftransactionhistory
*Inupgradedinstanceupgradesthewriteofftransactions
from11iandloadsthemintocst_write_offsand
cst_write_off_detailstable.
APandPOAccrual
ReconciliationReport
*Showsthetransactiondetailsbasedoneachaccrualaccount
foreachPOdistributionwiththeReceivingtransaction
amountandinvoicetransactionamountwithanetbalance
greaterthanzero.
*Showsthetransactiondetailsbasedoneachaccrualaccount
whichgothitbecauseofMiscellaneousInventorytransactions
andAPNOPOtransactions.
MiscellaneousAccrual
SummaryAccrual
*Showsthetotalbalancesforeachaccrualaccountwithout
anydistributiondetailsandindividualtransactionamount.
PurchasingAccrualProcess:
InventoryAccrualProcess:
PayablesAccountingProcess:
AccrualReconciliationLoadRun:
ReconciliationDataFlow:
KMNotes:
1478292.1R12AccrualReconciliationDiagnosticsAndTroubleshootingGuide
1107953.1R12AccrualBalanceMismatchBetweenAccrualReconciliationReportand
GLTroubleshooting
1117353.1R12:DiscrepancieswithAccrualReconciliationReportTroubleshooting
866733.1HowToDiagnoseInventoryAccrualsAndAccrualWriteOffIssues
1126025.1R12:DiscrepanciesWithAccrualReconciliationReportForConsignedItems
Troubleshooting
883557.1R12:HowToAvoidandFixCorruptioninDataTransferfromSLANegative
Ledger_ID,NotReachedGL,DuplicateinGL
604893.1R12.0andR12.1:FAQfortheSLAUpgrade:SLAPreUpgrade,PostUpgrade,
andHotPatch1472099.1
PeriodEndActivity:
Belowisthesuggestedorderforclosingoraclemodules,
1)
2)
3)
4)
5)
6)
7)
8)
9)
OrderManagement/Shipping
CashManagement/Treasury
Payables
Receivables
Purchasing
Inventory/Costing
Projects
Assets
GeneralLedger
PayablesMonthEndActivity
No. Required Activity
Details
Yes
Completealltransactions
Completethebelowtransactions,
Invoicing&Credits
Prepayments
ExpenseReport
InvoiceImports
Payments
Note**AllOU'swithingsameledgermustbe
readytocloseatsametime.
Yes
ApproveInvoices&Complete
Payments
Yes
3a)
Yes
Review&Resolveamountsto
PosttoGL
InvoiceonHoldReport
ToApproveallUnApprovedinvoicesand
invoicelinesinthesystemrunthebelow
request
"PayablesApproval"
Sothattheycanbepaid&postedtoGeneral
Ledger.
Belowreportstobescheduled/run.
3b)
Yes
JournalEntriesReport
RunReport"JournalEntriesReport"
Itproducesadetail/Summarylistingof
accountinginformation,thathavebeen
accountedwitherrorandallentriesthat
couldnotbetransferredtoGL.
3c)
Yes
UnaccountedTransaction
Report
3d)
Optional
PaymentProcessRequest
Runreport"UnaccountedTransactions
Report"
Itcontainslistofallpaymenttransactions&
reasonwhypayablescannotaccountfora
transaction.
Thisreportdoesnothaveinvoicewithno
distribution.
Note**Runthisreportafter"Create
Accounting"Process.
Itarrangespaymentschedulefordueinvoices.
Runreport"InvoiceonHoldReport"
ListHoldsappliedtoinvoicesforwhich
posting&Journalentriescannotbecreated.
3e)
Yes
3f)
Optional
PaymentRegister
3g)
Optional
PostedPaymentRegister
Runreport"PostedPaymentRegister"
Thisreportcontainstotalpaymentamount
(IncludingDiscounts)
ReconcilePaymentstoBank
StatementActivity
Whenbankstatementisreceivedwecan
reconcilepaymentsnymatchingtheamount
ofeachpayment/depositreceivedwiththe
amountthatwassubmittedtobank.
Reconcilingcanbedonein2ways,
1)Manually
2)Automatic
Manually:CreateBankStatementLines
manually.
Automatic:3programsareavailable,
1)BankStatementImport
2)AutoReconciliationProgram
3)BankStatementImport&
AutoReconciliation
Yes
Confirmallpayment
Instructions
RuntheProgram,"PaymentInstruction
Register".
Itlistseachpaymentcreatedforpayment
processprofileormanualpayment.
Actualpaymentsarecomparedagainstthis
registertoverifyoraclepayableshave
recordedpaymentscorrectly.
RunReport"PaymentRegister"Thisreport
canbeusedtoreviewpaymentactivityfor
eachbankaccountduringspecifictime
period.Thisreportonlyshowsnetpayment
amount(withoutDiscounts).
Yes
Optional
Transferallapprovedinvoices
andpaymentstoGL
ReviewthepayablestoGL
PostingProcessafter
completion
Runtheprogram"CreateAccounting"There
are3modesavailableforaboveprogram,1)
Draft2)Final3)FinalPostDraft:itwillcreate
Journalentrieswhicharenotfinal,andthey
arenotreadytotransfertoGL.
TableHit:(DraftMode)
XLA_AE_HEADERS
Accounting_Entry_Status_Code=D
XLA_AE_LINESXLA_EVENTS
Process_Status_Code=D
Even_Status_Code=U
Note**Wecanrunthisprogramagain&
again,itwilldeletetheoldjournalentries
andnewonewillbecreated.
Final:Itwillcreatejournalentrieswhichcan
betransferedtoGL.
TableHit:(FinalMode)
XLA_AE_HEADERS
Accounting_Entry_Status_Code=F
XLA_EVENTS
Process_Status_Code=P
Even_Status_Code=P
Note**CreateAccountingcannotberun,ifit
isfinallyaccounted.
FinalPost:CreateJournalentriesinfinal
mode,transfertoGlandpostthem.
TableHit:(FinalMode)
XLA_AE_HEADERS
Accounting_Entry_Status_Code=F
Transfer_Status_Code=Y
XLA_EVENTS
Process_Status_Code=P
Even_Status_Code=P
GL_JE_HEADERSStatus=P
Runthebelowreports.
6a)
Optional
PayablesAccountingProcess
Report
Runthereport"PayablesAccountingProcess"
toreviewaccountingentriescreatedby
CreateAccountingProcess.
thisreporthave2sections,
a)AccountingEntriesauditreport
(Detail/Summarylist)
b)AccountingEntriesexceptionReport
(Entrieswitherrorstatus)
6b)
Optional
PostedInvoiceRegisterReport
Runthereport"PostedInvoiceRegister"
Invoiceinfo.PostedtoGL.
itcanbeusedtoverifytotalinvoiceamount
equaltoallinvoicedistributionamount.
6c)
Optional
PostedPaymentRegisterReport Runthereport"PostedPaymentRegister"
ReviewpaymentspostedtoGL.Review
PaymentActivityeachbankaccount.
Yes
UnaccountedTransaction
Sweep
Runthereport"UnpostedInvoiceand
PaymentSweepProgram"
ittransfersunaccountedtransactionsfrom
oneaccountingperiodtoanother.
Note**ifanyunaccountedtransactions
existsthatperiodcannotbeclosed.
Thisprogramwillnotforwardaccounted
transactionswitherrors.Theerrorsshouldbe
correctedandresubmittedbyexecuting
"CreateAccounting"Process.
HowitWorks?
In"ControlPayablePeriods"windowifyoutry
tocloseaccountingperiodwithunaccounted
transactionsexists,thepayableswindow
opensawindow,fromtherewecansubmit
theaboveprogram.
Yes
ClosetheOraclePayable
Periods.
PurchasingMonthEndActivity
No. Required Activity
Details
Yes
Completealltransactionsfor
theperiod.
Completethebelowactivities,
CompleteRequisitions
CompletePOandReleases
CompleteReceiptsandReturns
Note**Submit"ConfirmReceipt"workflow
selectorderprocessinpurchasingtosend
notificationsthroughweb,email/notification
detailstorequesters/buyerswhocreate
requisitionsinpurchasing/iProcurement.
Print(or)ArchiveallNewPO's
Runprogram"PrintPurchaseOrders"
Respondtoallworkflownotifications
(Optional)
Optional
Reviewthecurrentandfuture
Commitments
Runthereport"PurchaseOrder
CommitmentByPeriodReport"
thisreportshowsthemonetaryvalue
(relatingtomoney/currency)ofpurchased
commitmentsforspecificperiod.
tomonitorbuyerperformance.
usereportwhennegociatingwithsuppliers
bylimitingthecommitmentsofspecific
supplier.
Optional
Reviewtheoutstandingand
OverduePO
Runthebelowreports,
PurchaseOrderDetailReport
OpenPurchaseOrdersReport(byBuyer)
OpenPurchaseOrdersReport(byCost
Center)
Note**Inthisreportquantityordered&
Quantityreceivedisdisplayedsothatstatus
ofthePOcanbemonitored.
Yes
FollowupReceiptsCheck
withSuppliers
IfPOnotreceived(or)Receiptsnotentered,
Buyer/Userneedstocontactrespective
department/dupplierforthesame.
Note**EvenafterclosingthecurrentPeriod
Receiptscanbecreatedbyenteringaback
data.
Theabovetransactionispossibleonlywhen
"OracleInventory"modulenotinstalled.
Yes
IdentifyandReviewUn
invoicedReceipts(Periodend
Accruals)
Runthereport"UninvoicedReceipts
Report"toreviewreceiptsforwhichsupplier
invoicehasnotbeenenteredinpayables.
Receiptaccrualscanbereceivedbyaccount
&item.helpinpreparationofaccrual
entries.
Yes
FollowUpOutstanding
Invoices
RuntheProgram"UninvoicedReceipts
Report"
Tofindenteringofinvoices,matchingof
unmatchedinvoicesandresolutionofinvoice
holds&helpsinpreparationofaccrual
entries.
Yes
CompleteOraclePayables
PeriodendProcess
CrosscheckPayablesperiodisclosed&all
activitiesarecompleted.
Yes
ReceiptAccrualPeriodEnd
Report
Runthereport"ReceiptAccrualsPeriod
End"
itcreatesperiodendaccrualsforuninvoiced
receiptsforexpensedistributions.
eachtimeitruns,oraclepurchasingcreates
anunpostedjournalentrybatchinGLfor
thereceiptaccruals.
ifEncumbrance/Budgetarycontrol
enabled,anotherjournalentryis
corrospondingtoreversalentriesforun
invoicedreceiptsthatwereaccrued.
theabovetransactionhappensbyenabling
profile"GL:LaunchAutoReverseAfterOpen
Period".
ifprofilesetto'N',manualreversalshould
bedone.
Note**thisstepisrequiredifaccrue
expenseitemflagissetto"PeriodEnd"in
purchasingoptionsetups.
Whenflagissetto"AtReceipt",areversal
isnotrequired.
Note**thisprogramCreateAccountingin
receivingsubledgeronly.Then"Create
Accounting"Programneedstoberunto
createSLAJournals.
Yes
ReconcileAccrualAccounts
ProgramInformation:
CreateAccounting:
TheCreateAccountingprogramcreatesandtransfersjournalentries.
ParameterDetails:
Parameters
Ledger
ProcessCategory
Description
RequiredParameter.
SelecttheLedgerforwhichaccountingentriestobecreated.
IftheprofileoptionSLA:EnableDataAccessSecurityin
SubledgersissettoYes,onlythoseledgersthatareincluded
inGeneralLedgerAccessSetsassignedtotheresponsibility
appearinthelistofvalues.
OptionalParameter.
Itrestrictstheeventsselectedforaccountingtoaparticular
processcategory.
TheCreateAccountingprogramselectseventswithevent
typesfallingintotheeventclassesassignedtotheprocess
category.
Onlyprocesscategoriesestablishedbydevelopmentteams
EndDate
Mode
ErrorsOnly
aspartoftheseeddataareincludedinthelistofvalues.
RequiredParameter.
Processesonlythoseeventswitheventdatesonorbefore
theenddate.
RequiredParameter.
Itdetermineswhetherthesubledgerjournalentriesare
createdinDraftorFinalmode.
IfDraftmodeisselected,thentheTransfertoGL,Postin
GeneralLedger,andGeneralLedgerBatchNamefieldsare
disabled.DraftentriescannotbetransferredtoGeneral
Ledger.
RequiredParameter.
Itlimitsthecreationofaccountingtothoseeventsforwhich
accountinghaspreviouslyfailed
IfYesisselected,theCreateAccountingprogramprocesses
alleventswithastatusofError.
Report
TransfertoGeneral
Ledger
PostinGeneralLedger
GeneralLedgerBatch
Name
IncludeUser
RequiredParameter.
Itdetermineswhethertogenerateareportshowingthe
resultsoftheSubledgerAccountingprograminsummaryor
detailformat.
Required,ifmodeissettoFinal.
Itdetermineswhethertotransferthesubledgerjournal
entriestoGeneralLedger.
JournalimportisnotlaunchediftheprofileoptionSLA:
DisableJournalImportissettoYes.
RequiredifModeissettoFinalorCreateAccountingissetto
No.
Itdetermineswhethertopostsubledgerjournalentriesin
GeneralLedger.
Ifthereisaprimaryledgerwithsecondaryledgersattached
toitandtheapplicationisanonvaluationmethod
application,thejournalentriesofthesecondaryledgersare
automaticallyposted.Thisisbasedontheapplication
accountingdefinitionthattheusersetsup.
Iftheapplicationisavaluationmethodapplication,then
thereisadifferenteventforthatsecondaryledgerandthe
accountingisnotcreatedinthesamerunforbothledgers.
OptionalParameter.
Userenteredbatchnamethatappearsonthetransferred
GeneralLedgersubledgerjournalentries.TransfertoGL
optionmustbesettoYes.
RequiredParameter.
Transactionidentifier
Itcontrolswhetherthereportdisplaysuseridentifiers'
namesandvalues.
TransferJournalEntriestoGL:
TheTransferJournalEntriestoGLprogramconsistsofasubsetofparametersusedinthe
CreateAccountingprogramaslistedbelow:
Ledger
ProcessCategory
EndDate
PostinGeneralLedger
GeneralLedgerBatchName
JournalImport:
Noparametersforthisprogram.
ProcuretoPayTableHits
ProcessFlow
RequisitionTables
PO_Requisition_Headers_All
(REQUISITION_HEADER_ID)
PO_Requisition_Lines_All
(REQUISITION_LINE_ID)
PurchasingTables
PO_Headers_All
(PO_Header_ID)
PO_Lines_All
(PO_line_ID)
PO_Line_Locations_All
(Line_Location_ID)
ReceivingTables
Rcv_Transactions
(RCV_TRANSACTION_ID)
Rcv_Transactions
(SHIPMENT_HEADER_ID)
Rcv_Shipment_Headers
InvoiceTables
AP_Invoice_Distributions_All
(Invoice_ID,INVOICE_LINE_NUMBER)
AP_Invoice_Distributions_All
(Invoice_ID)
AP_Invoice_Lines_All
(Invoice_ID)
(PO_LINE_LOCATION_ID)
AP_Invoices_All
(Invoice_ID)
AP_Invoice_Payments_All
(Invoice_ID)
AP_Invoices_All
(Terms_ID)
AP_Invoices_All
(Invoice_ID)
AP_Terms
(Term_ID)
AP_Invoices_All
(Batch_ID)
AP_Invoices_All
(Invoice_ID)
PO_Requisition_Lines_All
(REQUISITION_HEADER_ID)
PO_Req_Distributions_All
(REQUISITION_LINE_ID)
PO_Lines_All
(PO_Header_ID)
(PO_line_ID)
PO_Distributions_All
(Line_Location_ID)
RCV_RECEIVING_SUB_LEDGER
(RCV_TRANSACTION_ID)
Rcv_Shipment_Headers
RCV_Shipment_Lines
(Invoice_ID,INVOICE_LINE_NUMBER)
AP_Invoices_All
(Invoice_ID)
AP_Invoices_All
(Invoice_ID)
(PO_LINE_LOCATION_ID)
(Invoice_ID)
AP_Payments_Schedules_All
(Invoice_ID)
AP_Terms
(Term_ID)
AP_Recurring_Payments_All
(Invoice_ID)
AP_Terms_TL
(Term_ID)
AP_Batches_All
(Batch_ID)
AP_Holds_All
(Invoice_ID)
AP_Holds_All
(HOLD_LOOKUP_CODE
,RELEASE_LOOKUP_CODE)
AP_Hold_Codes
(HOLD_LOOKUP_CODE
,RELEASE_LOOKUP_CODE)
BankInformationTables
AP_Bank_Accounts_All
(EXTERNAL_BANK_ACCOUNT_ID)
AP_Bank_Accounts_All
(BANK_BRANCH_ID)
PaymentTables
(INVOICE_PAYMENT_ID)
(Check_ID)
AP_Checks_All
(Check_ID)
APAccountingEntriesTables
AP_Payment_History_All
(ACCOUNTING_EVENT_ID)
AP_Accounting_Events_All
AP_AE_Headers_All
(AE_HEADER_ID)
SubLedgerAccountingTables
XLA_EVENTS
(EVENT_ID)
XLA_AE_HEADERS
(AE_HEADER_ID)
XLA_AE_HEADERS
(LEDGER_ID)
GLJournalEntriesTables
GL_JE_Batches
(JE_BATCH_ID)
GL_JE_Headers
(JE_HEADER_ID)
GL_JE_Batches
(JE_BATCH_ID)
GL_JE_Batches
(JE_BATCH_ID)
GL_Balances
(LEDGER_ID)
AP_Bank_Account_Uses_All
(EXTERNAL_BANK_ACCOUNT_ID)
AP_Bank_Branches
(BANK_BRANCH_ID)
AP_Payment_Distributions_All
(INVOICE_PAYMENT_ID)
AP_Checks_All
(Check_ID)
AP_Payment_History_All
(Check_ID)
AP_Accounting_Events_All
AP_AE_Headers_All
AP_AE_Lines_All
(AE_HEADER_ID)
XLA_AE_HEADERS
(EVENT_ID)
XLA_AE_LINES
(AE_HEADER_ID)
XLA_TRIAL_BALANCES
(LEDGER_ID)
GL_JE_Headers
(JE_BATCH_ID)
GL_JE_Lines
(JE_HEADER_ID)
AP_Invoice_Transmissions
(JE_BATCH_ID)
AP_Check_Transmissions
(JE_BATCH_ID)
Purchasing&APInterfaceTableHits
RequisitionInterfaceTables
PO_Requisitions_Interface_All
PO_Req_Dist_Interface_All
PO_Reschedule_Interface
RequisitionInterfaceTables
PO_Headers_Interface
PO_lines_Interface
PO_Distributions_Interface
InterfaceErrorTables
PO_Interface_Errors
ReceivingInterfaceTables
RCV_Transactions_Interface
RCV_Headers_Interface
APInterfaceTables
AP_Invoices_Interface
AP_Invoice_Lines_Interface
AP_Interface_Rejections
AP_Interface_Controls
RequisitionimportInterfaceTablestores
RequisitionHeader,Line&DistributionLevel
Information.
Thatcreatesmultipledistributionsusing
RequisitionImport.
Ittemporarilystoresquantityorneedbydate
changestorequisitionlinessuggestedbyOracle
MasterScheduling/MRP.
TablesStoresPOHeaderLevelInformation.
TablesStoresPOLine&ShipmentLevel
Information.
TablesStoresPODistributionLevelInformation.
Itcontainserrormessageinformationgenerated
bytheopeninterfaceprogramsinOracle
Purchasing.
ItcontainsReceivingHeadersandShipment
Details.Itstoresinformationaboutreceiving
transactionsthatarewaitingtobeprocessedby
thereceivingtransactionprocessororwere
rejectedduetoanerrorwhenthetransaction
processorattemptedtoprocessthetransaction.
ItStoresreceivingHeaderInformation.
Itstoresheaderinformationaboutinvoicesthat
youcreateorloadforimport.
Itstoresinformationusedtocreateoneormore
invoicedistributions.Notethatonerowinthis
tablemaycreate,duringtheimportprocess,more
thanoneinvoicedistribution.
Itstoresinformationaboutinvoicedatafromthe
APInterfacetableswhichcouldnotbeprocessed
byPayablesOpenInterfaceImport.
Itisatemporarytablethatholdscontrol
informationaboutsegregateddata.Thetable
ensuresthateachimportmustbeuniquewith
respecttothecombinationofSOURCEand
GROUP_ID.
ProcuretoPayAccountingEntries
PurchasingModule
Sno. Event
Debit
Credit
1
2
3
CreationofRequisition
CreationofPO
InventoryDestination
Receipts
ReceivingInspectionA/C
InventoryAPAccrualA/C
ExpenseDestination
Receipts
ExpenseAPAccrualA/C
PeriodEndActivity
(Expenseitemswith
receipts)
POChargeA/C
(to)
ExpenseAPAccrualA/C
WhenNextPeriodOpen
(ReversalEntryforstep5)
ExpenseAPAccrualA/C
(to)
POChargeA/C
Note**
AccountingEntriesforInventoryItemscanbecreatedatReceiptsOnly.
WhereasforExpenseitemsitcanbedoneatPeriodend/Receipts.
InventoryModule
Sno. Event
Debit
Credit
Material/InventoryA/C
(POPrice)
DeliveryofInventoryItems
(StandardCosting)
PurchaseVarianceA/CDr./Cr.(asApplicable)
(POPrinceStd.CostDiff)
2
3
DeliveryofExpenseItems
PurchaseReturn
PoDistributionChargeA/C ReceivingInspectionA/C
APAccrualA/C
InventoryA/C
PayablesModule
Sno. Event
1
CreationofInventoryItem
Invoice
Debit
Credit
LiabilityA/C
InvoicePriceVarianceA/CDr./Cr.(asApplicable)
(InvoicePricePoPrice)
2
CreationofExpenseItem
Invoice
ExpenseAPAccrualA/C
LiabilityA/C
PaymentofInvoice
(Inventory/Expense)
LiabilityA/C
CashClearingA/C
DiscountA/C(ifany)
Gain/LossA/C(foreign
exchangeGLifany)
Note**
CashclearingisusedwhenCMmoduleisusedelseitwillbedirectlyhitCash/Bank
accountforpayment.
GoodsReturntoSupplier
(Inventory/ExpenseItems)
RefundthroughCreditMemo LiabilityA/C
APAccrualA/C(or)
ChargeA/C
CreationofPrepayment
Invoices(prepaid)
ExpenseA/C
LiabilityA/C
PaymentofPrepayment
Invoice
LiabilityA/C
CashClearingA/C
ApplyPrepaymentwith
StandardInvoice
LiabilityA/C
PrepaymentA/C
CreationofCreditMemo
LiabilityA/C
APAccrualA/C(or)
ExpenseA/C
LiabilityA/C
InventoryItem:
ExpenseItem:
ExpenseAPAccrualA/C
PurchasingDocumentOpenInterface
(Reference:OracleDocument)
PurchasingOpenInterface:
Steps
Load
Process
Details
PurchasingDocumentsOpenInterface(PDOI)receivesprice/sales
cataloginformationandresponsestorequestsforquotation(RFQs)
electronicallyfromsuppliersintheformofblanketpurchase
agreementlinesorcatalogquotations.
OnewaytoimportcatalogdataintothePurchasingDocumentsOpen
Interface,andfinallyintoPurchasing,isthroughOracleeCommerce
Gateway.
RunthePDOIprogramtovalidateandimportitintoPurchasing.
ThePDOIprogramcanberun,
FromwithineCommerceGatewaywhenyouchooseImport
ProgramfromtheeCommerceGatewayProcessmenu.
Runitseparatelyinpurchasing.
ReceivingOpenInterface:
Steps
Load
Process
Confirm
Details
Thereceivingopeninterfaceisusedtoprocessreceiptsloadedbythe
eCommerceGateway,fromaflatfile(ifbarcodingisused,for
example),orASNsandASBNsloadedthroughtheiSupplierPortal.
AfterreceiptsareloadedruntheReceivingTransactionProcessorto
validatethem.
ReceiptsmustbeconfirmedusingtheConfirmReceiptswindowor
throughanotificationsentbytheConfirmReceiptsworkflowbefore
theycreateaccrualsandcanbedeliveredtotheirfinaldestination.
RequisitionOpenInterface:
Steps
Load
Import
Process
Details
Requisitioncanbeimportedusingflatfile,inventory,OM,MRP,WIP
modules.
WorkinProcess,MasterScheduling/MRP,OrderManagement,and
Inventory(aswellascustomsystems)canproviderequisition
informationforthePurchasingrequisitioninterfacetable.
RequisitionImportcreatesarequisitionlineandoneormore
requisitiondistributionsforeachrowitfindsintheinterfacetable.
Itthengroupstheselinesonrequisitionsaccordingtoparameters
youdefine.YoucancreatereleaseseachtimeyouruntheRequisition
Importprocess.
Purchasingautomaticallycreates(andoptionallyapproves)the
releases
forallblanketsourced,approvedrequisitionsaspartofthe
RequisitionImportprocess,notjustthosecreatedbytheRequisition
Importrun.
Purchasingautomaticallysourcesyourrequisitionlinetoablanket
agreementorcatalogquotationnumberifthesupplierfortheitemis
intheApprovedSupplierListandifsourcingrulesaresetupforthe
item.
OncerequisitionsareloadedintoPurchasing,usetheAutoCreate
form,theCreateReleasesprogramorWorkflowtocreatestandard
purchaseordersorblanketpurchaseagreementreleases.
QuerytogetlistofOpenAPILists
SELECT SUBSTR(A.OWNER,1,20) OWNER

, SUBSTR(A.NAME,1,30) PACKAGE_NAME
, SUBSTR(A.TYPE,1,20) OBJECT_TYPE
, SUBSTR(U.STATUS,1,10) STATUS
, U.LAST_DDL_TIME
, SUBSTR(TEXT,1,80) DESCRIPTION
FROM DBA_SOURCE A, DBA_OBJECTS U
WHERE 2=2
AND U.OBJECT_NAME = A.NAME
AND A.TEXT LIKE '%HEADER%'
AND A.TYPE = U.OBJECT_TYPE
AND A.NAME LIKE 'PO_%API%'
AND SUBSTR(A.TYPE,1,20) = 'PACKAGE'
ORDER BY
A.OWNER, A.NAME;
Note**ChangeNamelikePO_%,PA_%,OM_%etc.
PurchasingAPI:
Hopeyouallenjoyedreadingmymaterial.

Oracle R12 P2P (Procure To Pay) - by Dinesh Kumar S

Uploaded by

Copyright:

Available Formats

Oracle R12 P2P (Procure To Pay) - by Dinesh Kumar S

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Oracle R12 P2P (Procure To Pay) - by Dinesh Kumar S

Uploaded by

Copyright:

Available Formats

What are the main steps involved in the purchasing document open interface?

What are the main steps involved in the receiving open interface?

OracleR12:Procure2PayByDineshKumarS

Supplier Definition and Maintenance

SELECT SUBSTR(A.OWNER,1,20) OWNER

You might also like