Project Expenditure Extraction Query
This query fetches all the expenses incurred on a project,and also captures the debit and credit account transaction wise that will help in reconcilation of data with GL. SELECT ei.expenditure_id,…
Read MoreAP Invoice Interface Errors & Fix
INVALID DISTRIBUTION ACCT DUPLICATE LINE NUMBER ZX_IMP_TAX_RATE_AMT_MISMATCH NO EXCHANGE RATE INVALID ASSIGNMENT INVALID DISTRIBUTION ACCT …
Read MoreSupplier Information including GST
The below query fetches all the supplier information including GST Info select (select name from hr_operating_units where organization_id=jpr.org_id) Operating_unit, APS.VENDOR_NAME supplier_name, APSA.…
Read MoreAPI to Create Bank Account Details
Below procedure will create Supplir Bank account details PROCEDURE create_banks_accounts(p_change_type VARCHAR2) AS ln_count NUMBER; ln_success_count NUMBER; ln_error_count NUMBER; ln_x_bank_id …
Read MoreTDS Register Report
Below query will display all TDS related details for GST implementations SELECT aia.invoice_date, aia.doc_sequence_value voucher_num, aia.invoice_num, aia.invoice_amount, aps.vendor_name party_name, (SELECT t.description FROM apps.ap_invoice_distributions_all apd,…
Read MoreRO Partywise Account Ledger Report
Below Query will fetch Vendor Wise RO Account Ledger details SELECT * FROM (SELECT asp.vendor_id, aia.gl_date accounting_date, …
Read MoreGL DRILL Down Query From GL into Cost Management Sub ledger Module.
The below query will provide the complete breakup of posted Journals with transaction distribution wise breakup details of Fixed assets(receiving,inventory, WIP sources) sub-ledger modules. –SK Receiving Source: SELECT …
Read MoreGL DRILL Down Query From GL into Fixed Assets Sub ledger Module.
The below query will provide the complete breakup of posted Journals with transaction distribution wise breakup details of Fixed assets(all sources) sub-ledger modules. SELECT GCC.concatenated_segments segments, …
Read MoreDrill Down Query From GL into Project Accounting subledger
The below query will provide the complete breakup of posted Journals with transaction distribution wise breakup details of Project Accounting sub-ledger modules. SELECT GLCC.concatenated_segments segments …
Read MoreMass Update For Supplier Invoice Match
Update the match_option column in AP_SUPPLIERS table. No Oracle API is available to change the Invoice Match Option from one value to another. This has to be manually done from…
Read More