R12 - AP Payment Setups

1. Interest rates :

In the Payment Interest Rates window, you define interest rates Payables uses to calculate and pay interest on overdue invoices. Payables calculates interest on overdue invoices only if you enable both the Allow Interest Invoices Payables option and the Allow Interest Invoices option for the supplier of an invoice.

(N)>Setup>Payments>Interest Rates

 select * from AP_INTEREST_PERIODS;


2. Bank Charge Calculation :


Use the Bank Charge Calculation window to specify charges associated with transferring money between banks. If you use Payables you specify charges between your remittance banks and your suppliers' banks. If you use Receivables you specify charges between your customers' banks and your banks. You can define charges.

 (N)>Setup>Payments>Bank Charges Calculations.

 select * from AP_BANK_CHARGES ;

select * from AP_BANK_CHARGE_LINES;

3. Bank and Bank Branches Creation  :

(N)>Setup>Payments>Bank and Bank Branches.

Click on Banks --> Create

Click Save and Next -- > Click on create to create Bank Address --> Enter required fields and click on Apply.

Click Save and Next  -->  Click on Create Contact to Create contact person/info --> Enter all the required info. We can create any number of contacts by clicking on Add Another Row.

 

Click on Finish.

 Click on Create Branch to create Bank Branches.

 

R12 - AP Invoice Setup - 1

Hi Friends,

Today i am posting required setups related to Account Payables.

1. Payment terms : We define payment terms that we can assign to an invoice to automatically create scheduled payments when we submit Payables Invoice Validation for the invoice. we can define payment terms to create multiple scheduled payment lines and multiple levels of discounts. Payment terms have one or more payment terms lines, each of which creates one scheduled payment.

Setup>Invoice>Payment Terms

Underlying tables.

select * from AP_TERMS where name = 'XX_TERM' and term_id = 9999;

select * from AP_TERMS_LINES where term_id = 9999;

2. Distribution Sets :

Use a Distribution Set to automatically enter distributions for an invoice when you are not matching it to a purchase order.
We can assign a default Distribution Set to a supplier site so Payables will use it for every invoice you enter for that supplier site. If we do not assign a default Distribution Set to a supplier site, we can always assign a Distribution Set to an invoice when we enter it.

(N)>Setup>Invoice>Distributions Sets

 For Ex : Create an invoice and assign above created distribution set.

Click on Distributions button. verify the amount is distributed onto two accounts based distrinution set.

 select * from AP_DISTRIBUTION_SETS where distribution_set_name = 'XX_NAME';

select * from AP_DISTRIBUTION_SET_LINES where distribution_set_id = 9999;

3. Tolerances :

Use the Invoice Tolerances Template window to define the matching tolerances we want to allow for variances between invoice, purchase order, and receipt information. we can define both percentage-based and amount-based tolerances.
Tolerances determine whether Payables places matching or tax holds on an invoice. When we submit Payables Invoice Validation for an invoice that we have matched to a purchase order or receipt, Payables checks that the invoice matches the purchase order or receipt within the purchase order matching tolerances you define.


(N)>Setup>Invoice>Tolerances 

 select * from AP_TOLERANCE_TEMPLATES where tolerance_name = 'TEST_9';

4. Hold and Release Names : 

Use the Invoice Hold and Release Names window to define the names that we use to manually hold or release invoices. We can define hold names that we assign to an invoice during entry to place the invoice on hold.

(N)>Setup>Invoice>Hold and Release Names

 select * from AP_HOLD_CODES;

5. Pay Group :

Pay Groups are used to classify each invoice - Pick one Pay Group and pay all related invoices at one shot.

Setup -->  Lookup  --> Purchasing

R12 - Fixed Assets Overview

Hi Friends,

Today i am posting Overview Of Oracle Fixed Assets.

R12 - Cycle Counting

What is Cycle Counting?

Cycle Counting  is a process of periodic counting of individual item / all the items  throughout the course of the
year to ensure the accuracy of inventory quantities and values.

We can do the cycle counting at Organization / Sub Inventory Level.

What is ABC Analysis?

ABC analysis is used determines the relative value of a group of inventory items based on a
user-specified criteria. "ABC" refers to the rankings you assign your items as
a result of this analysis, where "A" items are ranked higher than "B" items, and so on.

1. Define ABC Compile

ABC Codes --> ABC Compile ( Select Organization for which you are planning to compile the items. Ex : M1 ).  --> Click on New

Enter the name and scope of compile ( organization or inventory level ) and enter the criterion.

Click on Compile. system will compile / calculate the number of item within the organization and value of the items.

2 conc prorams will run in back end " Compile ABC analysis" and "ABC descending value report".

Open the output of ""ABC descending value report",we will find the items information within the organization.

2. Define ABC Classes.

In the above example i have created  LS_A , B , C Classes. That means, all high volume / value items, we have to assign to LS_A Class, all medium volume / value items to LS_B Class.

3. Define ABC Assignment Group.

ABC Codes -->  ABC Assignment Groups    

