Introduction: This query will fetch you the pricelist name, start date, end date and price of the item. The input parameter passed is item name which will get processed and provide you with the [...]

Introduction: This query will fetch you the party and location details for a sales order. The input parameter passed is ‘Sales order number’which will get processed and provide you with the [...]

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 can [...]

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 [...]

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, [...]

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, [...]

API to Load Values into Value Sets DECLARE —————————-Local Variables————————— [...]

 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    [...]

— 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, [...]

ERP Cloud Financials Fusion – Cash Management Auto Reconciliation Introduction Bank Statement Reconciliation – Match Statement Lines and Transactions – Automatic and Manual Reconciliation – [...]