Delivery is Shipped Status but Order is Not Closed
Delivery is Shipped Status but Order is Not Closed Introduction In Oracle EBS, there are instances where a delivery reaches the Shipped status, but the associated Trip remains open. This…
Read MoreExtracting Data for Oracle Supply Chain Planning Cloud
Extracting Data for Oracle Supply Chain Planning Cloud – Steps to Customize the Integration Logic Introduction Oracle Supply Chain Planning (SCP) Cloud is a powerful tool for demand forecasting,…
Read MoreQuery to extract Active BOL_NOTES for all Active Customers
SELECT hp.party_name “CUSTOMER_NAME”, fdv.category_description “Catergory Description”, fdv.document_id, fdv.title, fdst.short_text, fdst.media_id, oarev.attribute_name, oarev.attribute_valfdst.short_textue FROM apps.fnd_documents_vl fdv, apps.fnd_documents_short_text fdst, apps.oe_attachment_rules_v oarv, apps.oe_attachment_rule_elements_v oarev, apps.hz_cust_site_uses_all hcsua, apps.hz_cust_acct_sites_all hcasa, apps.hz_cust_accounts hca, apps.hz_parties hp WHERE…
Read MoreQuery for Project & Change Order Approval Action History:
SELECT ROWNUM, ACTION_DATE, ACTION, from_user, from_role, to_user, to_role, Details, SEQUENCE, NOTIFICATION_ID, ACTION_TYPE FROM (SELECT ACTION_DATE, ACTION, from_user, from_role, to_user, to_role, Details, SEQUENCE, NOTIFICATION_ID, ACTION_TYPE FROM (SELECT c.comment_date DATE1, TO_CHAR(c.comment_date,’DD-MON-RRRR HH24:MI:SS’)…
Read MoreAPI to Load Values in Value Set
API to Load Values into Value Sets DECLARE —————————-Local Variables————————— l_enabled_flag VARCHAR2 (2); l_summary_flag VARCHAR2 (2); l_who_type FND_FLEX_LOADER_APIS.WHO_TYPE; l_user_id NUMBER := FND_GLOBAL.USER_ID; l_login_id NUMBER := FND_GLOBAL.LOGIN_ID; l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; l_value_set_value FND_FLEX_VALUES.FLEX_VALUE%TYPE;…
Read MoreEmployee Import API
CREATE OR REPLACE PACKAGE BODY XX_IMPORT_EMPLOYEES_NEW IS PROCEDURE XX_create_employee IS CURSOR Cur0 IS SELECT MESSAGE,ROWID FROM XX_PER_ALL_PEOPLE_F_INT WHERE TO_CHAR(INTERFACE_DATE,’DD-MON-YY’) …
Read MoreGL & XLA Queries
— GL & XLA Query SELECT glcc.concatenated_segments ACCOUNT, ac.customer_number, ac.customer_name, xlal.currency_code, xlal.accounted_dr accounted_dr, xlal.accounted_cr accounted_cr, xlal.entered_dr, xlal.entered_cr, h.je_category transaction_type, xlal.accounting_class_code, xlal.accounting_date transaction_date, h.period_name je_period_name, xlate.transaction_number transaction_number FROM gl_je_batches b, gl_je_headers…
Read MoreERP Cloud Financials Fusion – Cash Management Auto Reconciliation
ERP Cloud Financials Fusion – Cash Management Auto Reconciliation Introduction Bank Statement Reconciliation – Match Statement Lines and Transactions – Automatic and Manual Reconciliation – 1 to 1, 1 to…
Read MoreCreating a Supplier in Oracle Fusion 24D
Creating a Supplier in Oracle Fusion Creating a supplier in Oracle Fusion involves several key steps to ensure accurate setup and integration within your procurement processes. Here’s…
Read MoreAR Customer Collector Portfolio Report
Introduction: This blog has the SQL query that can be used to pull the data for the AR Customer Collector Portfolio Report Cause of the issue: Business wants to see the Customer Collector Portfolio Details How do we solve: Create a BI report in fusion using below SQL query to extract the details. SELECT customer_name, account_number, portfolio, portfolio_description, business_unit, account_profile_class_effective_end_date, account_profile_class, account_profile_collector FROM ( SELECT hp.party_name customer_name, hca.account_number account_number, hca.attribute10 portfolio, ( CASE WHEN hca.attribute10 = ‘Default – Portfolio’ THEN ‘Portfolio Default for Unclassified Customer Accounts’ WHEN hca.attribute10 != ‘Default – Portfolio’ THEN hca.attribute10 END ) portfolio_description, hou.name business_unit,…
Read More