?
Solved

Oracle E-Business Suite Special Edition

Posted on 2011-04-28
14
Medium Priority
?
314 Views
Last Modified: 2012-05-11
We have this SE of EBS and I have the task to update the form for a particular workflow.

The Form is a RTF form with XML tags implemented using the XML Publisher within Oracle. I have a set of XML tags which pull from a source that does not contain any data anymore and now need to replace these with XML tags that point to a different source.

I have an input mask for Bill of Materials and one for Discrete Works order. The BOM is now no longer used and the Worksorder which used to pull the info from the BOM is now populated by hand, typing in the data. The RTF form that prints the WO used to pull the data from the BOM with XML, I need to find the XML codes for the fields in the WO input as otherwise the form prints out empty.

I have no idea whether this makes sense or whether the question should be raised differently. i also know nothing about Oracle development or admin. So any advice to point me in the right direction is appreciated but I have been already through user manuals etc.

Ideally a hint on where to dig or how XML tags relate to tables would be great.

DB is Oracle Apps 11i.

thanks
capt.
0
Comment
Question by:captain
  • 7
  • 5
12 Comments
 
LVL 9

Expert Comment

by:CCSOFlag
ID: 35507752
eef, Capt (just wanted to post since you linked it for me to check out).  I don't know much about EBS, but from the sounds of it, you will need someone to dig into the program itself to figure it out.  I'm not sure if you will get a good answer on these forums, as I think it is a bit more involved than just giving some code fixes.  I hope I'm wrong though.  
If I understand it right, it's going to require completely changing the XML conversion code or starting from scratch.
As far as how XML tags relate to tables, typically each tag name will correspond to a table field.  Inside those tags you will have the data for each specific record.  Each record should have it's own set of XML tags.  Not sure if that is what you were asking.  Here is a small example though

TableX
ID        Name                Value
1         Captainreiss        123
2         CCSOFlag            321

This would look something like this in XML:
<TableX>
<Record1>
   <ID>
   1
   </ID>
   <Name>
   Captainreiss
   </Name>
   <Value>
   123
   </Value>
</Record1>
<Record2>
   <ID>
   1
   </ID>
   <Name>
   CCSOFlag
   </Name>
   <Value>
   321
   </Value>
</Record2>
</TableX>

Open in new window

0
 
LVL 31

Author Comment

by:captain
ID: 35508343
I will have a look at the forms tomorrow and post some code. It may be as simple as looking at the field of a particular table and checking which XML code it is. But I am not sure...
0
 
LVL 9

Expert Comment

by:CCSOFlag
ID: 35508434
sounds good.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 31

Author Comment

by:captain
ID: 35511180
OK, here is a sample document for our code. The document is the RTF template used by XML Publisher to create the printed document that is handed to the worker after the order is input. This is the works order in my question, it contains a section called Build Component Details this is populated from the BOM table at the moment. all the other fields are populated from the worksorder table.

The user is now no longer inputing data into the BOM table but into the worksorder table. Hence when the XML form is populated the fields are empty.

How do I change the XML on the attached form to pull in the right data?

So for that I need to know:
- how to look up XML for the datafield.
- how to modify the xml tags

Please note, as RTF is not accepted as an ext I renamed it txt. please change to RTF before opening. Work-Order-01a.txt
0
 
LVL 31

Author Comment

by:captain
ID: 35513540
It appears that the XML Publisher contains a template for the report and also a data definition set.

The data definition is unique to each report so I suspect that needs amending an the underlying XML schema is uploaded to create the definition.

However the application does not allow me to open or view the existing schema, nor is there any way to interrogate this further.

Does anyone have any experience in how to retrieve existing data definition or XML schema via XML Publisher responsibility in EBS??
0
 
LVL 9

Expert Comment

by:CCSOFlag
ID: 35514057
To make the XML files for the reports, from what I understand you use Apps under sys Admin.  Is there not an edit or anything that you can use on existing reports?  You may need to define new ones to import into your report templates.

Do you have the XML Publisher Desktop Utility Installed?  That is what is needed to update any report templates.  
0
 
LVL 31

Author Comment

by:captain
ID: 35514324
>>use Apps under sys Admin

correct, and there is no edit, you can edit report templates in word, like the attached one above but there is no way of knowing what XML schema underlays the data definition that are used in the report template.

I don't have the DU version, I did not know about this. Where can I get this from?
0
 
LVL 9

Expert Comment

by:CCSOFlag
ID: 35514467
Not familiar with a DU version.  What is that?
0
 
LVL 31

Author Comment

by:captain
ID: 35514510
;o) sorry my bad:

DU=Desktop Utility
0
 
LVL 9

Accepted Solution

by:
CCSOFlag earned 2000 total points
ID: 35514622
http://viratoracleapps.blogspot.com/2010/09/xml-publisher.html

try that, it has instructions for several things including the Desktop Utility.
0
 
LVL 31

Author Comment

by:captain
ID: 35710392
Thanks sheriff. Will look through this on Monday and feed back info then.
0
 
LVL 31

Author Comment

by:captain
ID: 35727165
I am now waiting for a call from the guy who set this up, but it sounds like your link will be a step in the right direction. Will ask a new Q if I am stuck again
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question