🔹 Join the OracleApps88 Telegram Group - Stay up to date with the latest on Oracle EBS R12 and Oracle Cloud/Fusion Applications. 📌 Telegram Group : https://t.me/OracleApps88

💡 Facing issues copying code/scripts or viewing posts? We're here to help!
📬 Contact on Telegram : https://t.me/apps88
📱 Telegram/WhatsApp: +91 905 957 4321
📧 Email Support: OracleApp88@Yahoo.com
Showing posts with label SUPPLIERS. Show all posts
Showing posts with label SUPPLIERS. Show all posts

Thursday, September 4, 2025

Oracle Supplier Dynamic Discounting

Dynamic discounting is a system where a supplier offers discounts to a buyer depending on the payment dates. Dynamic discounting is a method of early payment wherein the buyer pays the supplier in advance before the agreed-upon dates in return for a discount on the invoice.

 

The discount is dynamic because it reduces as the invoice nears maturity under the original conditions. The “dynamic” aspect refers to the ability to alter discounts based on the dates when the supplier gets paid by the buyer.

 

To give you an idea, let’s assume that a supplier and a buyer have agreed upon an original payment term of 60 days. As per the dynamic discount conditions, if the buyer pays the supplier on day 20, the buyer would get a 3% discount. The buyer would get a 2% discount on day 40 and no discount on day 60.

 

What is the process behind dynamic discounting?

1.       The buyer buys services or products from the supplier.

2.       The invoice is uploaded to the dynamic discounting platform by the supplier.

3.       The invoice is approved for payment by the buyer.

4.       The supplier considers the discounts available for a variety of payment dates.

5.       When the buyer and supplier mutually agree to the rates of discounts on various dates, the discounts are automatically applied when early payment is made.

 

What are the benefits of dynamic discounting?

Suppliers and buyers are the two types of people who benefit from dynamic discounting. Let us look at how dynamic discounting benefits both the suppliers and buyers in a supply chain.

 

Supplier benefits

1.       Suppliers can control when and which of their authorized invoices are paid and the percentage of discount they get.

 

2.       It offers suppliers fast and straightforward access to cash, which boosts supplier relationships and the financial supply chain.

 

3.       Dynamic discounting enables more accurate working capital forecasts and growth planning.

 

4.       Suppliers who use dynamic discounting receive access to capital at a cheaper cost than other choices accessible to them, allowing them to handle unforeseen expenditures or invest in development and creativity.

 

5.       Using the versatile, dynamic discounting model, suppliers can finance a single invoice, multiple invoices, or every invoice.


6.       Instead of 1, 2, or 3 months dynamic discounting allows suppliers to receive money in a few days.

 

7.       Increasing working capital through early payments from buyers is usually more significant than higher profits, especially for smaller suppliers, as it is critical to their long-term operations.

 

8.       Suppliers can enhance their cash conversion cycle by obtaining early payment, which reduces their days’ sales outstanding (DSO).

 

9.       With complete integration between two ERP systems, the supplier can gain an advantage with buyer-side transparency of received invoices. They can even employ integrated settlement advice as value addition in their payment dashboard.

 

Buyer benefits

1.       Buyers can save millions by utilizing invoice discounts to pay less for products and services. The saved money can be invested for a higher return on investment.

 

2.       Offering early payment to consumers strengthens the supply chain for the buyer and decreases the probability of disturbances.

 

3.       Buyers are essentially investing their own money with dynamic discounting to get discounts. These convert into risk-free profits that are typically higher than the conventional investment gains.

 

4.       Dynamic discounting enables buyers to reimburse their suppliers in advance in return for a discount, allowing buyers to profit from double-digit, risk-free profits.

 

5.       Dynamic discounting increases the working capital of the sellers by giving choices for quick, versatile, and predictable access to cash. As a result, more sellers are motivated to do business with buyers, increasing the strength of the supply chain.

 

6.       Buyers gain a working capital advantage from sellers who do not settle for early payments when combined with a payment terms extension.

 

7.       When suppliers are given early payment and accessibility to a user-friendly system, buyers can improve their relationships.

 

