Some times while developing XMLP layouts we see that xml data tags automatically changes to , its all because of fields compatibility with MS Word.… Read More »XMLP: XML-22008: (Error) Namespace prefix ‘ref’ used but not declared –
Once I had a requirement to copy some files from APP sever to DB server of same instance on regular intervals. We can achieve this… Read More »SSH-KEYGEN Password Less Entry Setup to connect from one server to another server without Password
To run a unix based shell script as a concurrent program, the executable of the concurrent program should be registered as a ‘Host’ program. The… Read More »What is Host Program? How to create Host Program? and What is .Prog file?
Generally to default a Sales Order Attribute programmatically, we need to set the attribute value in its global record, ont_header_def_hdlr.g_record. for Sales Order Header and… Read More »Steps to Default a Sales Order Attribute when there is no Defaulting rule for that Attribute
Here in this article I will be writing how to read a CLOB file using DBMS_LOB which is more than 32kb size. The below example… Read More »PL/SQL Script to read CLOB(XML Data) which is more than 32kb size
Short Cut Description Ctrl+Space Invokes code insight on demand Ctrl+Up Replaces worksheet with Previous SQL from SQL History Ctrl+Down Replaces worksheet with Next SQL from… Read More »Frequently used Oracle SQL Developer Short Cut Keys
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 SELECT… Read More »Oracle HRMS SQL Query to find out Employee and their Supervisor Hierarchy
If Invoice not interfaced 1. Order Type workflow assignments to check if there is an invoicing node. 2. From Order –> Lines go to Tools… Read More »Sales Orders not getting Invoiced
Click on the question to see the answer Order Management Functional Interview Questions What setups are mandatory to create and transact an Internal Sales Order?… Read More »Order Management Functional and Technical Interview Questions with Answers
Oracle has provided an API IEX_DISPUTE_PUB.CANCEL_DISPUTE which is part of Advanced Collections to cancel a dispute on an Invoice Transaction. Below is the sample API… Read More »PL/SQL API to Cancel Dispute on an Invoice Transaction