Monday Jul 20, 2015

How to run the new XML version of the APList Invoice Data Collection Diagnostic

There is now an XML version of the Payables APList, which is an alternative to the Invoice Data Diagnostic in the diagnostic pack. 

Why it is needed?

The Diagnostic version (HTML based) is limited on size and cannot bring back all the data needed to resolve issues.  By using the XML version the size limitation is removed.

The XML version offers some significant advantages over the HTML version in the diagnostics:

  • The XML contains more data available to Oracle Support: versions, more setup tables, profile options, etc.
  • Support can apply various XSL templates to the XML to make it easy to read and specific to the issue at hand
  • Removes size constraints and all the data can be retrieved without making the HTML impossible to open
  • Can be run as a concurrent request rather than having to use the diagnostic responsibility
  • Can be run via SQL*Plus or any other SQL Utility
  • Can be run for multiple invoices at a time
  • Support tools can use XML to automatically diagnose certain issues

While the XML version can take a couple more minutes to run it reduces the need for other diagnostics.

When to use it?

This version can be used when requested by Support, or anytime an invoice data diagnostic is requested.

How to run it?

The script can be ran several ways depending on your preference:

  • Run directly from SQL*Plus (or a comparable tool)
  • Run via the concurrent manager SRS window
  • Run via an option on the Tools menu in the Invoice Workbench

How can I find out more?

Please review Doc ID 1677861.1 - How to use the XML version of the Payables APList [VIDEO] which contains videos teaching how to use all the methods to help you fully understand how to use this new tool.

What if I still have questions?

Post your question on the AP community thread and we will be happy to answer them.

Tuesday Sep 16, 2014

New Functionality - Invoice Approval Parallel Processing

Invoice approval workflow now supports parallelization at the invoice header level on 12.1.x and 12.2.x.

The main advantage for this change is to shorten the processing time for an invoice to get approved.

The parallel approval process imposes a hierarchical (tree) structure on the transaction’s approver list and enables each part of the tree at a given level to progress through its notification-approval cycle asynchronously.

This enables the approval process of each item in the transaction to continue irrespective of the progress of approval process of other items in the transaction and reduces the transaction's approval process time.

If user selects the parallel ordering mode, the approval notifications will be sent to all approvers at the same time. The invoice may get approved when one or all approvers approve the invoice, depending on the voting regime that is set up.

What voting regimes are supported?

This voting regime assigns group-or-chain-member order numbers in ascending order of the member order numbers, breaking ties arbitrarily.
All group members must approve the notification in order for the invoice to get approved.

This voting regime assigns group-or-chain-member oder number one to all members.
All group members must approve the notification in order for the invoice to get approved.

This voting regime assigns group-or-chain-member order number one to all members.
As soon as one approver approves the notification, the invoice will get approved.

Order number:
This voting regime sets each member's group-or-chain-member order number to the member's order number.
All group members must approve the notification in order for the invoice to get approved.

For more information please review R12: New Functionality Invoice Approval Parallel Processing (Doc ID 1904137.1)

Please provide any feedback on this new feature via the community post on this topic.

Friday Sep 05, 2014

Invoice Validation Parallel Processing New Functionality Available

What has changed?

The Invoice Validation concurrent program is now equipped to spawn multiple child requests based on the Purchase Order matched invoice load and the newly seeded profile "AP:Maximum Invoice Validation Child Requests".

The user continues to submit a single Invoice validation program with his/her preferred parameters but internally the program groups the invoices matched to same Purchase Orders and ensures that each such group is processed by a single child request.

Whereas for invoices that are not matched to any Purchase Orders, the system distributes these invoices equally amongst the maximum number of child requests spawned (as per the value set by the user in the aforementioned profile).

Why the change?

1) The current invoice validation concurrent program was not scaling up for high volume of invoices.

2) If multiple requests of the invoice validation concurrent program are submitted and invoices matched to the same Purchase Orders are processed by two or more requests then there are possibilities of lock contention errors on PO_HEADERS_ALL in any of the requests that concurrently attempts to update the PO object.

3) To avoid conflicts, user had to wisely select the parameters at the time of submitting the concurrent program or have conflict domains defined that constrained the program to execute serially.

4) Submitting multiple requests of the program causes an overhead of reviewing multiple log files and outputs.

More Information

R12: New Functionality Invoice Validation Parallel Processing (Doc ID 1917614.1)

If you have any questions on this new functionality please use the community thread

Tuesday May 13, 2014

How to Create Invoices from iSupplier

Confused by the iSupplier Create Invoice functionality?  

Suppliers can directly create invoices in Oracle iSupplier portal. They can create PO matched or Non PO matched invoices and submit them for approval to the company. Once approved and validated, these invoices will be ready for payment.

A white paper was created that provides a step-by-step guide for setting up and allowing suppliers to create invoices using the iSupplier portal:

R12 : White Paper on Creating Invoices from iSupplier Portal (Doc ID 1623846.1

This paper will cover the following topics:

  • Setup to create a supplier as a user in Oracle
  • Steps to create Purchase Order matched invoices in iSupplier portal
  • Steps to create Non Purchase Order matched invocies in iSupplier portal 

Wednesday Apr 23, 2014

Where Can One Find Help with Inventory Intercompany Invoicing?

Are you looking for a one-stop-shop for set-up and processing of Inventory Intercompany Invoicing?  We have just that in the Create a Intercompany Invoice AR and AP Overviews (Doc ID 784679.1) document.

This document uses different media including a recorded demo to walk a User through the standard everyday process of setting up and creating Intercompany Invoices.

Get a refresher course on how to set up an internal sales order for Intercompany Ivoicing, importing records into Accounts Receivable, and running the INCIAP (create Intercompany AP Invoice program). Get to the point of a created Intercompany Invoice:

Are you one of those bean counter types that needs to know the accounting distributions? Check out the 'Advanced Accounting' section.

What happens if you run into an an error when processing? Document 784679.1 contains some dynamite examples of debug log files, with annotation and color codes, all found in the The 'Debugging  Proces(s)' section. 'Red' highlights table data, 'Green' shows data that is a forms path or profile option, and  'Purple' shows error messages. The debug section includes both Accounts Receiveable and Payables debug log file examples. Also check out the 'Brown Bag' section for scripts to help you solve the most common Intercompany error messages.

Intercompany Invoicing integrates many different Products and many different scenarios. This overview will help you cover your bases with the basic set-up, processing, and debugging of standard Intercompany Invoicing. Enjoy, and happy invoicing!

Logistics RUP9 Released !
Logistics Consolidated RUP9 (VERSION 12.1.1 TO 12.1.3 [RELEASE 12.1]) Patch 18618946 was released on April 18, 2014.

Don't forget to continue to RUP It! in Inventory, WMS, Receiving, and Product Information Management.
Use the following very helpful documents as references to keep up with your RUP's:
INV/WMS/RCV Family Patch Release History / Patchsets / RUPs (Doc ID 726226.1)
How To Determine the Product Information Management (PIM) Patchset and Rollup Patch Version (Doc ID 414470.1)

Welcome to the EBS Support Blog where Oracle insiders share news and information about EBS products including new releases, tips and tricks, troubleshooting guides, upcoming webcasts and links to EBS Communities.

Stay Connected



« July 2016