8.       Buyers minimize the cost of the goods and services they acquire by leveraging the early payment discounts improving procurement KPIs.

 

Final thoughts

The usage of dynamic discounting is on the rise because both the buyer and supplier benefit from it. A buyer and supplier partner use a dynamic discounting system to produce a fair, mutually advantageous partnership. It can also enhance the buyer-supplier relationship by increasing credibility.

Saturday, July 20, 2019

AP – Oracle Fusion Payable and Payments (ACH, Check) Setups and Process Training Manual

Payable Setups
  Setup the Manage Procurement Agent
  Supplier Registration without Bank Details
  Add the Bank Account to the Supplier
  Invoice, Payment Approval Setups (Optional)
  Bank, Branch and Bank Account Setups
Understanding Payables Dashboard

Invoice Creation
  Standard Invoice
  Credit Memo Invoice
  Credit Memo Invoice with Matching to Standard Invoice
  Debit Memo Invoice
  Debit Memo Invoice with Matching to Standard Invoice

PO (Purchase Order) Matched Invoices
  Creating a Purchase Order for Apply to Standard Invoice
  Creating a Standard Invoice and Match the Above Purchase Order
  Creating One Invoice Matched to Multiple Purchase Orders

Invoice Holds
  Placing a Manual Hold on an Invoice
  Releasing Invoices from a System Hold
  Placing a Manual Hold on an Invoice Lines
Cancelling an Invoice


ACH (Electronic) Payment Setups and Process Flow
ACH Payment Setups
  1.BI Publisher Desktop
  2.Payment Setups
    a.Payment Templates
    b.Payment Formats
    c.Payment Document (For Electronic payments this setup is Optional)
    d.Payment Process Profile (PPP)
    e.Payment Process Request Template (Optional)

  ACH (Electronic) Payment Process Flow
  1.Create Invoice and Pay in Full
  2.Manual Payment
                Create invoice and submit the Manual Payment
               
  3.Run the Payment Process Request (PPR)
                Create Invoice
                Void the Payment (Cancel the Existing payment)
                Create the PPR for New Invoices and Void Payments
               
  4.Accounting
                Post the Invoice to General Ledger
                Post the Payment to General Ledger
 

Check Payment Setups and Process Flow
   Check Payment Setups
    1.Payment Setups
      a.Payment Templates
      b.Payment Formats
      c.Payment Document (For Electronic payments this setup is Optional)
      d.Payment Process Profile (PPP)
      e.Payment Process Request Template (Optional)

  Check Payment Process Flow
    1.Create Invoice and Pay in Full
    2.Manual Payment
      Create invoice and run the Manual Payment
   
    3.Run the Payment Process Request (PPR)
      Create Invoice
      Void the Payment (Cancel the Existing payment)
      Create the PPR for New Invoices and Void Payments
   
    4.Accounting
                  Post the Invoice to General Ledger
                  Post the Payment to General Ledger


Setup the Manage Procurement Agent
Procurement agents are typically users with procurement roles, such as:
Buyer
Catalog Administrator
Category Manager
Procurement Contract Administrator
Procurement Manager
Supplier Administrator
Supplier Manager
Supplier Qualification

They have procurement job responsibilities in the buying organization, such as creating purchase agreements, purchase orders, and related procurement functions. You must set up these users as procurement agents for them to manage procurement documents and perform other procurement actions.
You use the Manage Procurement Agents task to create and maintain a procurement agent's access to procurement functionality for a business unit. You can find the task in the Purchase Agreements and Purchase Orders work areas.

You can implement document security for individual document types, such as purchase orders, purchase agreements, and requisitions. You can also control a procurement agent's access to manage activities for suppliers, negotiations, catalog content, and business intelligence spend data.
The configuration assigns an access level to documents owned by other procurement agents for each procurement business unit.

Note: An agent can perform all actions on his own documents as long as he has procurement BU access.
None: The agent has no access to documents owned by other agents.

