Item Where Used Extract Query
Introduction: This SQL query is used to fetching the data of FG Items where used details like Component Item, Component Item Description, Parent ,Parent Item Description, Item Seq, Effettivity…
Read MoreBill of Materials Explosion Extract Query
Introduction: This SQL query is used to fetching the data of Bill of Materials Explosion details like Order Level, Root Assembly, Assembly Item, Assembly Item Description, Assembly Item Type,…
Read MoreService contract reconciliation Report
SELECT okha.sts_code,okha.scs_code,okha.date_approved,okha.estimated_amount, xscb.price_list_id, xscb.customer_bill_to_number, xscb.customer_ship_to_number, xscb.contract_number, xscb.contract_type, xscb.cognomen, xscb.start_date, xscb.end_date, qslh.NAME AS price_list_name, ood.organization_code AS inventory_org_code, hou.NAME AS operating_unit_name, customer, xscb.payment_term, NULL price_list, line_item, DECODE (TRIM (xscb.err_msg), ‘/’, ‘SUCCESS’, xscb.err_msg)…
Read MoreTXK Delta 13 failed due to missing files
TXK Delta 13(32392507) plus critical TXK patches 33550674, 33535778 failed because of missing files adsign.txt and adkeystore.dat under $APPL_TOP_NE/ad/admin The Solution: The apply phase failed twice, once when looking for…
Read MoreAdop Phase=cutover Failing With AutoPatch – AidafoGetFileDbVersion: INFO: ORA-01403: No Data Found
AutoPatch – aidafoGetFileDbVersion: INFO: ORA-01403: no data found when apply adop phase=cutover failing with AutoPatch Please follow below steps to overcome this issue Confirm that value for READ_ONLY_FLAG and ENABLED_FLAG…
Read MoreTally Integration
Tally Data Integration & Data Migration Tally Integration : Comprehensive and medium-scale organizations use different applications to maintain their business and one of the important areas involved in these applications…
Read MoreAP Invoice To GL Link Query with additional attribute values
This query to Trace an AP Invoice to the GL. There is an Invoice in AP which is correctly Validated, Accounted, Approved etc. This will useful To find the GL…
Read MoreAP Bank details query with additional attributes values
The supplier (or External) bank account information are stored in the table called ce_bank_accounts. The bank and bank branches information are stored in CE_BANK_BRANCHES_V This script used to get bank…
Read MoreWorkflow Script Deassign user from role
Oracle Workflow delivers a complete workflow management system that supports business process based integration. Its technology enables modeling, automation, and continuous improvement of business processes, routing information of any type…
Read MoreGL Flexi ield Query with additional details
GL module used to maintain credit and Debit details in oracle. Gl code combinations are used maintain details of company with respect to legal entity level. This script used to…
Read More