Posts by Prem Singh

Query Project Agreement with Project Details.

SELECT d.customer_id, ppc.customer_name, d.agreement_type, d.description agreement_desc, d.CUSTOMER_ORDER_NUMBER, AGREEMENT_NUM,TRUNC(D.CREATION_DATE) AGGREMENT__DATE, TRUNC(D.LAST_UPDATE_DATE) AGREMENT_LAST_UPDATE_DATE, SEGMENT1 PROJECT_NUMBER, c.project_type, LONG_NAME PROJECT_LONG_NAME, ALLOCATED_AMOUNT, TRUNC(PPF.CREATION_DATE) funding_creation_date, TRUNC(PPF.LAST_UPDATE_DATE) funding_last_update_date, PPF.FUNDING_CURRENCY_CODE, PPF.PROJECT_CURRENCY_CODE, PPF.PROJFUNC_CURRENCY_CODE, PPF.PROJFUNC_ALLOCATED_AMOUNT, submit_baseline_flag FROM pa_project_fundings PPF, pa_projects_all…

Read More

API to Check the Available credit On a Sales Order.

DECLARE l_header_id NUMBER; l_calling_action VARCHAR2 (200); l_msg_index NUMBER; l_error_message VARCHAR2 (2000); x_msg_count NUMBER; x_msg_data VARCHAR2 (200); x_result_out VARCHAR2 (200); x_return_status VARCHAR2 (200); BEGIN l_header_id := 885421; l_calling_action := ‘BOOKING’; x_msg_count…

Read More

API TO CANCEL PO invoice

API TO CANCEL PO invoice AP_CANCEL_PKG.IS_INVOICE_CANCELLABLE: —- CREATE OR REPLACE PROCEDURE XXDOYEN_INV_CANCELLABLE (p_inv_id IN NUMBER) is v_boolean BOOLEAN; v_error_code VARCHAR2(100); v_debug_info VARCHAR2(1000); begin v_boolean :=AP_CANCEL_PKG.IS_INVOICE_CANCELLABLE( P_invoice_id => p_inv_id, P_error_code =>…

Read More

Script to extract Expenses SLA Details

SELECT aerh.invoice_num “Report_Number”, papf.full_name “Employee_Name”, papf.employee_number “Emp_Number”, hou.NAME “Operating_Unit”, aerh.total “Amount”, aerh.default_currency_code “Currency”, (SELECT meaning FROM apps.fnd_lookup_values WHERE lookup_type = ‘EXPENSE REPORT STATUS’ AND LANGUAGE = ‘US’ AND lookup_code =…

Read More

Script to extract Goods Received Date for Suppliers along with Invoice and PO Information

select (select hou.name from apps.hr_operating_units hou where organization_id = (select org_id from apps.ap_invoices_all apa where apa.vendor_id = ap.vendor_id order by creation_date fetch first 1 row only)) “Entity_OU”, TO_CHAR(ap.creation_date,’DD-MON-YYYY’) “Vendor_Creation_Date”, fu.user_name…

Read More

AP Web Report Workflow Status

SELECT ‘WPAY’ TYPE, gl.segment1 division, gl.segment3 dcc, gl.segment4 ccc, h.report_submitted_date creation_date, (TRUNC (SYSDATE) – TRUNC (h.report_submitted_date)) days_old, NULL timeout_date, NULL manager_level, TO_CHAR (h.report_header_id) report_header_id, h.invoice_num invoice_num, h.description description, p.full_name requestor,…

Read More

Back to Back Sales Order Cycle Setups and Process Flow in R12

Back to Back Sales Order Cycle Setups and Process Flow in R12   back-to-back-sales-order-cycle-setups-and-process-flow-in-r12  

Read More

Updating Unit List Price in Blanket Sales Agreement in R12

Updating Unit List Price in Blanket Sales Agreement in R12.2 updating-unit-list-price-in-blanket-sales-agreement-in-r12

Read More

Blanket Sales Agreement with Approvals and Release in Oracle R12

Blanket Sales Agreement with Approvals and Release in Oracle R12 blanket-sales-agreement-with-approvals-and-release-in-oracle-r12

Read More

Oracle EBS R12 PO Receipt Inbound Interface with WEB ADI

PO Receipt WEB ADI Interface: This is a interface, in Oracle EBS using web ADI, push raw data in custom staging table and then custom program does all validation and…

Read More