View: Permits the agent to search and view other agents' documents.
Modify: Permits the agent to view, modify, delete, and withdraw other agents' documents.
Full: Permits the agent full control of other agents' documents. This includes the view, modify, delete, withdraw, freeze, hold, close, cancel, and finally close actions.
The buyer agent is granted access to the Manage Supplier functionality in the Manage Procurement Agent page
- Login with an username with access to Functional Setup Manager
- Select Functional Setup Manager (FSM) face
- In All Tasks Tab, search for "Manage Procurement Agent"
- Click on Manage Procurement Agent task
- Click on the Agent Name to Edit the Agent
- Under Action, grantee the "Manage Suppliers" privilege to the agent
By default, the suppliers for which the agent is granted access is based on the business unit setups. And Supplier Sites are assigned to certain business units in the site assignments.
All of these setups work together to determine which suppliers and supplier sites the buyer agent can manage or view.

If you have France setup as a Business Unit and Italy setup as a Business Unit you may control the access via the Business Unit setup for the buyer agent, or otherwise you may control the access at the individual Supplier Site setups.

Supplier Creation and Maintenance
After login to instance, click on Home Icon.




Please click on the below link for more details:
AP – Oracle Fusion Payable and Payments (ACH, Check) Setups and Process Training Manual
https://drive.google.com/file/d/1kmoZp1GbG2jymB3eEeJpsicdJOr5BMDX/


Please Like and Share our FaceBook page to get more details on Oracle Applications
https://www.facebook.com/pages/Oracle-Applications/712588392100243

Monday, November 19, 2018

AP_VENDOR_PUB_PKG.UPDATE_VENDOR - API Script To Update Supplier Details

DECLARE
  p_vendor_id                NUMBER           := 1436;
  p_api_version              NUMBER            := 1.0;
  p_init_msg_list            VARCHAR2(200)     := fnd_api.g_true;
  p_commit                   VARCHAR2(200)    := fnd_api.g_true;
  p_validation_level         NUMBER            := fnd_api.g_valid_level_full;
  x_return_status            VARCHAR2(200);
  x_msg_count                NUMBER;
  x_msg_data                 VARCHAR2(200);
  lc_vendor_rec              ap_vendor_pub_pkg.r_vendor_rec_type;
  lr_vendor_rec             ap_suppliers%ROWTYPE;
  l_msg                      VARCHAR2(200);
 
BEGIN
  -->Initialize apps session
  FND_GLOBAL.APPS_INITIALIZE(1318,50554,200);
  MO_GLOBAL.INIT('SQLAP');
  FND_CLIENT_INFO.SET_ORG_CONTEXT(101);

  -->Vendor details
  BEGIN
    SELECT *
      INTO lr_vendor_rec
      FROM ap_suppliers asa
     WHERE asa.vendor_id = p_vendor_id;
  EXCEPTION
    WHEN OTHERS THEN
      DBMS_OUTPUT.put_line('Invalid vendor id:' ||p_vendor_id);
  END;

  -->Update Vendor
  lc_vendor_rec.vendor_id          := lr_vendor_rec.vendor_id;
  lc_vendor_rec.vendor_name       := lr_vendor_rec.vendor_name||'_001';
  lc_vendor_rec.end_date_active     := SYSDATE;
  lc_vendor_rec.enabled_flag        := 'N';

  AP_VENDOR_PUB_PKG.UPDATE_VENDOR
                (p_api_version      => p_api_version,
                 p_init_msg_list    => p_init_msg_list,
                 p_commit           => p_commit,
                 p_validation_level => p_validation_level,
                 x_return_status    => x_return_status,
                 x_msg_count        => x_msg_count,
                 x_msg_data         => x_msg_data,
                 p_vendor_rec       => lc_vendor_rec,
                 p_vendor_id        => p_vendor_id
                );
                                
  DBMS_OUTPUT.put_line('API Status ' || x_return_status);
  IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
    FOR i IN 1 .. fnd_msg_pub.count_msg LOOP
      l_msg := fnd_msg_pub.get(p_msg_index => i,p_encoded   => fnd_api.g_false);
      DBMS_OUTPUT.put_line('The API call failed with error ' || l_msg);
    END LOOP;
  ELSE
    DBMS_OUTPUT.put_line('Successfully Updated the Supplier details');
    COMMIT;
  END IF;
END;

/
If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect