asked on

Oracle E-Business Suite Special Edition

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.

CCSOFlag

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

captain

ASKER

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...

CCSOFlag

sounds good.

captain

ASKER

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

captain

ASKER

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??

CCSOFlag

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.

captain

ASKER

>>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?

CCSOFlag

Not familiar with a DU version. What is that?

captain

ASKER

;o) sorry my bad:

DU=Desktop Utility

ASKER CERTIFIED SOLUTION

CCSOFlag

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

captain

ASKER

Thanks sheriff. Will look through this on Monday and feed back info then.

captain

ASKER

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