Friday, 9 January 2015

Order Line Not Invoiced

When a Sales Order is Created It may happen that you expect to see and invoice for the Order once the lines are closed but Invoices dont appear there can be a number of reasons for it :

1. The item on the Order lines is not enabled for invoicing , check the Invoice Enabled Flag on the Shipping Warehouse , IVO and Item Master
2. The order is an Internal Sales Order , these orders are not invoiced
3.Configuration items are not invoiceable
4. If line flow does not invluce the Invoice Interface Activity then the invoice invoice_interface_status_code will not be set and remain null

One of the above scenario should be valid and your issue should get resolved 

Journal Batch Posting Error

When Posting a Journal Batch you might encounter an Error where the Posting program fails .
In such cases first thing is to check the OUTPUT and LOG file for potential messages displayed by Oracle.

One of the errors which can occur is : ORA-00001: unique constraint (GL.GL_JE_HEADERS_U2) violated

If you see the table gl_je_headers there is an unique index on Batch Id and Journal Name.

For the same batch you will see that the Journals have a unique name but when doing posting Oracle checks for the First 78 characters of the Journal Name and Batch Id Uniquenss , if the condition is violated we will get the above error.

To resolve the error open the Journals in the batch update the names by adding Unique numbers at the beinging , save your work and Post again

Issue will be resolved.

Monday, 5 January 2015

Multiple Organization Access Control (MOAC)

One of the biggest changes available to users in migrating from 11i to R12 is Oracle MOAC Structure,

In 11i in a given Legal entity is a Business had 2 Operating units A and B , then if a User wishes to see the information attached to Operating unit A and the he needs to use the responsibility associated to the Operating unit A , and similar is the case for B

In R12 the scenario is different , Oracle has made available the feature of Security Profiles based on which the user from one responsibility only can have access to data across Multiple Operating units in a given legal entity.

thus in the above Scenario the user can access the data of both the operating units using the same responsibility and will not need to change the responsibility for every operation,

This feature is enabled by the use of Security profiles which we will discuss soon