Recommended way to download latest templates from Fusion Application before using and loading the dat files in HCM. For Steps download and follow the below document. template-file-for-business-object
Read MoreHCM Data Loader Error Analysis Report The HCM Data Loader Error Analysis Report is a diagnostic test. It provides technical information that can help to resolve data-loading errors. Run this…
Read MoreThings to remember before loading Grade.dat file 1. SourceSystemOwner should be defined in Oracle fusion Application System 2. Effective Start Date and Set Code are Mandatory. 3. Always pass the…
Read MoreBelow is the sample HDL file for Organization.dat file METADATA|Organization|EffectiveStartDate|EffectiveEndDate|Name|ClassificationCode|LocationCode(SourceSystemId)|LocationSetCode|SourceSystemOwner|SourceSystemId MERGE|Organization|1901/01/01|4712/12/31|ABC CORP|DEPARTMENT|Delhi|COMMON|EBS|HCM_ORG_ABC_CORP_TEST Points to Consider 1. SourceSystemOwner is defined in Oracle Fusion Lookup 2. Location Code will be used as…
Read MoreHere below is the format of the Location HDL file. METADATA|Location|SetCode|ActiveStatus|EffectiveStartDate|EffectiveEndDate|ShipToSiteFlag|BillToSiteFlag|OfficeSiteFlag|ReceivingSiteFlag|ShipToLocationCode|ShipToLocationSetCode|InventoryOrganizationName|LocationCode|LocationName|AddressLine1|AddressLine2|AddressLine3|Country|PostalCode|TownOrCity|MainphoneSubscriberNumber|OtherphoneSubscriberNumber|Description|Region1|Region2|Region3|SourceSystemOwner|SourceSystemId MERGE|Location|COMMON|A|1901/01/01|4712/12/31|Y|Y|Y|Y||||00002|New Delih||Janakpuri|New Delhi India|IN|234432|Delhi|||Delhi||||EBS|HCM_LOCTAION_00002_XXTEST Points to Ponder before loading Locations HDL file: 1. SourceSystemOwner and SourceSytemID must be unique…
Read Moreselect a.lookup_type Lookup_type_name,a.meaning Lookup_type_meaning,flv.lookup_code lookup_code_name,flv.meaning lookup_code_meaning, flv.description,flv.enabled_flag,flv.start_date_active,flv.end_date_active, decode(flv.created_by,’SEED_DATA_FROM_APPLICATION’,’Standard’,’Custom’),b.module_name from fnd_lookup_types_vl a, FND_APPL_TAXONOMY b, fnd_lookup_values_vl flv where 1=1 –and a.lookup_type=’BARGAINING_UNIT_CODE’ and a.module_id=b.module_id and upper(b.module_name) like ‘HCM%’ and a.lookup_type=flv.lookup_type –and flv.created_by=’SEED_DATA_FROM_APPLICATION’
Read MoreCREATE OR REPLACE PACKAGE BODY APPS.XXWEBADI_MTL_ONHANDQTY_PKG AS PROCEDURE XXWEBADI_MTL_ONHAND_QTY_INS ( errbuff OUT VARCHAR2, retcode OUT NUMBER ) IS LV_BATCH_MODE VARCHAR2(3); LN_BATCH_ID NUMBER; LV_ERROR VARCHAR2(240) := ‘Unable to load reocords in…
Read MoreBelow is the query to extract Payroll data from General Ledger, historical data for a week. select gjl.je_line_num, gcc.concatenated_segments, nvl(gjl.entered_dr,0) entered_debit,nvl(gjl.entered_cr,0) entered_credit,gjl.description from gl_je_lines gjl,gl_code_combinations_kfv gcc, gl_je_headers gjh,gl_je_sources gs,gl_je_categories gc…
Read MoreBelow is the query to fetch the details of unpaid and partially invoices SELECT Ledger_name, po_number, ORDER_DATE, TRANSACTION_DATE, VENDOR_NAME, CATEGORY_SEG, ITEM_DESCRIPTION, LINE_TYPE, ASSET_DESC, PROJ_NUM, LINE_NUM, SHIPMENT_NUMBER, QUANTITY_RECEIVED, QUANTITY_BILLED, UNIT, PO_UNIT_PRICE,…
Read MoreBelow is the query to get the GST applied for Invoices, Credit memos and Debit memos WITH Parameter AS (SELECT to_date(:P_Transaction_Start_Date,’YYYY/MM/DD HH24:MI:SS’) AS BV_Transaction_Start_Date , to_date(:P_Transaction_End_Date,’YYYY/MM/DD HH24:MI:SS’) AS BV_Transaction_End_Date, to_date(:P_GL_Start_Date,’YYYY/MM/DD…
Read More