Form Personalization – How to Change Field Name Form Personalization feature allows us to alter the behavior of Forms-based screens, including changing properties, displaying messages etc.For a single form-function(a form running in a particular context based on parameters passed to it defined at function level) we can specify one or more Rules. Each Rule consists […]
Sometime I’m quite annoyed by the typo mistake when creating a DFF context. The DFF segment screen doesn’t allow deletion of context. Fortunately, Oracle has internal API to do such thing. Following is a sample. –******************************************* –* Delete a descriptive flexfield –******************************************* SET ECHO OFF SET FEEDBACK OFF SET SERVEROUTPUT ON SIZE 1000000 DECLARE l_application_id NUMBER := 0; l_descriptive_flexfield_name […]
Bug 1930586: MATCH_OPTION COLUMN/METHOD MISSING IN PDOI =========================================================================== PROBLEM DESCRIPTION =========================================================================== ** DESCRIPTION OF PROBLEM, INCLUDING ALL ERRORS: There is no column that accepts the value for match_option (invoice matching ‘P’or’R’) in PO_LINES_INTERFACE. (The enhanced PDOI now supports standard PO import.) If there is a method to populate the matching option […]
Check the process_code in the po_headers_interface and po_lines_interface, if it is ‘REJECTED’, select process_code from po_headers_interface;select process_code from po_lines_interface; please do the following:Run the program – Purchasing Interface Errors Reportchoose parameter : PO_DOCS_OPEN_INTERFACE The report will list all the errors you have during importing. You can fix the data, then reset process_code = Null in […]
Steps: 1. Personalize the form2. Create an action of type “BuiltIn”3. BuiltIn Type for Action should be “Execute a Procedure” 4. Argument should be as below =’declarev_field_value VARCHAR2(200) ;beginplsql_package.procedurenameHere ;end’ or alternately =’declarev_field_value VARCHAR2(200) ;beginXX_PRC(”’||${item.PO_CONTROL_RULES.OBJECT_CODE_DISPLAYED_VALUE.value}||”’);end’ Note the syntax, after =, entire declare begin end is within single quote.Also, there is no semi colon after “end” […]
Recent Comments