Daily Archives: March 26, 2025

Query 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 More

Query 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 More

API 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 More

Employee 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 More

GL & 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 More

ERP 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 More

Creating 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 More