Others

A.First, the most important thing isPre-FormMultipleOu Begin App_standard.event ('pre-form '); //Must be inApp_standard.event ()Run later Mo_global.init ('inv ');--Parameters can be used'S '-SingleOu,'M '-MultipleOuOr the abbreviated name of

AP: 1. invoice register (invoice registration report) view invoice details in the system 2. invoice on hold report (invoice suspension Report) 3. Invoice aging report (invoice aging report) view supplier payable balance 4. view the payment

Lv_msg_count:APIReturn parameter, which is the number of messages. Adjust the number of cycles Based on the message details. When the number of messages is increased, more messages are sent, and less messages are sent.If lv_msg_count> 0 thenLv_mesg:

EBS environment: 11.5.10   Errbuf and retcode should be placed at the top of the page, and unexpected situations may occur if you do not submit a request.     Create or replace procedure xxske_auto_trx_overdue_mtl ( P_email in varchar2,

Form name: myformData Block name: myblockStep 1:Add the parameter wf_itemkey to the form.The data source of myblock must contain the wf_itemkey field.Modify or add a data block-Level Trigger: When-New-block-instanceIf: parameter. wf_itemkey is not

Typical Example: Check whether a record meets the . If yes, . For example, check whether an employee was hired last month. Poor SQL: Select Count(*) FromEMP WhereHiredate>Trunc (sysdate,'Mm'); This is a poor SQL statement, because we

In EBS, when a PDF file is generated, XML Publisher will call the OPP (output post processor) process in the background, which is processed by AQ, if AQ fails, an error will occur and no file will be generated. Therefore, the report compiled by

Prepayment Concept   Financial Accounting explanation: Enterprises sometimes need to pre-order certain materials, that is, to prepay part of the goods in accordance with the provisions of the purchase contract. This part of the pre-payment to

-Check the invoice and payment subject generated for the current month: 1. on the AP --- invoices ----- entry ---- invoices page, select the date of the current month, In the invoice status file, select "accounted" as "partial" and the query fails

In the secondary development of Oracle EBS, it is often necessary to display the summary of the amount or quantity in the detail block in the master block of the master-slave relationship. In Oracle form builder, the summary function is actually

-************************************ **************************************** ** -- punction: get Transaction date for API --***************** **************************************** * ******************* function get_date_f

1. Set setfnd_flex_val_api.create_valueset_independent (v_set_name , V_description , V_security , V_enable_longlist , V_format_type , V_maximum_size , V_numbers_only , V_uppercase_only , V_right_justify_zero_fill , V_min_value ,

In version 10.7-11.5.x, the multi-organization architecture ensures the data security of business units (OU). The underlying data table contains a column of ORG_ID to record the business continuity of the data, ALL base tables of multiple OU end

To use LOV in the FOLDER column.   Problem description: The KEY and VALUE of LOV. Example: 1 ORACLE 2 DB2 3 MYSQL   The expected effect of the description column in FOLDER is: Input O, directly corresponding to ORACLE, or use SHIT + F5 to

The ERP version is 11.5.7, the database code is American_America.ZHS16CGB231280, the SID is compard, and the version is 8.1.7.4. The following methods are similar in R12. 1. There is an export on the menu, which is a tsv file after export. You can

Attach the attach to the attach. After the Spring Festival holiday, many enterprises inevitably move their staff, adjust their structures, and the loss of key ERP users, coupled with inadequate training for new employees, therefore, after many

. Report ViewIn Data? Fnd_global.APPS_Initialize (user_id => 3070, Resp_id => 50650, Resp_appl_id = & gt; 20003 ); End; Oracle DefinitionCocurrent Programfnd_client_info.set_org_context (to_char (x_org_id )); QueryObtain the Muti-Org1begin

This article is about ROWID. Most of the knowledge in this article comes from the Internet, and I have studied it quite a little. If I do not understand it, I can refer to related resources on the Internet. In the previous research on indexes, we

Subqueries in select, update, and delete statements should regularly find less than 20% of table rows. if the number of rows queried by a statement exceeds 20% of the total number of rows, it cannot improve the performance by using indexes. The

1. First, find the main unit of the material and determine whether the unit conversion can be performed.  SELECT PRIMARY_UOM_CODE, ALLOWED_UNITS_LOOKUP_CODE FROM mtl_system_items msi, MTL_UNITS_OF_MEASURE MTLUOM2 WHERE msi. ORGANIZATION_ID = &