Create New Group "TEST_ASSIGN_GROUP" and assign earlier created ABC Compile called "TEST_COMPILE" to this Group.

Click on Group Classes Button, to assign earlier created ABC Classes to this Group.

Click on Assign Items Button, Assign all the items from compile "TEST_COMPILE" to these 3 classes and save. Once save the records, in back end conc program "Define ABC assignments" will run.
( "ABC descending value report" will display items in descending order based Quantity and value). In our example i am assigning top 10 items to the class LS_A and top 11 to 99 items to class LS_B and renaming to class LS_C.

4. Define Cycle Count .

Counting --> Cycle Counting --> Cycle Counts.


Click On New to create new cycle count for organization M1.

Check the check box called Auto Schedule to schedule the counting.

Click on Adjustment and ABC Tab and assign ABC assignment Group Name and save. Once we save the record, in back end Conc. Program "Initialize cycle count items" will run.

Click on Classes Button and enter number of times we are planning to count the items from ABC Classes per Year and save.

Click on Item Button ( in Adjustment and ABC Tab ) and all the item from ABC Classes are populated automatically.

 5. Manual Scheduling of Cycle Counting.

We can schedule all the items from cycle count or only few items from cycle count. for our demo purpose i am scheduling Item "MC31324 ".

Counting --> Cycle Counting --> Cycle Counts  --> Search for "TEST_COUNT" and click on Schedule Button

Or

Counting --> Cycle Counting  --> Manual Requests --> Enter Cycle Count name and click on find.
Enter Item Name and save.

 6. Request for Cycle Counting.

Open Cycle Count Form and Query with Cycle Count "TEST_COUNT".  Go to Tools --> Cilck on Generate Count Requests.  In Backend "Generate cycle count requests" Program will run.

Open Cycle Count form and Query With Cycle Count "TEST_COUNT" and click on Counts Button to see the on hand Quantity of the item in system. In our Example, on hand Qty in system for Item "MC31324' = 50000.

Cross verify the on hand of the item.

on-hand Quantity, Availability --> On-hand Quantity and search with item "MC31324".

7. we have to do manual counting for Item "MC31324" in organization "M1".

After counting the item manually in M1, we found that on hand qty of the item is 50090. that means 90 items are less in oracle inventory system. So we have to do adjustment for that item in system to synchronize the system OHQ and Actual OHQ

8. Adjustments.

Open Cycle Count form and Query With Cycle Count "TEST_COUNT" and click on Counts Button and click on Adjustment Tab and enter Count Quantity = 50090 . ( System will update the Adjustment Quantity = 90 ) and Save.

9. Verify the OHQ On the Item. Now OHQ in System  = 50090.

Cycle Counting Overview

Hi Friends,

Today i am posting Overview Of Cycle Counting in Inventory. In next post, We will discuss in detail.

R12 - Upload Item Specific UOM Conversion

Hi,

Today i am posting how to upload item specific UOM conversion rates by using API.

Procedure : CREATE_UOM_CONVERSION  Is introduced in R12.1.3.

DECLARE
v_from_uom       VARCHAR2(200);
v_to_uom         VARCHAR2(200);
v_item_id        NUMBER;
v_uom_rate       NUMBER;
x_return_status  VARCHAR2(99);

BEGIN

  v_from_uom := 'DOZEN'; 
  v_item_id := '9999';
  v_uom_rate := '9';
  v_to_uom := 'EA';


  INV_CONVERT.CREATE_UOM_CONVERSION
                  (
                    p_from_uom_code => v_from_uom,
                    p_to_uom_code   => v_to_uom,
                    p_item_id       => v_item_id,
                    p_uom_rate      => v_uom_rate,
                    x_return_status => x_return_status
                  );
END;

R12 - Query to find Supplier, Sites and Contact Information

Hi Friends,

Today i am posting Query to find Supplier, Sites and Contact Information.

AP_SUPPLIERS                    
AP_SUPPLIER_SITES_ALL
AP_SUPPLIER_CONTACTS

In R12, Contact person information is stored in HZ_PARTIES table not in ap_supplier_contacts.

SELECT asp.vendor_id ,
asp.segment1 "Supplier Num" ,
asp.vendor_name "Supplier Name" ,
ass.vendor_site_code "site name" ,
hou.name "Operating Unit Name" ,
ass.address_line1 ,
ass.city ,
ass.state ,
ass.zip ,
ass.country ,
ass.phone ,
person.person_first_name ,
person.person_last_name ,
pty_rel.primary_phone_number ,
pty_rel.email_address
FROM ap_suppliers asp ,
ap_supplier_sites_all ass ,
ap_supplier_contacts apsc ,
hz_parties person ,
hz_parties pty_rel,
hr_operating_units hou
WHERE ass.vendor_id = asp.vendor_id
AND apsc.per_party_id = person.party_id
AND apsc.rel_party_id = pty_rel.party_id
AND ass.org_id = hou.organization_id
AND apsc.org_party_site_id = ass.party_site_id
AND asp.vendor_name = 'LS Supplier';