Shulou(Shulou.com)06/01 Report--

Oracle EBS development of common problems and solutions, I believe that many inexperienced people do not know what to do, so this paper summarizes the causes of the problems and solutions, through this article I hope you can solve this problem.

Some minor problems are often encountered in EBS Form development so that you don't remember why you encounter them again.

1. Form with stacked canvas, such as content canvas Astacked canvas B, these two canvas on WINDOW M, B canvas disappears when the cursor moves over the last Item of A (for example, z) (you can use the Tab key to move the cursor to it, that is, display).

Cause: B and A.z cover each other, that is, there are overlapping areas.

Solution: increase the distance between Item.

(1-1) sometimes you will find that a certain stacked canvas is not displayed. Adjust the order of the canvas in the tree structure (it is best to adjust the order of the item, because it will also have an impact), content in front, followed by stacked Aline stacked B.

1-2) one content canvas (Main) and two stacked canvas (ApoB). It is found that only the item on content canvas is displayed.

Cause: because you are testing, there is no content on B, only view stacked canvas An is selected. The symptom is that the content of An is not displayed, and A will be switched out only when you use the TAB key. The reason for this is that although B does not show, it also exists, and it is a large blank, covering A. -- shit...

1-3) sometimes the view--stacked canvas selects the stacked canvas to be displayed, but does not show it. See if the height and width of the port in the view of the stacked canvas is 0.

two。 When using LOV in Form, the statements in the Record Group of LOV are not useful'- 'what Mark dropped is in it. If there is any, all the statements after'-'will be dropped by mark, because the Query statements of Record Group will all be put on one line. Remember

3.Set_item_instance_property () is used to change the properties of a column, such as displaying special colors, etc.

4. The background color and foreground color of the check box cannot be displayed as canvas background color and white character.

Solution: change the background color and foreground color to another color, and then change it back to automatic, automatic, transparent.

5. Do a test Form of Tab Page with emp, and report an error when opening Form in Application

Developer error: set_window_position called with invalid relation:EMP

Solution: it turns out to be PRE-FORM. App_window.set_window_position ('EMP',' FIRST_WINDOW') in Trigger; written as

App_window.set_window_position ('EMP',' EMP'); replaced 'FIRST_WINDOW' with the WINDOW name.

Remember here: just write the corresponding BLOCKNAME.

6. FRM-30100:Block must have at least one primary key item.

Block:B_XXXX

Form.:F_XXXX

FRM-30085: Unable to adjust form. For output

Solution: change the DML Data Target Name of Block to None.

7.

The block based on view is grayed out after the CRTL+F11 query and cannot be added. When the screen is closed and reopened, the screen displays normally. Once the query is completed, it changes.

It's gray.

Solution: normal after adding on-insert Trigger.

8.Block data source is view, and there is a paragraph in on-insert Trigger that captures the ROWID generated by DB and assigns it to the corresponding block after inserting data.

The test runs Form, while saving Times error: on-insert throws an exception for no-data-found. Remove the statement to catch ROWID, the test is normal, and check that the rowid generation in DB is also positive.

Chang, then I took a look at Form. The ROW_ID item of block is miserable. I don't know how the length becomes 4.

9. Sometimes you assign a value to a non-database item to be displayed in post-query, which will result in being left unaltered when the mouse switches to another record and when the query is finished.

Prompt whether you want to save the changes.

Set_record_property (: system.trigger_record,:system.trigger_block, STATUS,QUERY_STATUS) is written in Solution:POST-QUERY

10.SET_ITEM_PROPERTY is used to set a property of an ITEM, which can be said to set a property of an Item in the Block as a whole, and sometimes to set the Item property in a record (such as the current record), so that you can use SET_ITEM_INSTANCE_PROPERTY.

The insert_allowed property of 11.Block is set to Y, and in when-new-block-instance, use set_block_property to set insert_allowed to false, so that the button for adding records will be lit, but you cannot add new records.

The delete_allowed property of Block is set to YMagneDML data source type to none, so the delete button lights up, but the record cannot be deleted. When you click the delete button, you will be prompted to need ON-LOCK trigger.

twelve。 If you assign an item with select into in post-query, the database item property of the item must be set to No, otherwise there will be a prompt box after the ctrl+f11 query

Frm-41050: You cannot update this record.

13. Compilation Times error: error 0 occurs on line 0, column 0

Compilation unit analysis terminated

The compiler reports this error when the spec and body parameters of procedure and others are inconsistent.

14. Use the code in Button to control and modify the DB data, but the data is not displayed on the Form screen. When you press Button, you will prompt FRM-40401: No changes to save

Solution: write: System.Message_Level: = 25 before update and commit

