Procure to Pay - Order to Cash - End to End Cycle Functional Documents |
Written by Sivakumar Ganesan | |
Sunday, 15 April 2007 | |
I am pleased to introduce to you Mr. Sivakumar Ganesan. Siva is an Ex-Oracle Employee, and he has vast knowledge in Order Management, P2P[Procure to Pay], Manufacturing and Order to Cash. Please find a set of three wonderful articles from him that cover end to end implementation steps for P2P, Order to Cash and much more. If your aim is to become a Functional Consultant in Oracle Financials, then simply follow his step by step instructions on a Vision Environment. My sincere thanks to Siva for sharing with us the wealth of knowledge that he has.
This document covers the following A. Business Case 1) Creation of Items 2) Setting up Selling Price for an Item 3) Define Customer 4) Creation of Sales Order 5) Enter Item Costs 6) Define Resources 7) Define Departments 8) Define Routing (CPU Sub assembly) 9) Define Bill of Materials (BOM) CPU Sub assembly 10) Define Routing (Dell Computer) 11) Define Bill of Materials (BOM) (Dell Computer) 12) Define Suppliers 13) Enter Purchase Requisitions 14) Create Purchase Orders 15) Enter Receipts (Inventory Receipt) 16) Auto-create Supplier Invoice 17) Create, View Invoices and Make Payments in Payables 18) Payments Reconciliation 19) Create, Release, Complete, Close Discrete Job for CPU Subassembly 20) Create, Release, Complete, Close Discrete Job for Dell Computer 21) Sales Order Booking, Releasing, Ship Confirm the Finished Goods 22) Run Auto invoice 23) View Sales Invoice, Create Receipt, Remittance and view Account Balances 24) Receipt Reconciliation
This Document has been broken to three parts owing to the size of the document is very huge. Hence readers are requested to read the Document Links in the following Sequence to understand the complete flow of Transactions a) Business Case Study and Set up in Oracle Applications – I b) Procure to Pay and Manufacturing Cycle – II
Your Feedback and information request can be sent to sivakumar3009@gmail.com
Regards, Sivakumar Comments
(97)
![]() ![]() written by Hemant , April 15, 2007
Its Just excellent Thanks buddy for putting efforts and sharing it......
![]() written by Giridhar , April 16, 2007
Hi,
Its not opening Business Case Study and Set up in Oracle Applications I part. Please check it. Remaing to are very useful and looks good. Thanks ![]() written by Bala Chandra Sekhar , April 16, 2007
Hi Sivakumar,
Good documents provide for P2P and OTC, I am Technical consultant, these documents make so understandable for my daily work. Thanks & Regards, Chandu. ![]() written by Balaji , April 16, 2007
Thanx to Siva n Anil...
Gr8 attitude in sharing this... ![]() written by Arulselvan , April 16, 2007
Very cute info and more understandable things are P2P and OTC Which you have provided.Thanks for your sharing ideas
i would like to convey my wishes to Anil and Shiva Thanks&Regards Arulselvan ![]() written by ajay , April 16, 2007
really it is a good sites
and we got good material ajay singh mumbai ![]() written by Dharam Singh , April 16, 2007
Thanks Siva,
It was a great effort from your side to make such type of documents which are really very helpful. These are very handy documents. Thanks again for sharing such information. Dharam ![]() written by Anil Passi , April 16, 2007
Hi giri
Please can you ask a colleague of yours to open it It is opening from this end Thanks A ![]() written by Manoj Gupta , April 16, 2007
This is wonderful article.Siva you have made the user guide very concise and small.
![]() written by Srikanth , April 17, 2007
Hi Anil & Siva ,
These documents really make the Oracle mountain scalable. The visuals especially make it even simple. Please continue ur great work. Thank you, Sri ![]() written by BasavanaGowda , April 17, 2007
Hi Sivakumar Ganesan,
I m very greatfull to u.. This document is very usefull for the beginer Thank U .... B.Gowda ![]() written by Keyur Joshi , April 17, 2007
Dear Siva and Dear Anil,
People like you are an asset to Oracle apps community. Pl. keep up the good work. and continue helping people. Thanks a lot. ![]() written by S Abdul Hamid , April 17, 2007
Its so nice of you to share such helpful documents. Thanks a lot !
![]() written by Anupama , April 17, 2007
Thanks for providing such a good material.
![]() written by Santosh , April 18, 2007
Hi Siva,
This is a great stuff and you certainly have saved some grants for me :-) Regards Santosh ![]() written by Ravi , April 19, 2007
Hi Siva,
Thanks for sharing the documents. These documents would certainly help me to switch over to Functional side. Thanks&Regards Ravi. ![]() written by Mahadev Rege , April 20, 2007
Hi Siva & Anil,
Many thanks for this wonderful article. I wanted to know where I can find info on the exact mapping between columns in OE in 11.0.3 and 11.5.10 in ONT (Order Management). For eg. what are the S columns i.e S1, S4, S6 in SO_HEADERS_ALL and S9,S28,S27 .. in SO_LINES_ALL in 11.0.3 called in 11i in OE_ORDER_HEADERS and OE_ORDER_LINES. or are these columns taken away due to the functional change. ![]() written by Mahadev Rege , April 20, 2007
Hi Anil
Many thanks for your prompt reply. We have done the Migration from 11.0.3 to 11i. But we have customizations which we need to take across. For the moment for e.g we are using columns like shipping quantity, shipping_number in 11i to validate against columns like S4 etc. Thanks again. Regards Mahadev. ![]() written by Srikanth , April 20, 2007
This is just brilliant, thanks a lot for the documents
![]() written by emmanuel , April 20, 2007
Hi Anil,
Thanks a lot to you and Shivakumar for that wonderful document you have made available to all. I really appreciate that. When you get a chance can you give some tips on emailing to a group and printing to a printer by using XMLPublisher. Any kind of info will be helpful. Thanks Agian. Emmanuel ![]() written by Sivakumar , April 21, 2007
Hi All
Thanks to all of you for your feedback. I will prepare and post a document for accounting entries for the P2P and O2C cycle also. But I need sometime and prepare and complete it.I will do it asap and do the needful. Regards Sivakumar ![]() written by S.Grace Paul Regan , April 22, 2007
Hi Buddy,
The job you did was really great, I am too a Functional Consultant for manufacturing and distribution modules. I will also be very happy to share my knowledge with all. Thanks & Regards, S.Grace Paul Regan
simply gr8
![]() written by lobo , April 24, 2007
I wish to Thank you and your team for all the efforts in helping the consultants to understand the functionality in a crystal clear manner. Your efforts are highly appreciated and hoping the same in forth coming materials.
Thanks & Regards Lobo ![]() written by Sivakumar Ganesan , April 26, 2007
Hi Ramesh
Please look into Metalink Note#427556.1 This contains a sample code and the contact person e-mail also if you need any input. I would like to inform to others the Oracle Customer Knowledge Exchange in Metalink contains lot of good articles and all of us can make use of it also Regards Sivakumar ![]() written by Devesh , April 27, 2007
Hi shiva,
Thanks a lot for ur wondurful presentation. it is indeed a useful and Excellent Documentation. Regards Devesh ![]() written by Saroj Kumar nayak , April 28, 2007
I have been working with TCS in Oracle Application since last 5 years as techno functioinal.Have gone through many docs but this is the complete one .I run short of words to praise the documents you have prepared . Simply wonderful . Expecting some more on core Financial from functional point of views. Cheers S K Nayak
![]() written by Anil Passi , April 30, 2007
Have a look at
http://oracle.anilpassi.com/fu...12-2.html Thanks, Anil ![]() written by Arinjay , April 30, 2007
Hi,
Please tell me the difference between customer and party with appropriate example. Regards, Arinjay jain. ![]() written by Anil Passi , April 30, 2007
Party is just about any entity with which your organization has any kind of direct or indirect relationship. For example and Employee, a visiting Consultant etc
However, usually you will register a party to become a customer, only when your Receivable departments desires to invoice[or credit] them for some services Thanks, Anil Passi ![]() written by Anil Passi , April 30, 2007
Have a look at
http://oracle.anilpassi.com/fu...12-2.html Thanks, Anil ![]() written by Rajat , May 03, 2007
Hi..
The document provided are simply superb. Thanks a lot for sharing knowledge. Anil, is there a place where we can get the solution for general issue in Apps pertaining to production support for distribution, manufacturing modules. ![]() written by Mahendra Thakre , May 05, 2007
Great job.Keep it up....
![]() written by himanshu , May 09, 2007
Hi, I am not able to open to any of the following documets:
a)Business Case Study and Set up in Oracle Applications I b)Procure to Pay and Manufacturing Cycle ֖ II c)Order to Cash Cycle III i am getting the error that the doc doesnot start with PDF. Thanks, ![]() written by Anil Passi , May 09, 2007
Himanshu
Sorry to hear that Please try from some other PC. May be something to do with ur security settings You can also right click and save the docs onto your PC Thanks Anil ![]() written by Rajesh , May 10, 2007
HI Sir,
I found this pdf extremely useful.It clears the concepts and gives a good knowledge of the cycles. Thanks a lot, Rajesh ![]() written by M.Sattar , May 15, 2007
HI Siva,
The information which you provided is very helpful.You people are doing a great job by providing these type of valuable information. Thanks for sharing the valuable information. Regards, M.Sattar
Tnx a lot siva for providing such an useful document.
![]() written by Jothees Kumar Nair , May 17, 2007
Hi,
A very useful document of end users. really good. Convey my thanks to Shiva and ask him to post documents like this. Anil can you tell me how the invoice matching option will work in 11i (2 Way, 3Way and 4 way) with some examples Jothees Nair ![]() written by latha , May 17, 2007
This was a wonderful presentation.
Thanks alot for sharing knowledge.
A & S u guys rock !!
Thanks for docs !! ![]() written by Sachin Ahuja , May 19, 2007
Hi Sir,
Really the Effort put into the documents is commendable. Can we have same Kind of Documents on GL AP and AR. I am in bad need of them. Thanks Sachin ![]() written by sreenivasareddy , May 21, 2007
HI ,
I am a technical Guy, am new to oracle Applications. i want some documents like P2P, O2C , Reports, PL/Sql documents, interveiw questions. can u please send me those documents ASAP. Regards, Sreenivasa Reddy ![]() written by bramha , May 22, 2007
hi this is bramha
the document o2c provided is nice if u dont mine pls send questions in om module thanks a lot regards bramha ![]() written by Lakshmi kanth , May 23, 2007
Hi anil,
I am lakshmikanth working in patni.I prepared my own implimentation book.But your document is really great.simply great.I learned from u how to prepare a document. Regards Lakshmikantha Reddy. ![]() written by Santosh , May 28, 2007
Shiva,
I have defined an item in inventory and assigned it to particularly org where im going to create the sales/make order. However, when querrying for the item defined.Im unable to find or search the item while placing the order. Any help is greatly appreciated. ![]() written by Amol , May 28, 2007
Hi Shiva,
I am a Functional Consultant working primarily on Procurement & Order Management. All the three documents are really very good. However, please let me know, if you have any document for setting up the Enterprise Strcuture viz. setting up OU, SOB, LE, Inventory Org Etc. Thanks & Regards, Amol. ![]() written by Uma , June 05, 2007
Hi SivaKumar,
Nice to see the documents, and its really a good effort by you and highly appreciatable for your documents. In the Order Management, when we run the workflow background process program, there is a parameter to be given called as Process Deferred set to Yes can u please explain about this parameter, why shud we give this to yes? Regards, Uma umag2005@gmail.com ![]() written by pandit , June 09, 2007
hi
i am learning APPS and youe site is very useful i would like to know if you can provide the details about financials module like you are providing for HRMS i.e covering the basics of GL,AR,AP etc one more thing i would like to know whether to go for Finacials or HRMS regards ![]() written by Anil Passi , June 10, 2007
Hi Pandit
You should try to learn both Financials and HRMS/Payroll. The costing process in Payroll transfers details to General Ledger. Hence even if you wish to specialise in HRMS/Payroll, basic level of knowledge in Oracle GL is a must. Thanks, Anil Passi ![]() written by DS Thakur , June 11, 2007
Hi
These documents helped me a lot Thanks for these documents Regards DS Thakur ![]() written by rajesh , June 17, 2007
Hi Anil,
I need some help from you in ipayments. I have a requirement wherein I need to pass either level 2 or level 3 based on a dff value during settlement stage of credit card/purchase card transaction. Currently when we run Batchclose , it generates a xml file in the pickup directory. I need to customize this to send either level II or level III data. Kindly let me know if you have any idea how to go ahead with the customization. Regards, Rajesh Khatri ![]() written by Anil Passi , June 19, 2007
Hi Rajesh
Which process is creating the XML file? Is XML Gateway being used?, in which case XML Message Map needs to be modified. In think in R12 there is integration with BPEL which is where XML is generated. But before jumping onto the modification, its worth investigating if Oracle has made some provision to include DFFs by means of some configurational change. Do let me now the XML generation process, I will have a look Thanks, Anil Passi ![]() written by Nihar , June 20, 2007
A great work done by you.very helpful.I am new to ERP just started for working in INFOSYS.Could you please send some document for IMPLEMENTATION as my cuurent assignment is out of scope to learn this.Please send some useful document so that it will be very handy for all of us to leaer implementation also.
Thanks Nihar ![]() written by Madhavi , June 25, 2007
Hi Anil
I am learning Oracle Financials, your site is helping me a lot thank you. I am working on Procure to Pay and Manufacturing Cycle and i am unable to update th rollup costs and create a discrete job. I went over the process couple of times but unable to resolve. What could be the mistake? Thank you, Madhavi ![]() written by johnny , June 26, 2007
Hi anil and siva..
These docs are very helpful thnx
Hi,
pls forward me the set up document for quality module, and pls send me the docs for one complete cycle thanks in advance sharath
Pls forward internal po setups.
Thanking you
Dear sir,
Thanks for article which were uploaded,This fetched me a lot by self study.I onces again thank u a lot
Hi Anil,
you are doing a great job. If possible can you upload the OPM cycle tutorial. Thanks in advance. Regards, Sarfaraz
HI Siva,
Thanks for such good doc on oTC and P2P..........I have a issue.....whenever I try to creae a requisition and approve it..............no pop up screen comes as shown in u r doc and requisition is not approved..........can I know whats the reason.......I set up myself as buyer too.....Can u pls help me out.....Is there any set ups I need to look around....please advice
Hi anil and siva..
These docs are very helpful,apart from this, i need some help from you, i unable to print the Customer PO number on the invoice, for this what setups we need to do, as per my knowledge there are no perticulor setups for this, any how please give me the solution. thnx Vadla
Hi,
Business Case Study and Set up in Oracle Applications – I is not opening properly.Can you send me the above memtioned doc on mail. However the other two documents are very good. Hats off to you for sharing the knowledge Rgds Vineet
hi anil ,
thanks a lot 2 u . ur web-site is really helpful for me. and ineed backend tables in such a manner like Po_headers_all. gl, ap, ar likr all tables wat r all there pls help me on this thank you any body also can do this favour
Hi Anil,
I have gone through the order to cash pdf , it is a wonderful document . Thanks alot Regards, B.k.kumar
Hi Siva & Anil,
Thank very much for thoes wonderful doc. As I understand, they are for Discrete Manufacturing Cycle. Am I right ? Can they are used in Process Manufacturing ? If not, can you prove us similar doc for Process Manufacturing Cycle too ? I copy a Comment from Sarfaraz in b) Procure to Pay and Manufacturing Cycle – II here: ... If possible can you upload the OPM cycle tutorial. Thanks in advance. John johnzha@yahoo.com
Dear Siva
I have a question on Enabling Locator Control. I have enabled Locator Control with prespecified only option. I have enabled it with the following options: 1) Restrict Subinventories and Restrict Locators at Master Level 2) Restrict Locator and Restrict Subventories to be restricted at predefined level 3) Checked Restrict Locators and Restrict Subinventries in the Master Items Screen 4) Assigned Locators for every item Even then, when i do a transaction, Item Locator is not coming automatically, I need to manually select the locator for all items. Can you pls tell me the step that I have missed to get the Item locator to come automatically, while doing a transaction. Greatly appreciate your reply. Thanks & Regards, Navneeth
Dear Siva ,
Wonderful.. wonderful very very useful document. Many many thanks. As I am new to Oracle Apps., I would like to know about the "LOT CONTROL" and "LOCATOR CONTROL". I request you to please help me and obliged. With Regards, Suhas
Wonderful article........I have an issue in OM......Need some suggestions.......There is custom form at line level in OM....if line splits bcos of back order the new line doesn't have the information of the form attached to it....how to copy additional information to new line without use of database triggers.....any suggesstions....
Thanks in Advance
Hi ,
I'm sending you again the issue. I have one issue in sales order form in lines block(other tab). I added column intmed_ship_to_location.in intmed_ship_to column has lov attached. i'm selecting intmed_ship_to loke(10072DE).on the basis in another field means intmed_ship_to_locationshould be apeear like as name.Now i'm using custom.pll block='line' and event='when-new-item-instance'. IF (Block_name = 'LINE' and event_name ='WHEN-VALIDATE-ITEM' ) THEN p_intermed_ship_To_Addressee := Ne_GET_INTERMED_ADDRESSEE_FCN(name_in('LINE.INTMED_SHIP_TO_ORG_ID')); copy(p_intermed_ship_To_Addressee,'LINE.INTMED_SHIP_TO_LOCATION'); ---- END IF; when i select value for intmed_ship_to and click on that item.then location name come, intmed _ship_to_location is not store in database. when i again query the same order what i see the same value is appering in intmed_ship_to_location like intmed_ship_to(10072DE). Please also let me know can i do this by form personalization. Thanks in advance.
Hello Sir,
I have one issue in sales order form in lines block(other tab). I added column intmed_ship_to_location.in intmed_ship_to column has lov attached. i'm selecting intmed_ship_to loke(10072DE).on the basis in another field means intmed_ship_to_locationshould be apeear like as name. I'm using custom.pll with following code. IF (Block_name = 'LINE' and event_name ='WHEN-VALIDATE-ITEM' AND NAME_IN('SYSTEM.TRIGGER_ITEM')= 'LINE.INTMED_SHIP_TO') THEN p_intermed_ship_To_Addressee := NE_GET_INTERMED_ADDRESSEE_FCN(name_in(' LINE.INTMED_SHIP_TO_ORG_ID')); copy(p_intermed_ship_To_Addressee,'LINE.INTMED_SHIP_TO_LOCATION'); ---- END IF; intmed _ship_to_location is not store in database. it's display item. when i again query on the same order what i see the same value is appering in intmed_ship_to_location that is avaliable in intmed_ship_to. like intmed_ship_to(10072DE). Please give me the suggestion for this issue.I have been tried all event that is needed in Custom.pll
Hi Shiva Kumar,
It is wonderfull document. Many thanks for sharing this document with all.
fantastic siva. please provide docs like these in all apps financial modules.
Hi Siva
first and foremost would like to thank for the wonderful articles on the Case Study (P2P and O2C). Till date i failed to find a single basic document which depicts entire flow , and it is extremely difficult task to "Data Mine" User Guides to figure out flow/link between modules. Further those who know the flow does not seem to bother to document/discuss the same , at this point you stand out sharing your knowledge. Hope to contribute to your articles/blog Regards Shankha
very Good documents
Rgs Sarath
Hi Shiva,
In thanks for your wonderful documents on Order to Cash. Here I have a doubt i.e when I releasing an order it's going for BACKORDER status, what were the reasons for this? Thanks in advance.
Hi Shiva
Nice to c ur suggestion its a good help for people in oracle apps. I have just join a company how r oracle apps partner n working as a Distribution consultant ur document helped me a lot 1 suggestion if u can add some problems with there soutions that vil be great regards Pawan
Hi
The document is really very helpful but it can be more useful when it should contain table manipulation also ie for evey step in cycle which table is manipulated the name and columns should be there it will be very helpful to newcomers to understand table manipulation and linking at back-end so kindly mentioned that part also and reproduce the documents this will be a great task ever done in this area. Thanks & Regards Adarsh Bharadwaj
Hi Siva,
Thanks for providing such a wonderfu document. If possible can you provide or suggest a way wherein i know the details of concurrent programs that run at that particular process. And also if possible please get us about CRM modules like Service Contracts, Field Service, Install base etc. Once again thanks. Regards, Sravan.
hi shiva kumar,
thanks for posting such a wonderful documents.... regards ramana
Hi Sivakumar,
The Document ( P2M, O2C) you have provided is excellent to understand for begginers like me. I am trying to relicate the same instance as provided by you in ur document with the same steps everything is fine , but i am stukc while entering the sales order, while i am entering in the line items the ordered item is not getting populated, kindly help me out to resolve this. Would appreciate your valuebale help. Thanks & Regards Srikanth ![]() written by Kumar P , November 05, 2007
Hi Siva,
For a long time, I was looking for these documents (O2C, P2P). Your documents are realy fabulous,Siva. Thanks a lot for sharing your experience. Regards, Kumar P ![]() written by Kumar P , November 05, 2007
Hi Siva,
I would like to thank you for your (O2C, P2P) documents. It is really fabulous, for a long time I was looking for such document to understand the flow of O2C and P2P. Once again, thank you very much. Regards, Kumar P
Great work...its relly helpful.
I would like to know the process flow in AR invoicing.Kindly help me out. would appreciate for your valuable help and knowledge transfer.
Thanks for your favour....It is really helpful; atleast for freshers like me....thanks once again
Can u Please send me the Po,Om Functional set up's that may help me in my work a lot
Thanks Ganesh & Anil For ur Work ![]() written by Devan , November 26, 2007
No words. Great effort. Keep it up. Wonderful work. Really helpful for newbbies and seniors too. Seniors please come forward for Vidya Dan.
Devendra
Makes all the pieces to fall in correct place and removes all the confusion of how modules interact. Thank u very much.
Sri
I am really thankful to you for a very summarised document. Now I am looking for some document for setup of O2C module. If you have setup summarised doc, please send it to me.
Regards Navdeep
Dear ,
Great job. Could you pls. suggest, where I can find similar flows or functions for SCM & eAM Modules, If you have suggested links, pls. provide. Thanks .. Gepe
Hi
My Name is Mr. Hemant Sahte, just recently I have completed oralce Techno -function course. I have done two module GL & AP. Presntly having with me sufficient material note of these module. I am also interested in others three module AR & cash Management and fixed Assets. But I did not get student related material notes. Can you suggest me the website or oracle related books. This will be help in training. Awaiting your positive reply Warms Regards Hemant Sahte
Thank you so much !
Anil / Shiva,
Great Stuff. Very useful for technical folks to understand process.
Hi Shiva,
Thanks a lot for the doc of procure to pay really these are very use to me & all oracle apps consultants i learn more from these doc, shiva pls i request you also give the all details of setup of inventory and PO bcoz in this doc. only complete process is define i wanna understand the all steps of po setups i will highly thankful to you. Thanks & Regards Deepak. You must be logged in to a comment. Please register if you do not have an account yet.
|