Answer / maruthi

order mangement deals with order to cash

first we have to enter the order
order returns----sales order

we have to enter the order in headers snd lines information
when we enter the order it shows entered in both headers
and lines
after that we have to book the order
after entering it shows booked in headers and awaiting
shipping in lines
it shows the release status --R means ready for relaese
after that we have to do pick release
when picked it shows booked in headers in headers and
picked in lines
it shows the flow status code changes from R to Y means
Pick Confirmed
in the back ground two concurrent will run
1) Pick Slip Report
2) Shipping Exceptions report
After that we have to do shipping
while shipping the flow status code will change from Y to C
means Ship Confirmed
in the background it runs 5 Concurrent programs
Automatically
1)Bill of Lading
2) Commercial Invoice
3)Packing slip Report
4)Interface trip stop
5)Vehicle load sheet Details
After that we have to run the workflow Background Program
After that we have to do the Invoices
After that we have to do the receipts
After that we will transfer it in to General Ledger
Transform Program

Tell me some interface tables on ordermangement.

1 Answers   Zensar,

---

1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?

2 Answers   Cap Gemini,

---

what u did after ur btech(2009) till now? why did u prefer oracle apps technical?

1 Answers   Intelligroup,

---

What should be the batch size (number of customer records) general guidelines for optimal performance?

1 Answers  

---

Can u attach Request set with in the Request set?

2 Answers   Satyam,

---

---

What is Pragma Autonomous transaction. It's Real time Example

4 Answers   IBM,

---

What is REF Cursor?

19 Answers   Infosys, Intelligroup,

---

WHAT IS REFCURSOR IN ORACLE ?

6 Answers  

---

How many schemas we have? how many you have used?

0 Answers  

---

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

0 Answers  

---

How you will Diaplay the Company LOGO In report.Can anyone knows please give solution

8 Answers   TCS,

---

link between po and ap modules

5 Answers   ERP Solutions,

---