![[Google]]( http://www.jdesource.com/wp-content/plugins/easy-adsense-lite/google-light.gif)
Following are the links to the Oracle JD Edwards EnterpriseOne Documentation. Earlier called as Peoplebooks.
All the following documentation are available for offline use as PDF files too.
Application (Functional) Guides
- JD Edwards EnterpriseOne Xe
- JD Edwards EnterpriseOne ERP 8.0
- JD Edwards EnterpriseOne 8.9
- JD Edwards EnterpriseOne 810
- … Many more
Technical / Tools guides & others available too.
Click here to view the complete list.
Author : 
Hi,
Using DOC, DCT, KCO i want to fetch MCu, SUb, OBJ. if a one doc no has more than MCU, OBJ, SUb. for that i used fetch next. Now the problem is it fetches only the last line. how to execute the process please any one explain me.
Below is my code:
F0911.select
KCO=KCo1
DCT=DCT1
DCO=DCO1
F0911.Fetch NExt
MCU-> MCU1
OBJ->obj1
SUB->sub1
while SV _file_I_O_status = Co sucess
f0911.fetch next
endwhile
f0911.close
What is it that you are trying to accomplish? I mean what is the objective with getting different MCU, OBJ, SUB? Do you want a count of all the Accts? or Do you want to display? or do something else?
Is the code in UBE or App?
Hi Deepesh,
I am trying this code in UBE. I want to display the differenct MCu, Obj, Sub i am getting.
For eg.
For DOc 7001526 DCT OT KCo 00130
for this input i am getting
DOc DCT KCo MCU OBJ Sub
7001526 OT 00130 130 0001500 0101
7001526 OT 00130 130 0001501 0101
7001526 OT 00130 130 0001500 0101TD
now i want to display these three lines for doc no 7001526.
Please advice.
If writing in a UBE, I suggest you create a new section on F0911. with Data seq – DOC, DCT, KCO, MCU, OBJ, SUB. Put Level Break on all six.
Now on the LB Footer of SUB, print all the six fields. This will sort on DOC, and then show all the MCU.OBJ.SUB for the DOC.
If the Dataselection is set for a single DOC no: (eg 7001526), then that single DOC will have all the DIFFRENT MCU, OBJ, SUB printed off in that section.
Please i need some help, scenario is
Table Structure is Like this,
FY PN ITEM SOLDQTY BEGQTY
10 1 A 200 300
10 2 B 300 250
10 3 C 50 960
User Input is like this FY,PN and another PNM(Movement cosideration):
For Eg: IF FY =10 , PN = 3 and PNM= 2 , then output should accumulate
the data for Month 2 and Month3 ..SO with that accumulation i need calculate average
BEGQTY SOLDQTY
Product Line Item Month2 Month3 Month2 Month3
Aluminium A101 250 960 300 50
How to accumulate as above Template from the table i had mentioned before
i tried with taking Cnt = PN-PNM our Eg , 3-2=1 ,so Cnt=Cnt+1 ,then
Inside While Loop i had Accumulated…
Is there any simple way …please advice
Hi Niranjan,
I did not understand how do you want to accumulate. The Values shown for BegQty (m2, m3), Sold Qty (m2, m3)can be retrived using table io.
Thank you for your comment but, in my scenario, i am derving this DOC, DCT, KCo from an RMk field our user feed this DOC/DCT/KCo in the rmk field then i spilt up into separate fields then i put in f0911 fetch to get MCu, OBJ,SUB.
As I said, Create a NEW section on F0911, and call that section with the splitted values set as data selection instead of Select-FetchNext.
If you are keen on using Select-FetchNext, you will still have to create a New section for Printing off the values being fetched. In this case you will have the following code
F0911.selectKCO=KCo1
DCT=DCT1
DCO=DCO1
F0911.Fetch NExt
MCU-> MCU1
OBJ->obj1
SUB->sub1
while SV _file_I_O_status = Co sucess
f0911.fetch next
Do Custom (Print Vars)
end while
The “Print Vars” section will print the DOC, DCT, KCO and the fetched values of MCU1, OBJ1 and SUB1.
OK Deepesh. I will try and let you know. Thank you very much for your time.
Hi,
I tried out but now my while loop is going without exiting. i checked twice but i dont know where i am wrong.
Hi, I need to enter text on sales order header and Sales order detail line. Text should contain max 30 characters. I dont want to use Print msg and Delivery instruction 1 and 2 field. Other than that any options available to enter text.
Hi Deepesh,
Can you please tell me all the steps for Data copy in table conversion for copy data from multiple table to multiple table.
Thanks