Oracle EBS OAF Personalization vs Forms Personalization – Understanding the Difference Introduction Oracle E-Business Suite (EBS) provides multiple ways to customize standard application behavior without modifying Oracle’s seeded code. Two…
Read MoreIntroduction / Issue As part of TCA, the supplier needs to be linked to the party. This API establishes the link between the Party and the Supplier. Why We Need…
Read MoreIntroduction/ Issue: This blog contains an API and that can be used in Oracle EBS to create Quality samples and the corresponding results. Why we need to do / Cause…
Read MoreIntroduction/ Issue: This blog contains an API and that can be used in Oracle EBS to create Routings and assign resources. Why we need to do / Cause of the…
Read MoreIntroduction In the oracle EBS the concept of Purging and before purging the order management related tables, pre-requisite to be done for the smooth purging process. The below script will…
Read MoreIntroduction/ Issue: This SQL query is designed to extract Batch Header and Material Details from Oracle Process Manufacturing (OPM). It consolidates information such as company code, plant, batch number, recipe,…
Read MoreCREATE 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 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 MoreIntroduction: This SQL query is fetching the data of Tax reporting type code details by passing the tax regime. Cause of the issue: To find if any of the tax…
Read MoreIntroduction: This SQL query is fetching the data of India customer’s transaction with the company and the customer GST details. Cause of the issue: To find out the customers GST…
Read More