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 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 MoreOracle Query for the Users who have access to a particular form
select a.menu_id , menu_name , c.responsibility_name , g.user_name , g.description from fnd_menu_entries a , fnd_menus b , fnd_responsibility_vl c , fnd_form_functions d , fnd_form_vl e , fnd_user_resp_groups f , fnd_user…
Read MoreOracle PO Inbound interface EBS
CREATE TABLE xxcus.XX_PO_HEADERS_STG ( INTERFACE_HEADER_ID NUMBER , BATCH_ID NUMBER, INTERFACE_SOURCE_CODE VARCHAR2(25), PROCESS_CODE VARCHAR2(25), ACTION VARCHAR2(25), GROUP_CODE VARCHAR2(25), ORG_ID NUMBER, DOCUMENT_TYPE_CODE VARCHAR2(25), DOCUMENT_SUBTYPE VARCHAR2(25), DOCUMENT_NUM VARCHAR2(20), PO_HEADER_ID NUMBER, RELEASE_NUM NUMBER, PO_RELEASE_ID…
Read More