Yearly Archives: 2024

Query to extract payment terms associated with a customer

oracle-ebs-customer-payment-terms SELECT customer_name, site_use_code, location, payment_term_id, name   FROM apps.hz_cust_site_uses_all a1,        hz_cust_acct_sites_all a2,        ar_customers a3,        ra_terms a4  WHERE a1.cust_acct_site_id = a2.cust_acct_site_id    AND a2.cust_account_id = a3.customer_id   …

Read More

MPS/MRP planning attributes

MPS/MRP planning attributes Navigation path: Inventory>Items>Master Items>General Planning (T) Refer to the table below for the setup of each attribute.   Attribute Valid values Purpose Comment Setup Planning Not Select…

Read More

ASL Setups

Setup supply chain For more information on supplier base setups, please refer to the Purchasing Training Manual. Approved Supplier List Approved supplier list is a controlled repository of information that…

Read More

Bank Number Missing Field From Expenses

Introduction Bank branch details missing in the expense. We need to go Manage Administrator Profile Option with this code CE_USE_EXISTING_BANK_BRANCH to add this user under profile values. Once fixed this…

Read More

Data Access Control Issue for Account Payable

Introduction: If the user has the below roles and data access set for a specific BU, it is showing all BUs in the payable module. It should be shown only…

Read More

Project Tasks Import FBDI Query in Oracle Fusion ERP Cloud

Introduction: This blog has Project Tasks Import FBDI Query that can be used to retrieve data as per Project Tasks FBDI Format in Oracle Fusion Cloud application.   Cause of…

Read More

Supplier Site PayGroup Mass Update Using REST API – Oracle Fusion ERP Cloud

Introduction: This blog has the REST API details that can be used to update the Supplier Site PayGroup in Oracle Cloud application.   Cause of the issue: Business wants to…

Read More

Extract Email Details to Excel File Using Power Automate

Introduction:  Managing email communication is essential in any organization, and extracting specific details from emails can help streamline processes and improve efficiency. Microsoft Power Automate provides a powerful, no-code solution…

Read More

Post Email Messages on Microsoft Teams

Introduction:  Microsoft Teams has become a central hub for collaboration in many organizations, allowing teams to communicate, share files, and manage projects seamlessly. However, emails remain an essential part of…

Read More

Restricting Self-Approval in Oracle Fusion

Introduction:    Addressing the self-approval concern for expenses and other documents after setting up a vacation rule in Oracle Fusion. You can prevent self-approval of expenses by selecting the “Prohibit Self-Approval…

Read More