Supplier Import process through FBDL (File based data loader) Template
supplier_.import_fbdldocx
Read MoreSplit Sales Order Line using script.
Shipment is happening from third party system and if partial shipment is happening then sales order line should be split based on balance quantity and with shipped quantity line should…
Read MoreFND_FILE.PUT_LINE CLOB file writing causes error.
Need to write output file using CLOB variable which contains more than 32767 bytes of data even it may contain up to 8 GB data. If it exceeds more than…
Read MoreExplore/Explore BOM components for a config item
PROCEDURE xxbom_explode_bom_for_abc(i_item_id IN NUMBER, i_organization_id number, i_num_so_line_id number) IS g_chr_excp_msg VARCHAR2(4000); g_chr_log_msg VARCHAR2(4000); g_dte_sysdate DATE := SYSDATE; g_num_elig_comp_exist NUMBER := 0; g_num_item_inc NUMBER := 0; v_num_boe_open_qty NUMBER; v_num_bill_sequence_id NUMBER; v_rec_inc…
Read MoreTransfer file from PL SQL to third party system using java concurrent program
Transfer the CLOB variable to third party system using https protocol and java concurrent program. package xxpo.ebs; import java.io.IOException; import oracle.apps.fnd.cp.request.CpContext; import oracle.apps.fnd.cp.request.JavaConcurrentProgram; import oracle.apps.fnd.cp.request.LogFile; import oracle.apps.fnd.cp.request.ReqCompletion; import oracle.apps.fnd.util.NameValueType; import…
Read MoreQuery to Get Employee Leave Details in Project
SELECT PAPF.EMPLOYEE_NUMBER, PAPF.FULL_NAME “EMPLOYEE NAME” , PT.DESCRIPTION “LEAVE DESC”, TO_DATE(trunc(ei.EXPENDITURE_ITEM_DATE),’DD-MON-YYYY’) “DATE”, EI.QUANTITY “LEAVE HOUR”, PEC.EXPENDITURE_COMMENT FROM pa_projects_all p, pa_tasks Pt, pa_expenditure_items_all ei, pa_expenditures_all x, pa_project_types_all pta, pa_transaction_sources tr, hr_all_organization_units_tl o1,…
Read MoreQuery to Get AP Expense Report Made By an Employee
SELECT GSOB.NAME “SOB Name”, AEH.INVOICE_NUM “Report Number”, AEH.TOTAL, AEH.DESCRIPTION, PPX.FULL_NAME, PPX.EMPLOYEE_NUMBER, decode(AEH.WORKFLOW_APPROVED_FLAG,’S’,’SAVED’,’I’,’IMPLICIT SAVE’,’R’,’MANAGER REJECTED’,’M’,’MANAGER APPROVED’,’P’,’PAYABLES APPROVED’,’A’,’AUTO APPROVED’,’W’,’WITHDRAWN’,’Y’,’APPROVED’,’IN PROGRESS’) Status, (SELECT APPS.AP_WEB_POLICY_UTILS.GET_LOOKUP_MEANING(‘EXPENSE REPORT STATUS’, DECODE(AI.CANCELLED_DATE, NULL, AEH.EXPENSE_STATUS_CODE, ‘CANCELLED’)) FROM APPS.AP_INVOICES_ALL AI…
Read MoreQuery Project with Revenue Amount Along with Event Details
BEGIN mo_global.set_policy_context(‘S’,84); END; SELECT project_number, project_name, :p_gl_period MONTH, ou.NAME org_name, (SELECT revenue_amount FROM pa_events_v pae WHERE pae.event_id = pee.event_id AND UPPER (event_type) = UPPER (‘Revenue’)) rev_amt, NULL inter_crev_amt, NVL ((SELECT…
Read MoreQuery Project Unbilled Amount
SELECT TO_CHAR(TRUNC(PE.CREATION_DATE),’MON-YYYY’) MONTH, (SELECT NAME FROM HR_ORGANIZATION_UNITS WHERE organization_id =ppa.carrying_out_organization_id ) Business_unit, PPA.SEGMENT1 PROJECT_NUMBER, PPA.NAME PROJECT_NAME, PPC.CUSTOMER_NAME CUSTOMER_NAME, XX_GET_AGREEMENT_NUM(ppa.project_id) AGREEMENT_NUMBER, (CASE WHEN ppc.customer_id in (22222,33333,44444,55555) THEN ‘Internal’ ELSE ‘External’ END)…
Read More