Posts

Change LOV Query for Invoice Line Type in Invoice Workbench

Image
R12: AP: How to Add Invoice Line Type In Payables Invoice WorkBench We can change the LOV query using form personalization. Sample provided below (Invoice Workbench form). Requirement:   We have to change the “item type” field lov query for populating the custom values. To achieve this, we have to follow below process. Step-1:   Login into application and switch the Payables Super User Responsibility. Nav->Invoices->Entry->Invoice. Consider the TYPE field (LINE_SUM_FOLDER. LINE_TYPE) Here Item Type  LOV currently shows 4 values . Instead we have the requirement to populate these values in the LOV. (Freight, Item, Miscellaneous, Tax, Supplement Charges)     Step-2:  Identify the form .fmb name (NAV:- Help->about oracle Applications) Step-3:  Connect to application server and download the .fmb (APXINWKB.fmb) from AU_TOP/forms. Open the form in form builder and check the LOV name for “type” field. Step-4:  Check the record group...
Post a Comment
Read more

EAM De-Activate Asset Number Parent Child Relationship using API in Oracle Apps

Hi Developers, Kindly find the script that i have created for where it will remove the Maintainable Flag and Deactivate the Asset at the same time. This API takes out the Parent Child Geneology and then Deactivate the Asset. Hope this helps the Developers Note: 1: You cannot Deactivate a Route Asset as this is intended functionality 2: You cannot Deactivate an Asset if there is Open Work Order or Work Requests for the Asset create or replace  procedure check_geneology        (p_item_instance in varchar2)     is         lc_exception   varchar2 (1000);         --Added for EAM geneology end date API         lc_child_serial varchar2 (200);         ln_child_inv_id number;         ln_child_org_id number;         ln_child_inst_number varchar2 (3000);         ln_child_inst_id number;   ...
Post a Comment
Read more