This discussion is archived
1 Reply Latest reply: Nov 5, 2012 1:54 AM by jiri.machotka RSS

Webcenter Content queries

972217 Newbie
Currently Being Moderated
We have a tax requirement to store AR Invoices sent to Customer to be later queried for audit and reprint purposes. These Invoices are generated in PDF format from the ERP source, we will have one huge single PDF file with multiple invoices in it. We are evaluating Webcenter Content IPM module for content management solution and Imaging Portal for basic UI search metadata, view and print. We understand PDF file can be tagged with metadata and stored in repository.

Have following queries

1)     OFR - For extracting metadata on PDF we are exploring OFR module. It could be a total custom solution and may involve creating new project, configuration, not sure if its even possible for this req.
Metadata: Invoice Number, Trx Date, Bill To Customer, Address etc
If this is not possible, we are evaluating alternate approach to use BiPublisher bursting feature to generate individual Invoice per PDF file, placed in a shared file system, a java program will read these PDF files and query ERP source to get the required metadata by naming unique identifed on filename e.g. <InvoiceNumber>.pdf. This java pgm will use IPM APIs to upload the pdf and metadata.

2)     IPM Imaging Portal - We heard there is a Aggregator like feature to merge individual PDF files into single PDF file for Viewing and Printing, like to learn more about this

3)     IPM Imaging Portal – How to enable function security so that only certain functions(Search only page vs Admin privileges) of Imaging Portal are accessible to authorized users. Is it possible to extend this page and have only Search link exposed

Imaging portal is deployed as
http://ipmhost:16000/imaging

4)     What are pros and cons of Database vs File store option in UCM, and guidelines on storage for applications partitioned in IPM.
  • 1. Re: Webcenter Content queries
    jiri.machotka Guru
    Currently Being Moderated
    Chandra,

    pls. see possible answers below

    ad 1) if your question is whether you can use OFR to break one big PDF file to many smaller ones and extract metadata out of them, then the answer is: yes, it is definitely possible. Note that since you work with A/R, OFR might be a bit overkill (your format is known, and perhaps, even modifiable, isn't it?), so WebCenter Capture might be sufficient

    Nevertheless, myself, I would first ask the question: do we need this? You have one system, which out of data produces print-outs and one big PDF file, and now, you intend to construct another one, which will produce out of the big PDF - your original data (plus, the invoices, of course). Wouldn't it make more sense to modify the printing solution, so that it produces also small files with appropriate metadata as well?

    ad 2) never heard of that, nor could find it in the documentation - as for printing, see 5.4.2. in http://docs.oracle.com/cd/E23943_01/user.1111/e12783/c05_viewing.htm#BCGFAGJG (it always mentions a document).

    It is true, though, that UCM has Folios ( http://docs.oracle.com/cd/E23943_01/doc.1111/e10978/c09_folios.htm#CSMRC805 ) which have so called renderers, which might represent a single folio as a single representation (e.g. one large PDF). Maybe, you could customize your system and somehow re-use it in IPM.

    ad 3) just read through http://docs.oracle.com/cd/E23943_01/admin.1111/e12782/c02_security.htm#CDDFFGGH In 2.1.3.1 it contains examples what roles can be defined.

    ad 4) quite often discussed point. See e.g. Database storage vs. File system

    As for partitioning, some kind of chronological approach usually helps. Note that it is very difficult to suggest anything without knowing how many data you have, and what your use cases are.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points