SQL query

Customer Account Import Error Query – FBDI

The below query extracts the error details along with interface attributes of Customer Account import using FBDI in Fusion Applications. SELECT distinct err.message_name ERROR_MESSAGE ,msg.message_text MESSAGE_TEXT ,acc.* FROM hz_imp_errors err…

Read More

GL 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 More

Drill 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 More

ISO Receipt Register -GST Query

SELECT shipment_num, shipped_date, stnno, receipt_num, rcvd_date, send_orgid,        send_orgname, recv_orgid, recv_org_name, gst_no, segment1, description,        lot_num, pri_rec_uom, uomcode, LINK, rcv_qty, iso_price, iso_price_uom,        NVL (tax_amount, 0) tax_amount,        ((rcv_qty *…

Read More

SQL to Find Employee – Supervisor Hierarchy details

Background The Purchase order or Requisitions are not valid unless it is approved. In any of the procurement process, most of the issues occur in the approval of the purchasing…

Read More