Delivery Challan with GST Details
Introduction This Post is Described about the Delivery Challan with GST Details in ebs r12 Query retrieves data of those inventory items which are used for promotional purposes or…
Read MoreTAX INVOICE RCM(REVERSE CHARGE MECHANISM) – GST
The below query fetches the details of a tax invocie where in Reverse charge mechanism(RCM) is applied in order to claim the extra tax paid by an organization along with…
Read MoreReturn To Vendor Summay-GST
Introduction The below query fetches the data of purchase order wherein those items present in purchase order needs to be returned to Supplier because of some damage caused to goods…
Read MoreRMA Receipt Query-GST
Introduction This Post Is Described about the RMA Receipt Query-GST In oracle apps R12. select orgid,ORGCODE, ORGNAME, account_number, party_name,city, LINE_NUMBER, trx_number,trx_date, location, src_number,src_date,rma_gross,TAX_RATE_PERCENTAGE, interface_header_attribute2,reason_code,CGST,SGST,IGST,VAT,CST,(nvl(rma_gross,0) + nvl(CGST,0) + nvl(SGST,0) +…
Read MoreGL Account analysis for PA Expenditure & Event query
Introduction This Post illustrates the steps required to get the General ledger analysis for PA Expenditure & Event in oracle Apps Script for GL Account analysis for PA Expenditure &…
Read MoreFast Index Scan, Index Scan, Partition Range Scan and Full Table Scan
Description: A full index scan is where Oracle reads the data from the index, and the index is in the order required by the query. A fast full index scan is similar to a full index scan. This type of scan happens when…
Read MorePDF Password Protection in BI Publisher
Description: This password is required for opening the document. It enables users to open the document only. This property is enabled only when “Enable PDF Security” is set to “true.”…
Read MoreManual AR Invoice Creation with GST
Description Invoices and Credit Memos in Oracle AR: Invoice: A document that will convey how much the customer has to pay for the goods and services he has bought and…
Read MoreBI Bursting
Description: A bursting definition is a component of the data model. After you have defined the data sets for the data model, you can set up one or more bursting…
Read MoreWater Mark Text in XML Publisher report
Description: Watermarking enables certain rights over content, which has been successfully applied in multimedia applications. However, it is not trivial to use the known effective watermarking schemes to XML…
Read More