Apps To Fusion

.......Our Journey from Apps To Fusion

 
  • Increase font size
  • Default font size
  • Decrease font size



Procure to Pay - Order to Cash - End to End Cycle Functional Documents

Sunday, 15 April 2007 07:38 Sivakumar Ganesan
E-mail
User Rating: / 14
PoorBest 
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 will help you to understand the complete Business Flow of Oracle Application including the accounting flow of Transactions in a Make to Stock Business Scenario

 

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

c)      Order to Cash Cycle – III

 

Your Feedback and information request can be sent to This e-mail address is being protected from spambots. You need JavaScript enabled to view it

 

Regards,

Sivakumar

Comments (120)add
...
written by Hemant , April 15, 2007
Its Just excellent Thanks buddy for putting efforts and sharing it......
report abuse
vote down
vote up
Votes: +2
...
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
report abuse
vote down
vote up
Votes: -1
...
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.
report abuse
vote down
vote up
Votes: +2
...
written by Balaji , April 16, 2007
Thanx to Siva n Anil...
Gr8 attitude in sharing this...
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
written by ajay , April 16, 2007
really it is a good sites
and we got good material
ajay singh mumbai
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
written by Manoj Gupta , April 16, 2007
This is wonderful article.Siva you have made the user guide very concise and small.
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +1
...
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.
report abuse
vote down
vote up
Votes: +0
...
written by S Abdul Hamid , April 17, 2007
Its so nice of you to share such helpful documents. Thanks a lot !
report abuse
vote down
vote up
Votes: +0
...
written by Anupama , April 17, 2007
Thanks for providing such a good material.
report abuse
vote down
vote up
Votes: +0
...
written by Santosh , April 18, 2007
Hi Siva,
This is a great stuff and you certainly have saved some grants for me :-)

Regards
Santosh
report abuse
vote down
vote up
Votes: +0
...
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.
report abuse
vote down
vote up
Votes: +2
...
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.
report abuse
vote down
vote up
Votes: +0
...
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.
report abuse
vote down
vote up
Votes: +0
...
written by Srikanth , April 20, 2007
This is just brilliant, thanks a lot for the documents
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +1
...
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
report abuse
vote down
vote up
Votes: -1
...
written by dd , April 23, 2007
simply gr8
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +1
...
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
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi , April 30, 2007
Have a look at
http://oracle.anilpassi.com/fu...12-2.html

Thanks,
Anil
report abuse
vote down
vote up
Votes: +0
...
written by Arinjay , April 30, 2007
Hi,
Please tell me the difference between customer and party with appropriate example.

Regards,
Arinjay jain.
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi , April 30, 2007
Have a look at
http://oracle.anilpassi.com/fu...12-2.html

Thanks,
Anil
report abuse
vote down
vote up
Votes: +0
...
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.
report abuse
vote down
vote up
Votes: +0
...
written by Mahendra Thakre , May 05, 2007
Great job.Keep it up....
report abuse
vote down
vote up
Votes: +0
...
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,
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
written by Partha , May 15, 2007
Tnx a lot siva for providing such an useful document.
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
written by latha , May 17, 2007
This was a wonderful presentation.
Thanks alot for sharing knowledge.
report abuse
vote down
vote up
Votes: +0
...
written by Prashh , May 18, 2007
A & S u guys rock !!

Thanks for docs !!
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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.
report abuse
vote down
vote up
Votes: -1
...
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.
report abuse
vote down
vote up
Votes: +0
...
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.
report abuse
vote down
vote up
Votes: +0
...
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
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
written by DS Thakur , June 11, 2007
Hi

These documents helped me a lot
Thanks for these documents

Regards
DS Thakur
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +1
...
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
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
written by johnny , June 26, 2007
Hi anil and siva..
These docs are very helpful

thnx
report abuse
vote down
vote up
Votes: +0
...
written by sarath kumar , July 13, 2007
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

report abuse
vote down
vote up
Votes: +0
...
written by Prasanth , July 15, 2007
Pls forward internal po setups.

Thanking you
report abuse
vote down
vote up
Votes: +0
...
written by SaNN KriSS , August 01, 2007
Dear sir,


Thanks for article which were uploaded,This fetched me a lot by self study.I onces again thank u a lot
report abuse
vote down
vote up
Votes: +0
...
written by sarfaraz ahmed , August 02, 2007
Hi Anil,
you are doing a great job. If possible can you upload the OPM cycle tutorial.
Thanks in advance.

Regards,
Sarfaraz
report abuse
vote down
vote up
Votes: +0
...
written by vam , August 02, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by Sivakumar Ganesan , August 05, 2007
Hi

Please check have you set the profile
PO:Allow Requisition Approval Forward Action to Yes at site level.

But from the issue you are describing for me it looks like the document is incomplete.
Go to PR Summary and query for the PR and check the Tools/ View Action History and check the status of the PR. There could be many reason for the PR to be incomplete status.You need to identify the reason and make correction. You will find some Docs in metalink under what circimstances a PR/PO goes to incomplete status.

Hope this helps

Regards
Sivakumar
report abuse
vote down
vote up
Votes: +0
...
written by Narsimlu Vadla , August 06, 2007
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


report abuse
vote down
vote up
Votes: +0
...
written by Vineet Kapoor , August 07, 2007
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

report abuse
vote down
vote up
Votes: +0
...
written by Sivakumar Ganesan , August 07, 2007
Hi

You need to customize your invoice to include purchase_order column from AR.RA_CUSTOMER_TRX_ALL table. But before doing the Customization check whether the column contains data by running a select query.

Regards
Sivakumar


report abuse
vote down
vote up
Votes: +0
...
written by hi anil , August 09, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by kishan , August 13, 2007
Hi Anil,
I have gone through the order to cash pdf , it is a wonderful document .

Thanks alot

Regards,
B.k.kumar
report abuse
vote down
vote up
Votes: +0
...
written by John , August 19, 2007
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
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
report abuse
vote down
vote up
Votes: +0
...
written by Navaneeth , August 23, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by SUHAS A MANUR , August 28, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by Sivakumar Ganesan , August 28, 2007
Hi Navneeth

Your Problem description on set up is not clear

Your requirement can be met as follows


a) In Organization parameter of Master Org / child Org set the Locator Control to
Sub inventory.Set Restrict Subinventories and Restrict Locator at Master Org level for items
b) IN Transaction Org set the Locator control to prespecified only.
Set Restrict Subinventories and Restrict Locator at transaction Org level for items
c) In Subinventories set the Locator control to Item level
d) Go to Item Subinventories and attach the Locator for the item
This should meet your requirement.

Hope this helps

Regards
Sivakumar



