Payables Reports Troubleshooting

1. Prob: My Trial Balance report reflects incorrect information.  How do I rebuild the Trial Balance to accurately reflect the actual data in my database?

   Sol: You will need to run the Rebuild Trial Balance script contained in patch  375496.  This patch can be     obtained through MetaLink.

2. Prob: I wish to research my issue though MetaLink.  I understand it is easier  to search for similar issues if I use the short name of my report as part of  my search criteria, however, I do not know the short name.  How do I determine the Short Name and Executable of my report?

   Sol: 1. Obtain the report log from the failed report run.

          2. Go to the application menu under Help View My Requests. A popup window

              illustrating the results of concurrent processes submitted by the user displays and in the lower   left-hand portion of the screen is the Request Log button.Click this to obtain the request log and document the short name of the report as shown in the header.

       - OR -

   1. Based on the report name the Technical Reference Manuals (TRM) can be used

   to obtain the short name.

   2. Determine the Executable Name through the System Administrator responsibility.

   Concurrent -> Program -> Define: Query Short Name value from above steps.

3. Prob: I've found a Note that contains information that indicates my issue may be caused by Invalid Objects in the Database. How do I check for these items?

   Sol: Run the following script to determine there are any Invalid Objects present:

          SELECT owner, object_name, object_type

          FROM dba_objects

          WHERE status = 'INVALID';

4. Prob: My "Payables Open Interface Import" errors out with REP-0736 (There exist

   uncompiled program units) and REP-1247(Report contains uncompiled sql).   How

   can I resolve this?

   Sol:  You need to recompile the report by converting the report from a rdf format to a rex format then back  to a rdf format again.

     Example:

          r25convm userid=apps/apps stype=rdffile dtype=rexfile

          source=<report_name>.rdf dest=<report_name>.rex

          batch=yes overwrite=yes

5. Prob: How do I run a Report from the command line?

   Sol:  Syntax for running report from the command line:

         ar25run userid=<schema owner of the report>/<password> \

         report=<report name>.rdf destype=printer desname=<printer name> batch=yes

     Change directories to the where the report resides.

               cd $AP_TOP/srw ( Apps 10.7)

               cd $AP_TOP/reports ( Apps 11)

               ar25run userid=apps/apps report=<report>.rdf destype=printer \

                           desname=orlprt6 batch=yes

6. Prob: I receive error ORA-00904, invalid column name when I attempt to run

   the "Suppliers" report on my release 11 instance:

   Sol:  Apply patch 725776 which brings APXVDVSR.rdf to version 110.This is

   included in mini-pack C and higher for release 11.

7. Prob: I am trying to run the "Expense Distribution Detail"  report for a NEW

   organization but am unable to submit the report.  I receive error APP-00703

   Sol:  Run the REPLICATE SEED DATA program for the Organization. Go into System

   Administrator responsibility and navigate to:

          1. Request -> Run

          2. Go to the Name field and click on the List of Values button (LOV).

          3. Choose the Replicate Seed Data program.

          4. The application will then ask for an Operating Unit.

          5. Choose the appropriate organization.

          6. Click the OK button to run the request

8. Prob: I receive the following errors attempting to run several different AP

   Reports:

          REP-00002 Unable to retrieve string from message file

          MSG-00001 After srwinit

          REP-01419: 'BEFORERE0004' plsql program aborted

          APP-00969: program exited with status 1

          APP-01125 Concurrent manager got an error running oracle reports.

   Sol:  In many cases REP-1419 'BEFOREREP0004' error is caused by not setting

   the GL Set of Books Name profile option.   This is set in the Update System

   Profile Options (Navigate - >Profile - >System).  In a single Org set up it

   should be set at the Site level.  In a multi Org set up it should be set at

   the responsibility level.

9. Prob: I have performance issues with the "Discounts Taken and Lost" report

   after I applied patchset T to Payables:

   Sol:  You are encountering bug 958217  You can apply patch 958217 for release

   10.7. This will bring you to version 80.24 for report APXINDTL.rdf

   You can apply patch 1002163 for release 11 for version 110.12 of the report

   APXINDTL.rdf.  This fix will also be included in Patchset U for 10.7 and AP

   Mini-Pack E for release 11.

10. Prob: What articles, white papers, or manuals should I read for more

    information on Payables report issues?

     Sol:

     Payables User's Guide release 10.7

     Payables User's Guide release 11

     Payables User's Guide release 11i

     Common 1099 Alignment Issues. 

     Payable Printing FAQ.  Note 110408.1

     Note:  Users Guides can be found on MetaLink in the associated product's

     Self-Service Toolkit Documentation link

11. Prob: What are the MetaLink keywords I should use when searching for Payables

    report issues on MetaLink?

    Sol: Use the short name of your report along with the any of the following

    key words:  alignment, printer, style, APXPBFEG for check printing,

    APXT7F99 for 1099 forms, APXRTB for Trial Balance.

12. Prob: The problems and solutions listed in this guide do not answer my question.

    Sol: If the Troubleshooting Guide for Payables reports does not answer your

    question, please log an iTAR.  Make sure to include the information you

    gathered from the Troubleshooting guide as this will assist the resolution

    time of your iTAR.