15. Sometimes if you want to gray Button after it is pressed, you can't write set_item_property (blk.itm,enabled,property_false) in when-button-pressed; if you change your state, you can only change something else, where feasible, you can make a block perform execute_query here, and then use the condition to gray this button in post_query.

16. There is often an id field that automatically plugs the value of sequence when it is recorded by insert. In this case, it is best to assign sequence.nexval to block.item in per-insert instead of writing insert into xx (id,...) directly in insert statements. Values (sequence.nextval,...), because when you write like this, block.item is still worthless, so you need to take the corresponding ID value from DB and assign it to block.item after insert is completed. Otherwise, it is easy to have problems. For example, if there is a detail block string passed by id, then when you save the record in detail block, you will mistakenly say that ID cannot be empty (it has been set to be not empty) or ID is stuffed with null value.

17. Current Record Visual Attribute Group, which can be used to make the current record show different colors

18. Query_find type Form, when closing result window, if the cursor is over the last block of the Window (multi-block), the cursor will go forward one block each time, and the window will not be closed until the first block.

In order not to change the content in app_custom

If (wnd = get_view_property (get_item_property (: SYSTEM.CURSOR_ITEM)

ITEM_CANVAS), WINDOW_NAME)) then

Do_key ('PREVIOUS_BLOCK')

End if

Hide_window (wnd)

The "previous navigation block" of each result block is changed to query_find block.

19. You can use APP_EXCEPTION.DISABLED; to disable KEY- buttons

If you write APP_EXCEPTION.DISABLED; in KEY-CLRREC Trigger, the erase button on the screen is bright but ineffective.

20. When you want to display Stacked canvas, use View--Stacked canvas, but there is no Stacked canvas you want to display in the list box, because the Window of Stacked canvas is different from the Window of Content canvas.

21. Note that if you re-use the data block wizard on the already established data block, such as adding fields (for example, if the source of the data block is a certain table, now you need to add a column in table and block, at this time, after adding columns in table, use the data block wizard to refresh table on block to call up a new item), it will restore the attributes of the currently established base table item! At this point, if you have set many non-default properties, it is best to add item manually.

The horizontal scroll bar position of the 22.Stacked canvas is determined by the lower boundary of the view port of the canvas itself, setting its view port lower bound to a position that is one more scroll bar than the lowest record of the canvas.

The width of the View port determines the event horizon width of the stacked canvas on the content canvas.

Sometimes it is found that when the horizontal scroll bar is pulled to the far left, the right boundary of the stacked canvas is far to the left of the vertical scroll bar. This is due to the wide canvasse of stacked canvas and should be set to stay close to the rightmost Item.

The vertical scroll bar of Stacked canvas is generally placed on content canvas (that is, it is generally set to block to display the vertical scroll bar, and to display the horizontal scroll bar in content canvas,stacked canvas, and to display in stacked canvas).

23.Tools and other menu items, for example, add special1 (special xx....) trigger at the form level, in which you can write the code to be executed for this menu item. Initializing this menu item can be implemented in when-new-form-instance with something like APP_SPECIAL.INSTANTIATE ('SPECIAL1',' generates detail data', 'POBKORD', TRUE);.

After the addition of Elements in List, the 24.LIST entry can not be deleted, so we have to delete the Item and build a new one. If there are too many Elements in List, it will be very troublesome and have to rewrite one by one.

Solution: use Shift+Ctrl+ less than the sign (Shift+Ctrl+ p_procedure_name

Argument = > p_argument

VALUE = > p_value)

END IF

END

thirty-six。 Create a new string value ORACLE_APPLICATIONS under HKEY_LOCAL_MACHINE\ SOFTWARE\ Oracle in the registry, set the value to TRUE, and reopen Form. Builder can see that all referenced objects are followed by an icon to make it easy to distinguish which objects are referenced and which belong to you.

thirty-seven。 Sometimes you will find that when you close FORM (click the fork in the upper right corner, F4 does not find this), Form is closed, but a red Progress Indicator progress bar is left behind, which cannot be closed. Please check whether the name in the APP_CUSTOM package has been changed to your first WINDOW.

38.Display item uses Lov to return the second value of Lov to some Database Item (this value is saved in DB), and the Record Group SQL of Lov excludes values that already exist in the database with not exists (), that is, every time a value is selected and saved, the value is no longer selected.

Symptom: when querying Form, Lov pops up and lets you select a value

Cause: when querying, the display value of Display item is obtained and assigned in Post-query by the DB item recorded by this record, due to the occurrence of Validation, which is no longer available in Lov.

Solution: add after assignment in Post-query

SET_RECORD_PROPERTY (: SYSTEM.TRIGGER_RECORD,:SYSTEM.TRIGGER_BLOCK, STATUS,QUERY_STATUS)

After reading the above, have you mastered the common problems and solutions in Oracle EBS development? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.