report abuse
vote down
vote up
Votes: +0
...
written by Kotha , August 30, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by Pawan , August 31, 2007
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_Add***see := Ne_GET_INTERMED_ADd***sEE_FCN(name_in('LINE.INTMED_SHIP_TO_ORG_ID'));
copy(p_intermed_ship_To_Add***see,'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.


report abuse
vote down
vote up
Votes: +0
...
written by Pawan , August 31, 2007
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_Add***see := NE_GET_INTERMED_ADd***sEE_FCN(name_in(' LINE.INTMED_SHIP_TO_ORG_ID'));
copy(p_intermed_ship_To_Add***see,'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


report abuse
vote down
vote up
Votes: +0
...
written by sai kumar , September 07, 2007
Hi Shiva Kumar,
It is wonderfull document. Many thanks for sharing this document with all.
report abuse
vote down
vote up
Votes: +0
...
written by Ananth , September 08, 2007
fantastic siva. please provide docs like these in all apps financial modules.
report abuse
vote down
vote up
Votes: +0
...
written by Shankha Ghosh , September 20, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by Sarath , September 21, 2007
very Good documents

Rgs
Sarath
report abuse
vote down
vote up
Votes: +0
...
written by sss , September 25, 2007
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.
report abuse
vote down
vote up
Votes: +0
...
written by Hi Pawan, Pune , September 29, 2007
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


report abuse
vote down
vote up
Votes: +0
Oracle Applications Technical Consultant
written by Adarsh , October 03, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by Sravan , October 04, 2007
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.
report abuse
vote down
vote up
Votes: +0
...
written by ramana , October 29, 2007
hi shiva kumar,
thanks for posting such a wonderful documents....


regards
ramana
report abuse
vote down
vote up
Votes: +0
Order management
written by Srikanthus , October 29, 2007
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
report abuse
vote down
vote up
Votes: +1
Procure to Pay - Order to Cash - End to End Cycle Functional Documents
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
report abuse
vote down
vote up
Votes: +0
Procure to Pay - Order to Cash - End to End Cycle Functional Documents
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
report abuse
vote down
vote up
Votes: +0
Process flow in AR Invoicing
written by SilpaC , November 07, 2007
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.

report abuse
vote down
vote up
Votes: +0
Comprehensive Understanding of Apps
written by Jagan Mohan Murthy , November 20, 2007
Thanks for your favour....It is really helpful; atleast for freshers like me....thanks once again
report abuse
vote down
vote up
Votes: +0
Po.Om Functional set up's
written by Maruthi Prasad , November 26, 2007
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
report abuse
vote down
vote up
Votes: +0
Procure to Pay - Order to Cash - End to End Cycle Functional Documents
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
report abuse
vote down
vote up
Votes: +0
Thank you very much
written by Ramu , November 27, 2007
Makes all the pieces to fall in correct place and removes all the confusion of how modules interact. Thank u very much.

Sri
report abuse
vote down
vote up
Votes: +0
Order To Cash - very useful
written by Navdeep , December 04, 2007
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
report abuse
vote down
vote up
Votes: +0
ERP Project Rep. SCM & eAM
written by Geepee , December 10, 2007
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
report abuse
vote down
vote up
Votes: +0
AR Module Case Study
written by Hemant Sathe - Pune , December 20, 2007
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

report abuse
vote down
vote up
Votes: +0
...
written by new-user , December 22, 2007
Thank you so much !
report abuse
vote down
vote up
Votes: +0
Systems Analyst, Quest America Inc
written by Karthikeyan Dhinakaran , January 23, 2008
Anil / Shiva,

Great Stuff. Very useful for technical folks to understand process.
report abuse
vote down
vote up
Votes: +0
procure to pay
written by Deeps , February 08, 2008
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.
report abuse
vote down
vote up
Votes: +0
Order Management API :- OE_ORDER_PUB
written by Dinesh , April 11, 2008
Hi Shiva,
I read your articles on P2P,OTC. They are really knowledgable and helpfull. I would like to request if you can give us a brief description on Order Management API's. I did go thru some of the oracle provided documents. But I still need your helping hand. Please can you help.

Thanks
Dinu
report abuse
vote down
vote up
Votes: +0
...
written by newlaptopuser , April 12, 2008
Sivakumar,

Thank you very much for sharing your great knowledge with us.

Regards
Nathan.


report abuse
vote down
vote up
Votes: +0
...
written by Naveen Kumar Mauwala , April 23, 2008
Hi Siva,

U r great boss !!!

I am facing problem in matching the prepayment:

I have made prepayment in USD, but my Invoice is in INR, so when i m trying to match the prepayment to the Invoice the LOV doesn't show the available prepayment.

Will u please help me in resolving the below issue.

Thanks in Adavance
Naveen
report abuse
vote down
vote up
Votes: +0
Great job
written by Anshul singhal , June 11, 2008
Hi Siva kumar, this is simply superb effort from you. Can you please provide some docs of ATO/CTO/PTO items too with the major difference among them. As per my experience understanding the difference between then is the major issue.

I really appreciate your efforts.

Thanks,

Regards,
Anshul singhal
report abuse
vote down
vote up
Votes: +0
thanks
written by anujtyagi1 , June 12, 2008
Hi shiva,
really a marvellous job done.This is really a superb job done for the people who are in the problems of solving their queries. can you also provide the same type of documents of internal sales order,approva hierarchy, BP40,BP80,MD50,BR100,BR110 doc.
Thanks and regards
Anuj tyagil
report abuse
vote down
vote up
Votes: +0
Excellent work
written by Ranu , June 15, 2008
Impressed by simplicity of presentation & choice of business case to explain not so simple orader to cash :-).Thanks for helping the community.
report abuse
vote down
vote up
Votes: -1
Process Manufacturing
written by whelan , June 17, 2008
Hi Shiva, Great work! Can we expect a similar work from you on OPM as well. That will be a great help for all of us.

Thanks, Linda.
report abuse
vote down
vote up
Votes: -1
Amazing
written by Manpreet , July 18, 2008
I think until we see the big picture we cannot appreciate what each module is doing independently. Thanks to you to depict the entire flow. I am really addicted to this site

I have a favor to ask, please share some more case studies with us.

Regards

report abuse
vote down
vote up
Votes: +0
awesome
written by Bommudurai , August 08, 2008
Dear siva,
excellent materila and your effort for preparing of these documents highly appreciated.


Bommudurai
report abuse
vote down
vote up
Votes: +0
Great Job
written by AKJ05 , October 09, 2008
Hi Shiva

These docs are just a funtastic for learning point of view and helped me great to switch over as Functional consultant. Thanks a lot for sharing your experience with us.

Ajay
report abuse
vote down
vote up
Votes: +0
Problem Here
written by Amit Saroha , October 18, 2008
Hi Shiva

There is a problem when i am try to book a order for a customer then I got a note message that hold on sales order against this customer.

From where i should remove this hold..?

I tried every thing possible .

Or this is a task of sys admin ?
report abuse
vote down
vote up
Votes: +0
...
written by johnny , December 05, 2008
Hi Sivakumar,

Thanks a lot for providing these documents.
These documents gives a very clear idea.

Thanks,
Johnny

report abuse
vote down
vote up
Votes: +0
Good explanation
written by Naveen Gaddam , January 03, 2009
Siva,

Great work ! well explained.

Thanks
Naveen
report abuse
vote down
vote up
Votes: +0
Oracle Consultant
written by ARAM , May 15, 2009
Hi Siva,

Superb!!!!!!!!!!!!!! Well explained

ARAM


report abuse
vote down
vote up
Votes: +0
Oracle Tech Dev
written by rvenkat , May 27, 2009
The documents very useful for me..

Thanks a lot siva
report abuse
vote down
vote up
Votes: +0
...
written by Amit Sarkar , June 03, 2009
Hi Siva

Nice document, it will help me a lot.
Well explained.

Thanks
Amit

report abuse
vote down
vote up
Votes: +0
Thanks for sharing the Document.
written by GVREDDY , August 18, 2009
Hi Shiva,

I read your articles on P2P,OTC. They are really knowledgable and helpfull. I would like to request if you can provide me the same in R12.

Thanks,
venkat
report abuse
vote down
vote up
Votes: +0
problem
written by Vijay Upadhyay , October 27, 2009
Hi Anil/shiva,

I am very new to oracle apps I am trying to follow and understand the P2P. But there is one problem when I am creating sales order in order management then there is on mandatory feild called "order_type" is not coming in my system. In your Pdf file that feild is filled with text 'Mixed'. but in my system LOV contains no value and I am not able to fill the value in that LOV. Please guide me eagerly waiting for your precious reply. Please reply sooooooooooooooooon.


Thanks in advance,
Vijay Upadhyay
report abuse
vote down
vote up
Votes: +0
consultant
written by snimbs , May 27, 2010
great work dude ! ! !
keep posting
report abuse
vote down
vote up
Votes: +0
Excellent
written by Pavan Kumar Chowdary , July 29, 2010
U had made an excellent work...
Thank You so much
report abuse
vote down
vote up
Votes: +1
akashs
written by jaideep valani , December 31, 2010
Hi..Shiva I was trying to execute the First document which says creation of Inventory items..
I created the required items as

CPU subassembly
Flopyy Drive
Mother Board
Finished Good

But when i was trying to assign the Finished good item to a Price list i was not able find the created item..
I tried to view the Folder query
Product_attribute_Context = 'ITEM'
AND EXISTS (SELECT '1' FROM MTL_SYSTEM_ITEMS mtl WHERE product_attr_value = mtl.inventory_item_id AND mtl.organization_id
= (SELECT FND_PROFILE.value('MFG_ORGANIZATION_ID') FROM Dual) AND product_attribute= 'PRICING_ATTRIBUTE1'
UNION

SELECT '1' FROM dual WHERE product_attribute != 'PRICING_ATTRIBUTE1')


and (LIST_HEADER_ID=22367)

It was like.. the value of the QP_ORGANIZATION_ID was coming not equal to the org id that I choose to create the Items in

Any suggestions ?
report abuse
vote down
vote up
Votes: +0
MR
written by amitpal , May 20, 2011
Hi anil n siva,

Actually i am implementing ur docs to learn the p2p n o2c but i am facing a problem regarding whn i am receiving the PO it is not showing me in the on hand quantity of my inventory and in the transaction status summary it is showing an error .
RVTII-060: Subroutine INV_TXN_MANAGER_PUB.process_Transactions() returned error

Cause: Subroutine INV_TXN_MANAGER_PUB.process_Transactions() returned an internal error.

Action: Note this error number and the actions you a

Plz Help me out asap
Thnx
report abuse
vote down
vote up
Votes: +0
Reg:-Fixed Assets Depriciation
written by Subramanyam.thanjore , August 01, 2011
Sir,

After running depriciation can it be rolled back again if found any mistake
report abuse
vote down
vote up
Votes: +0
Write comment
quote
bold
italicize
underline
strike
url
image
quote
quote
smile
wink
laugh
grin
angry
sad
shocked
cool
tongue
kiss
cry
smaller | bigger

security image
Write the displayed characters


busy
< Prev   Next >
Last Updated ( Thursday, 05 July 2007 15:26 )  

Search apps2fusion