Pre-requisite for the Sales Orders purging
Introduction 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 MoreOPM Uncompleted batches query
Introduction/ 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 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 MoreOracle Fusion query to get the Tax_Reporting_Type_Code_For_a_Tax_Regime
Introduction: 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 MoreOracle Fusion India_Customer_Trx_GST_Details_Query
Introduction: 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 MoreQuery to get project and task details – Fusion
Query to get Projects and Tasks Details – Fusion SELECT TO_CHAR(PPA.PROJECT_ID) PROJECT_ID ,TO_CHAR(PPA.SEGMENT1) PROJECT_NUMBER ,PPA.NAME PROJECT_NAME ,PPA.DESCRIPTION ,PPA.START_DATE ,PPA.COMPLETION_DATE ,PPA.CLOSED_DATE ,PTV.TASK_NUMBER ,TO_CHAR(PTV.TASK_ID) TASK_ID ,TO_CHAR(PPA.CARRYING_OUT_ORGANIZATION_ID) ORGANIZATION_ID ,HRU.NAME ORGANIZATION_NAME ,PPT.PROJECT_TYPE PROJECT_TYPE ,PPA.GROUP_SPACE_TEMPLATE_NAME…
Read MoreQueries to get Employee related information – Fusion
Query to Fetch Employee’s Legal Employer SELECT papf.person_number, hauft.NAME LegalEmployer FROM HR_ORG_UNIT_CLASSIFICATIONS_F houcf, HR_ALL_ORGANIZATION_UNITS_F haouf, HR_ORGANIZATION_UNITS_F_TL hauft, per_all_assignments_m paam, per_all_people_f papf WHERE haouf.ORGANIZATION_ID = houcf.ORGANIZATION_ID…
Read MoreWorkflow Fundamentals
Introduction to workflow Tool from Oracle Works with Oracle Database PL/SQL Based Widely Used with Oracle Applications Can be Used Stand-Alone or with Oracle Apps Need of workflow Workflow can…
Read MoreOracle BI Publisher report output sorting
We can sort data in XML report a group by any element within the group. Sort data based on Empno: Syntax: <?sort:Field_Name?><?Field_Name?> It sorts the data in ascending order by Default. If Order…
Read More