Introduction: You can’t provide an account assignment for credit memo transactions when the AR: Use Invoice Accounting for Credit Memos profile option is set to Yes. Cause: RA_INTERFACE_DISTRIBUTIONS_ALL tab should…
Read MoreIntroduction: This is used to fix the invalid revenue account for AR invoice Auto accounting is used to determine the accounts when the distribution table is not populated. When Auto…
Read MoreIntroduction : The below queries will help us to upload the output file in UCM server and send mail to respective mail id in fusion. Upload file to UCM: select…
Read MoreIntroduction: This report will display the HSN summary details. SELECT ‘HSN Summary’ inv_type ,hsn_data.supp_gstin s_gstin ,hsn_data.period inv_period ,hsn_data.item_nm item_name ,hsn_data.hsn_sac hsn_sac_code ,hsn_data.uom_code trx_uom_code ,SUM(hsn_data.trx_line_qty) trx_line_quantity ,SUM(hsn_data.taxable_amt) taxable_amount ,hsn_data.SGST_RT SGST_RATE ,SUM(hsn_data.SGST_AMT)…
Read MoreIntroduction This will displays the journal entry details SELECT DISTINCT –LEG_ENT.COUNTRY, (select DISTINCT HRL.COUNTRY from apps.XLE_ENTITY_PROFILES LEP, apps.XLE_REGISTRATIONS REG, apps.HR_LOCATIONS_ALL HRL, apps.gl_ledgers gl, apps.HR_OPERATING_UNITS HRO where LEP.TRANSACTING_ENTITY_FLAG = ‘Y’ and…
Read MoreIntroduction: This will displays the Audit time taken for expenses CREATE OR REPLACE FUNCTION TIME_TAKEN(P_REPORT_HEADER_ID IN NUMBER,P_AUDIT_COMPLETE_DATE IN VARCHAR2,P_CLAIM_APPROVED_DATE IN VARCHAR2) RETURN VARCHAR2 IS LS_AUDIT_TAKEN VARCHAR2(100):=0; BEGIN SELECT SUM((TO_DATE(B.CASE_TIME,’DD-MON-YYYY HH24:MI:SS’)-TO_DATE(B.End_Dated_time,’DD-MON-YYYY…
Read MoreIntroduction: This will displays all the unpaid invoices details select hrou.name Operating_Unit, api.invoice_num Invoice_Number, decode(aid.MATCH_STATUS_FLAG, ‘A’,’Validated’, null, ‘Never Validated’, ‘N’, ‘Never Validated’, ‘T’,’Validated’, ‘S’,’Needs Revalidation’, aid.MATCH_STATUS_FLAG) Invoice_Status, api.invoice_date Invoice_Date, aps.segment1…
Read MoreIntroduction: The will displays all the Paid invoices details . Select “Operating Unit” ,”Invoice Number” ,”Invoice Date” ,”Supplier Number” ,”Supplier Name” ,”Supplier Site” ,”Supplier Pay Terms” ,”Supplier Payment Method” ,”Supplier…
Read MoreIntroduction: This report will display all the Non printed invoices details to business. select (SELECT B1.ACCOUNT_NUMBER FROM apps.hz_cust_accounts_all B1 WHERE A.BILL_TO_CUSTOMER_ID=B1.CUST_ACCOUNT_ID)ACCOUNT_NUMBER, (SELECT E.PARTY_SITE_NUMBER FROM apps.hz_cust_acct_sites_all C, apps.hz_cust_site_uses_all D, apps.hz_party_sites E,…
Read MoreIntroduction: This XML data tempalte will help us to create a AR Applied Register Report in Excel format <?xml version=”1.0″ encoding=”UTF-8″?> <dataTemplate name=”xxxxx” Version=”1.0″> <parameters> <parameter name=”p_org” dat_idaType=”varchar2″ /> <parameter…
Read More